Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - Drop down lists in Excel
|
|
|
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. |
excel consultants - Drop down lists in Excel
Resolved · Low Priority · Version Standard
Reply Tue 24 Jul 2007, 15:29Delegate Wendy said...
Wendy has attended:
Excel Intermediate course
Excel Introduction course
Outlook Advanced course
Excel Intermediate course
Powerpoint Introduction course
Drop down lists in Excel
How do I create a drop down list in Excel? eg mr, Mrs etc. Thanks
For upcoming training course dates see: Pricing & availability
RE: Drop down lists in Excel
Hi Wendy,
You will find the option to do this under the Data menu and down to Validation, you want to create a list and then type your options in using a comma to separate them.
Hope that helps
Tracy
Reply Wed 25 Jul 2007, 10:57Delegate Wendy said...
RE: Drop down lists in Excel
Thanks Tracy
Thats great and I have manged it successfully with short lists which I can type in. I now have a long list of names in another spreadsheet which I wish to use as my drop dowm list, can I attach this somehow or do I need to type in each name. Wendy
RE: Drop down lists in Excel
In the same place you should have a option to get back into your spreadsheet and highlight the cells you wish to use as a list. It is a red button next the the space where you typed your list in. Click on that and navigate to the spreadsheet which contains your data. Let me know if that works
Tracy
Reply Thu 26 Jul 2007, 11:23Delegate Wendy said...
RE: Drop down lists in Excel
It really does work! Thanks very much.
|