The “Quick Access” toolbar

The “Quick Access” toolbar is used to store shortcuts to frequently used features in Excel .

The “Quick Access” toolbar can not be removed from the screen.
However, one can change its position:
1. You can place it above the “Ribbon”, which is the default setting, or
2. You can place it under the “Ribbon”.
In order to place it under the “Ribbon” right click a command on the “Ribbon”, or a command in the “Quick Access” toolbar, and choose “Show Quick Access Toolbar below the Ribbon” from the drop-down menu.
To place it above the “Ribbon”, repeat this procedure.

By default, the “Quick Access” toolbar has three buttons: “Save”, “Undo” and “Redo”.
The “Quick Access” toolbar is the only toolbar that we can customize in “Microsoft Excel 2007”.
By clicking on the downward pointing arrow next to the toolbar we can add commands.

The most used commands appear in a drop-down list.

If you want to add a command to the Quick Access toolbar, then click the command in the list. You will see that the command is checked..
If you want to remove a command from the Quick Access Toolbar, uncheck the command in the list.
Or right click the command in the toolbar, and select “Remove from Quick Access Toolbar”.
If you want to add a command which is not on the list, click “More Commands”.

 

 

 

 

Customize the “Quick Access” toolbar

This opens the “Excel Options” dialog with a “Customize” tab.

We find all available commands in Excel in these lists.  The commands are divided into categories. Click the downward pointing arrow to choose the category from the drop-down list “Choose commands from” box.

Select the command in the left pane, and click the “Add” button.To remove a command, select the command in the right panel, and click the “Remove” button.

By clicking on the upward and downward arrows, you can change the location of the command in the Quick Access Toolbar.

In the “Customize Quick Access Toolbar:” choose if you want these settings for all documents, or just for the document in which you are currently working.

If you are finished with your settings, click the OK button.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats