Karen has attended:
Project Intro Intermediate course
Excel Intermediate course
Finance for Non-Financial Managers course
Drop down lists
How do you create drop down lists in Excel?
RE: Drop down lists
Hi Karen,
Thanks for your question.
In order to create a drop down list:
- 1. Select DATA menu > Validation
2. In SETTINGS tab > choose under ALLOW > LIST
3-1. In SOURCE box, type in your list of items with a comma as separator
3-2. You can also select an exisiting list on the same worksheet
4. Finally, press OK to confirm. You should see a drop down button to show the list
Regards,
Katie Woo
Microsoft Certified Trainer