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