The Quick Access Toolbar

The Quick Access Toolbar is located to the right of the Microsoft Office Symbol and Above the Home Tab.
Right out of the box, initial install, there are three buttons by default; Save, Undo, and Redo. If you want to you can add buttons or remove buttons from the Quick Access Tool Bar. There are a few of ways that we can do this.

The Quick Access Toolbar Button

To the right of the Quick Access Toolbar there is a symbol that looks like a line above a triangle that is pointing down, this is actually a button.

When you press the button a dialog box appears. With this dialog box you can add or remove buttons from a standard list. As you can see there are some that have a checkmark to the left of them. These are the buttons that will show in the Quick Access Toolbar.

To add more buttons just click on the word, for instance New, This will add the New Spreadsheet Button to the Quick Access Toolbar; the Dialog Box will close after you click. If you want to add more of the predefined buttons then you can repeat the same steps as often as you want.

To remove the button from the list, simply click on the name of the button that you wish to remove from the Quick Access Toolbar and the checkmark will be removed, the Dialog Box will close, and it will remove the button from the Quick Access Toolbar.

There are three other buttons on the Customize Quick Access Toolbar; they are More Commands, Show Below the Ribbon, and Minimize the Ribbon.

More Commands

The More Commands Button will open another Dialog Box; this dialog box has many options for customizing Microsoft Excel. I will talk about most of them later on in the book. For now I will discuss the Customize the Quick Access Toolbar, in the Customize Section.

This Dialog Box is split into many parts; On the right side we have a list of sections that we can access, there is the Choose commands from drop down, below that we have the command buttons for that particular command group. Below that we have the Show Quick Access Button Below the Ribbon check box. Next we have the Add and Remove Buttons. Then the Customize Quick Access Toolbar drop down, here we can choose if we want to apply the changes in the Quick Access Toolbar to all Documents or just this particular Spreadsheet. Below that we have a list of the buttons that will appear in the Quick Access Toolbar. Then we have the Reset Button which will reset the Quick Access Toolbar to the default settings. The Modify Button applies to special buttons that you can create for Macros, we will talk about these later. To the right of the button list there are two buttons that we can use to change the order of the buttons on the Quick Access Toolbar, the closer the button is to the top of the list the closer to the Office Symbol it will be. We then have the OK and Cancel buttons. If we made changes to the list we need to click the OK button for those changes to take effect, if we use the Cancel button it will not keep the changes that we have just made.

Add a Quick Access Button from a Group

There is another way to add a button to the Quick Access Toolbar using the right mouse button. If you want to add the Insert Picture Button, go to the Insert Tab, right mouse click on the Picture Icon and click the Add to Quick Access Toolbar.