Customise The Quick Access Toolbar

Add or Remove items on the Quick Access Toolbar

The Ribbon is easily accessible for most commands, but you can also add command shortcuts for easier access in the Quick Access Toolbar which is located in the top left corner of the Excel Workbook.

By default Excel 2013 will show the Quick Access Toolbar above the Ribbon.
Customise The Quick Access Toolbar

Alternatively you can display it below the Ribbon.
Customise The Quick Access Toolbar2

To do this right click anywhere on the Quick Access Toolbar and select Show Quick Access Toolbar below the Ribbon.
Customise The Quick Access Toolbar3

Default Commands

The default commands displayed on the Quick Access Toolbar are Save, Undo, and Redo.
You can customise the Quick Access Toolbar by adding other commands that you use often.
There are several ways to add command buttons to the Quick Access Toolbar here are two examples.

Example 1

Right-click any command in the Ribbon and select Add to Quick Access Toolbar.
Customise The Quick Access Toolbar4

Example 2

Click the down arrow at the right of the Quick Access Toolbar.
A drop down menu will be displayed with some additional commands that you might want to place in the Quick Access Toolbar.
To see more commands select More Commands… from the menu.
Customise The Quick Access Toolbar5

Add a new command using the Excel Options dialog box.

Select the command in the left column and click Add>>

Remove a command from the Quick Access Toolbar

Select the command in the right column and click <<Remove
Customise The Quick Access Toolbar6




Be the first to comment

Leave a Reply