You can create a dropdown list that gets its choices from entries located in another part of the spreadsheet.
- Type the entries in one column or row.
You can name the list by selecting the entries and then clicking in the Name box on the Formula bar and entering a name, and then press Enter.
- Next, select the cell where you want the dropdown list.
- On the Menu bar, go to the Data menu, click Validation, and then click the Settings tab.
In the Allow box, click List.
- Enter the name of the list or its location.
Make sure the reference or name is preceded with an equal sign (=).
Make sure the In-cell dropdown check box is selected.
If your list is short, you can type the entries directly in the Source box, separated by commas.
Excel — Data Validation —Tips
See all Topics