How to Make a Header Drop Down List in Excel
- Adrienne Todd |
- 10 steps |
- 58 seconds
1
Click on the cell you'd like to add a dropdown list to.
2
Click on the "Data" tab.
3
in the "Data Tools" section of the ribbon, click the arrow next to the data validation icon.
4
Click "Data Validation..." in the dropdown.
5
Click on the dropdown for "Allow."
6
Click on "List."
7
Click on the "Source" dropdown.
8
Type the text you'd like in your dropdown list.
9
Click "OK."
10
To view your new dropdown, click on the arrow in the cell you've added the dropdown to.
