As always, Microsoft gives you more than one way to do just about anything - so try them all, and then stick with the ones you find easiest to remember and use. In the Quick Access Toolbar window, you will see two lists: Left one lists the commands you can add Right one shows the commands already added into the Quick Access Toolbar To add Document Location command, follow the steps below: Open the Choose commands from list and select Commands Not in the Ribbon In the box below, scroll down and select the Document Location command Click the Add button to include the Document Location to the right box Once you see the Document Location in the.
Note that choosing Customize the Quick Access Toolbar also opens that Excel Options dialog box, the same one we saw when I chose More Commands.
Here you see it there, and then I'll put it back.
Another thing you can do with the Quick Access Toolbar? Once I've clicked OK to save my changes, I can right-click the Quick Access Toolbar and choose to display it below the ribbon.
I’m going to move Save As up to be right next to Save. Remember that moving a button up moves it to the left on the Quick Access Toolbar, down moves it to the right, as the toolbar is horizontal.
To rearrange the buttons on the Quick Access Toolbar, click the command you want to move, and click the up or down triangle buttons on the right.
If you change your mind about which button you added, you can select it on the right and the click the Remove button between the columns.
Now I’ll add the Add a Chart button, and the Add a Hyperlink buttons, and then by pressing the letter S on the keyboard, I can move quickly to the commands beginning with the letter S, where I’ll choose Save As.
To get a bigger list of commands to choose from, I’m going to change from Popular Commands at the top of the left column to All Commands.
Just select them on the left, and click the Add button in the middle, between the columns, and the button or buttons are added. In the resulting Excel Options dialog box, you see two columns - the one on the right shows the buttons already on the Quick Access Toolbar, the one on the left shows the commands you can add.
Now, let's use More Commands to add more buttons.
Easier still? Removing buttons you no longer want - you can either re-select a checked button on the menu, as I'm doing here after clicking that triangle on the far right end of the Quick Access Toolbar, or right-click the unwanted button and then choose Remove from Quick Access Toolbar from the pop-up menu.
First, I'll add Quick Print, which will print a copy of the active worksheet, no questions asked, to my default printer, anytime I click the button.
To add buttons to it, you can click the triangle at the far-right end and choose from a list of frequently-used commands, or from that menu, choose More Commands.
By default, it contains three buttons - Save, Undo, and Redo.
So let's look at the Quick Access Toolbar.
Excel gives us a lot of tools to work with to make using the application easier - including the Quick Access toolbar, which puts the buttons you use most often right there at the top of the screen.