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
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
