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. Add more commands to the quick access toolbar 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. You simply need to select the option that you want to add, and it will add a new button to the QAT. In this drop-down, you have a list of some of the basic commands which you can add. On the right side of the QAT, you have a small drop-down, and when you click on this drop-down find options to customize it. One of the most significant advantages of the quick access toolbar is you can customize it in so many ways. 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. The quick access toolbar is always visible in the Excel window. What if the quick access toolbar is not available
Redo: This button reverses the effect of the last undo.
Undo: This button undoes the effect of the last action.
Save: This button saves the active workbook or works as “Save As” if the active workbook is not saved yet.
That means Excel will save the workbook one small intervals so that you won’t lose data.
Autosave: It is a switch that you can turn on to save a workbook to OneDrive and SharePoint on a real-time basis.
Default buttons on the quick access toolbarĮven before you customize it and add your buttons for your favorite commands, it has default buttons: This tutorial is a part of our Basic Excel Skills, and if you want to sharpen your existing Excel Skills, checkout these Excel Tips and Tricks. It is a fixed toolbar that can’t be free-floating, and commands on the Quick Access toolbar always appear as small icons without any text (except autosave switch). You can add and remove buttons from the quick access toolbar and can change its position as well.īelow is the default quick access toolbar that you can see on opening an Excel application for the first time. The Quick Access Toolbar is a thin bar 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.
It is activated by default and you can’t hide it.Īnd in this tutorial, we will be exploring everything about the quick access toolbar.
You can change its position from the title bar to below the ribbon.
On the quick access toolbar, you can add options that you use frequently to access them easily.
The idea of using quick access toolbar is 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 those commands.