Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » How do I create drop-down lists in excell spreadsheets?
|
|
|
Bookmark this page|
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. |
How do I create drop-down lists in excell spreadsheets?
Resolved · Urgent Priority · Version 2003
Reply
How do I create drop-down lists in excell spreadsheets?
How do I create drop-down lists in excel spreadsheets?For upcoming training course dates see: Pricing & availability
RE: How do I create drop-down lists in excell spreadsheets?
Hello AlistairThank 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
RE: How do I create drop-down lists in excell spreadsheets?
Thank you for a quick response.A
|
 |
|
» Forum post: Handling master pages |
I'm having problems using multiple master pages - setting up headings which are editable on the title slide. Is there a way to fix this.
