

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.
