This guide is part of the Microsoft Excel 2016 series
1.
How to add a background image in Excel 2016
2. How to add a column to a spreadsheet in Excel 2016
3. How to add a printer to the tool bar in Excel 2016
4. How to add a URL to Excel 2016
5. How to auto fit column width in excel 2016
6. How to change the colors of tabs in Excel 2016
7. How to convert a column into a row in excel 2016
8. How to create a drop down menu in Excel 2016
9. How to create a pivot table in excel 2016
10. How to disable the fill handle in Excel 2016
2. How to add a column to a spreadsheet in Excel 2016
3. How to add a printer to the tool bar in Excel 2016
4. How to add a URL to Excel 2016
5. How to auto fit column width in excel 2016
6. How to change the colors of tabs in Excel 2016
7. How to convert a column into a row in excel 2016
8. How to create a drop down menu in Excel 2016
9. How to create a pivot table in excel 2016
10. How to disable the fill handle in Excel 2016
Make: Microsoft
Model / Product: Excel
Version: 2016
Objective / Info: Learn how to create a drop down menu in Excel 2016. In this guide, we are using a spreadsheet with existing data but these steps should work in a blank spreadsheet as long as you add the data.
Model / Product: Excel
Version: 2016
Objective / Info: Learn how to create a drop down menu in Excel 2016. In this guide, we are using a spreadsheet with existing data but these steps should work in a blank spreadsheet as long as you add the data.
1
Open Excel by double left clicking the icon on the desktop or start menu or open the document that you want to work on.2
Click on the cell where you want to place the drop down menu. Note :
In this example, we are going to keep cell A1 and use the data in cells A2-A6 as drop down options so we select A2.
7
Click and drag across the cells that you want to include in your drop down list.
Note :
The source fields are the cells that contain the options that you want to appear in your drop down list. These cells can be located anywhere in your worksheet or workbook.
9
At this point you can click the cell and you should see a drop down list containing the data you selected.10
This task should be complete. Review the steps if you had any issues and try again.Submit questions or request for more guides in the questions section below.comments powered by Disqus