98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Drop down lists
Drop down lists
Resolved · Low Priority · Version Standard
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?
Thu 14 Feb 2008, 16:12Trainer Katie said...
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
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. |
Excel tip:Calculate difference between two timesFor presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format. |
