SEARCH

How-To Geek

Quick Tip: Customize Your Excel 2007 Quick Access Toolbar

The new Ribbon in Office 2007 can take a while to get used to, so the Quick Access Toolbar is a great way to put your most frequently used commands on a single toolbar while you are getting used to the Ribbon.

Open Excel 2007 and click the down arrow next to the Quick Access Toolbar.

4

From the menu choose More Commands…

6

Now highlight the commands you want to appear on the toolbar from the left column, and click the Add button to add them to the selected box on the right-hand side.

You can also check the box for “Show Quick Access Toolbar below the Ribbon” if you don’t like the toolbar appearing in the title bar.

5

Notice the toolbar is now below the ribbon, and the items have been added to the toolbar.

7

This is definitely a simple tip, but I’ve found it’s very useful.

Lowell Heddings, better known online as the How-To Geek, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on if you'd like.

  • Published 08/21/07

Comments (1)

  1. Anne

    I have tried to customised the command button (excel 2007) in the quick access toolbar but some of the command buttons was hidden. How can i create additional row under quick access toolbar?

    FYI, I am currently using window 7 ultimate

    Your valuable advise is highly appreciated.

    Thanks
    anne

Enter Your Email Here to Get Access for Free:

Go check your email!