Database Function

Resolved · Urgent Priority · Version 2007

Wed 2 Nov 2011, 14:51 Delegate 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.

Thu 3 Nov 2011, 10:46 Trainer Paul said...

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

Thu 3 Nov 2011, 13:10 Delegate Aisha said...

RE: Database Function

Thanks Paul.

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips

Database Function

Database Function

RE: Database Function

RE: Database Function

Excel articles

Excel tip:

Return to the active cell after scrolling