Forum home » Delegate support and help forum » Microsoft Excel Training and help » 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
Resolved · Low Priority · Version Standard
Reply Tue 11 Mar 2008, 16:26Delegate Chantel said...
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.
For upcoming training course dates see: Pricing & availability
Reply Thu 13 Mar 2008, 13:00
Edited on Wed 9 Apr 2008, 16:25Delegate Samantha said...
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
|