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 » How do I create drop-down lists in excell spreadsheets?
How do I create drop-down lists in excell spreadsheets?
Resolved · Urgent Priority · Version 2003
Mon 29 Jun 2009, 11:37Delegate Alistair said...
Alistair has attended:
Excel Intermediate course
Project Introduction course
How do I create drop-down lists in excell spreadsheets?
How do I create drop-down lists in excel spreadsheets?
Mon 29 Jun 2009, 13:11Trainer Amanda said...
RE: How do I create drop-down lists in excell spreadsheets?
Hello Alistair
Thank you for your question and welcome to the forum.
To create dropdown lists, use data validation.
1. Select the cells to contain the dropdown list.
2. Go to Data - Validation
3. Select List
4. Enter each list item in the blank area near the bottom of the dialogue box, separated by commas, e.g. Monday,Tuesday,Wednesday etc.
5. Click OK.
I hope this helps.
Kind regards
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:Closing Multiple Workbooks quicklyWhen you have several workbooks open in Excel and want to just close them all at once: |
