Forum home » Delegate support and help forum » Microsoft Excel Training and help » Database Function
|
|
|
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. |
Database Function
Resolved · Urgent Priority · Version 2007
Reply Wed 2 Nov 2011, 14:51Delegate Aisha said...
Aisha has attended:
Excel Advanced course
Database Function
How do I add a drop down menu or titles into a heading so that any user using the spreadsheet can just click on the drop down arrow and select only one of the tiles.
For upcoming training course dates see: Pricing & availability
RE: Database Function
This is based on 2007 and 2010, let me know if you are using 2003.
Go to your DATA tab on the Ribbon, select DATA VALIDATION. In the box that appears select LIST and then use the SOURCE area to select your list. If you are using 2007 the list will have to be on the same page. If its not on the same page try naming your list using the NAME BOX and the in the SOURCE area enter "=thenameyougaveyourlist"
There are a couple of ways of doing this. Put this link in your browser for another option.
http://office.microsoft.com/en-au/excel-help/add-a-list-box-or-combo-box-to-a-worksheet-HP010236681.aspx
Thanks
Paul
Reply Thu 3 Nov 2011, 13:10Delegate Aisha said...
RE: Database Function
Thanks Paul.
|