98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Lists
Lists
Resolved · Low Priority · Version 2003
Rob has attended:
Excel Intermediate course
Outlook Advanced course
Lists
How do you create a drop down list?
RE: lists
Hello Rob
Thank you for your question and welcome to the forum.
You can create dropdown lists in Excel using a feature called data validation (Data menu - Validation option).
Firstly, select the cell/s you wish to have the dropdown list available in.
Then on the Settings tab, select List and then in the Source box, type each item separated by a comma and a space, e.g.
Sales, Marketing, Accounts
You can create further settings for the validation using the Input Error and Error Alert tabs if you wish, and then click OK.
Your dropdown list should appear on the cells you selected before setting up the validation.
Data validation and other useful topics are covered as part of our Excel Advanced course. Further information about the course including syllabus and dates can be found on the following page:
https://www.stl-training.co.uk/excel-training-in-london-2003-advanced.php
Amanda
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:Percentage formatCtrl+Shift+% applies the Percentage format, with no decimal places. |