excel consultants - drop down lists excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

resolvedResolved · Low Priority · Version Standard

Drop down lists in Excel

How do I create a drop down list in Excel? eg mr, Mrs etc. Thanks

Edited on Thu 26 Jul 2007, 08:47

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

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

RE: Drop down lists in Excel

It really does work! Thanks very much.

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Server loaded in 0.1 secs.