About Drop-down Menus
Drop-down menus are graphical control elements, much like a word bank, that allows the user to select one item from a list. Drop-down lists come in handy when there is a finite number of possible values (either number or text). Using drop-down lists promotes higher productivity and accuracy.
Other names for the drop-down list include drop down, pull-down menu, pull-down list, drop menu, drop-down menu, and drop down menu.
First draft a list of valid entries on a sheet. Rearrange the entries to the desired order that they should appear. That will serve as the source for the drop-down list of data. I choose Yerkes luminosity star classes.
1. Open Excel.
2. Select a cell that will be the Header for your drop-down list. I chose B2. Then, type in the Header for your drop-down list. My Header is Star Types.
3. In the cells below your Header, type each entry into a cell in a single column. No empty cells.
4. Select Data from the menu bar.
5. Choose Data Validate.
6. Choose the Settings tab.
7. Then, in the Allow pop-up menu, choose List.
8. Click in the Source field. While holding down the Shift Key, click on the first item of your list, followed by the last item in your list. Notice the entire list outlined in green, and the range automatically entered into the Source field. Click OK.
9. Now, when someone clicks into that field, an Expansion button appears.
10. Click on the Expansion button and the drop-down list appears.