A drop down menu may be useful if you have a cell that has specified values. If an input value for a table is the month, a data validation may be used to insert a drop-down list.
- Select a specific cell where you would like the drop down menu to exist
- Select the Data tab in Excel and click on Data Validation.
- The Data Validation menu appears and under Allow: Select List as shown in the figure below.
-
Under the Source: you can type in specific values or you can select a list of cells that you would like to be displayed in the drop down menu. Select OK to finalize your list data validation.
-
The new cell has been list validated and when it is selected arrows appear that show a list of potential allowed inputs for that cell. You can select a value from the list and it will populate in the cell as shown in the below figure.
Dropdown menus can be utilized for many data input features like to select a product type, features or pricing.
If you are in Miami or Ft. Lauderdale, you may come to our classroom-based Excel training class.