98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version Standard
Chantel has attended:
Excel Intermediate course
Excel Advanced course
Excel
i would like to know how to create drop down boxes listing information from another sheet.
RE: Excel
name the list which you have created.
Do this by selecting the list and then clicking on the top left hand address cell (where it normally says A1) and change this to the Name of the list "MyList" for example.
Then go to the cell that you want to have the drop down list. Click on Data and then Validation, and click on the Settings tab.
Choose "List" in the Allow box,
in Source, enter the name of your list but preceded with an = sign i.e. =MyList
You should then see that that cell becomes a drop down box.
i got this a few months ago from this web site.
http://office.microsoft.com/en-us/excel/HP052022151033.aspx
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:Use shortcut keys to select rows or columnsMost users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that. |