And you can get the QAT file location easily with following method. When we customize the Quick Access Toolbar in Outlook, it will generate files for the custom settings and save them in your computer automatically. Press and release the Alt key and you can see the numbers appearing below each icon on the QAT.ĪLT+ is the shortcut for the command.Get the Quick Access Toolbar file location Then click on the remove button.Īlternatively, remove the commands by right clicking on the icon on the QAT and select “Remove from Quick Access Tool Bar” Shortcut to Access icons in Quick Access ToolbarĪccess the QAT by pressing the ALT key on the keyboard. Select the command which you don’t need on the QAT from the right side block. We can remove the commands on QAT from the same window. You can also type a text for a display name to reflect when you hover your mouse on the icon. For Example Save icon is well known and have a meaning. These icons are easy to identify and are related to the task they do. Then click the Modify button which helps you choose an icon from the 55 set icons which are available. However, you can select an icon in the Customize Quick Access Toolbar list box. Click on the Macro you needed and then click on “ Add” button to add it to the QAT.Įvery Macro added to the QAT gets an identical icon. To add/ assign a macro to QAT choose “ Macros” option from the drop down on the right and you can see a list of all available Macros. To do this Right Click on the Quick Access Tool bar and select the option “Show below the Ribbon”. (Above the formula bar in case if you want to use it more frequently). You can change the position of the QAT from the top of the ribbon to below the ribbon. Positioning the Quick Access Toolbarīy default the position of the QAT is on the top of the ribbon. Adding up all the required/ most frequently used commands to the QAT helps to do your work much quicker. By default save, undo and redo commands along with an arrow pointing downward are available on the QAT. This tool bar contains a set of commands that are independent of tab on the ribbon that is being visible currently. Quick Access Tool Bar (QAT) is a customizable tool bar located at the left most corner of the window on the top of the ribbon. In this post, Let us see what QAT is and how to customize it to improve our efficiency. This feature is available from Office 2007 and above. You can do this using the Quick Access ToolBar in Excel. Is it possible to have all our frequently used options at one place for an easy access? The answer is Yes. The solution for this problem is to have all the commands which we use frequently at one place. By default only one seventh of the commands are visible on the ribbon due to which you need to switch between tabs to use multiple options which consumes time.

Cannot customize quick access toolbar