Forum home » Delegate support and help forum » Microsoft Excel Training and help » Drop down lists
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Drop down lists
Resolved · Low Priority · Version Standard
Reply Thu 14 Feb 2008, 15:42Delegate Karen said...
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?
For upcoming training course dates see: Pricing & availability
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
|