Table of Contents
Quick access toolbar important to have all the commands that you frequently use in one place so that you don’t need to move from tab to tab to find required commands.
- On quick access toolbar, you can add options that you use frequently to access them easily.
- You can even change its position from the title bar to below the ribbon.
- It is activated by default and you can’t hide it.
And in this tutorial, we will be exploring everything about the quick access toolbar. So, let’s get started.
What is Quick Access Toolbar?
Quick Access Toolbar is a thin line that can hold buttons for the commands, and it is located at the left side of the title bar, and is always visible regardless of which ribbon tab is active. You can add and remove buttons from the quick access toolbar and can change its position as well.
Below is the default quick access toolbar that you can see on opening an Excel application for the first time.
Default buttons on quick access toolbar
Even before you customize it and add your buttons for your favorite commands, it has for default buttons:
- Autosave: It is a switch that you can turn on to save a workbook to OneDrive and SharePoint on a real-time basis. That means Excel will save the workbook one small intervals so that you won’t lose data.
- Save: This button saves the active workbook or works as “Save As” if the active workbook is not saved yet.
- Undo: This button undoes the effect of the last action.
- Redo: This button reverses the effect of the last undo.
What if the quick access toolbar not available
The quick access toolbar is always visible in the Excel window. But when you are using Excel in full-screen mode only in that case, it will be hidden, and displaying it (temporarily), you need to click on the title bar or press the alt key.
How to Customize Quick Access Toolbar in Excel?
One of the most significant advantages of the quick access toolbar is you can customize it in so many ways. On the right side of the QAT, you have a small drop-down, and when you click on this drop-down who find options to customize it.
In this drop-down, you have a list of some of the basic commands which you can add.
You simply need to select the option that you want to add, and it will add a new button to the QAT.
Next to that list, you have a button to add more commands (we will discuss it in a few seconds), and in the end, there’s a button to show the quick access toolbar below the ribbon.
Add more commands to the quick access toolbar
Once you click on the mode commands, it will take you to the Excel options where you have the whole bunch of these to customize the quick access toolbar.