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 » excel consultants - Drop down lists in Excel
excel consultants - Drop down lists in Excel
Resolved · Low Priority · Version Standard
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
Wed 25 Jul 2007, 05:48
Edited on Thu 26 Jul 2007, 08:47Trainer Tracy said...
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
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
Thu 26 Jul 2007, 08:50Trainer Tracy said...
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
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:Working with 3D formulasYou can only use fill-down if you remove $ for Absolute References. |
