Where can I find the menu commands in Excel 2007
Ron de Bruin (last update 29-Dec-2008)
Go back to the Excel tips page

The pictures below will help you to find the commands in Excel 2007.
You can download a Zip file here with a Excel workbook to print the pictures (6 pages).

If you see "Not in the Ribbon(add to QAT)" you can do this to add the command
to the QAT (Quick Access Toolbar).

This is the Office Button :



1) Office Button > Excel Options
2) Customize
3) Choose "Commands Not in the Ribbon" in the "Choose Commands from" list
4) Select the command
5) Add
6) OK

Or faster,right click on the QAT and choose "Customize Quick Access Toolbar"



Menus from the Worksheet Menu Bar



You can also find the Standard and Formatting toolbar below the
Worksheet Menu Bar screenshots.























Note: To display the Developer tab go to Office Button >Excel Options...Popular










Where is the list with open files ?

Go to View>Window and right click on the option below to add it to the QAT so it is always accessible.



Another way is to use the shortcuts Ctrl-F6 and Ctrl-Shift-F6 to switch workbooks or Ctrl-Tab






Standard and Formatting toolbar











Microsoft information

You can find a lot of Microsoft information here
http://office.microsoft.com/en-us/help/HA101491511033.aspx