Understand Quick Access Toolbar (QAT) in MS Excel

Utilize Quick Access Toolbar (QAT) Excel 2016

Learn Quick Access Toolbar (QAT) MS Excel 2016

Understand Quick Access Toolbar (QAT) MS Excel

See Previous Post: Set Printing for worksheet document Microsoft Excel 2016

Let us understand about the Quick Access Toolbar. So, the QAT plays a very important role in Microsoft Excel. Also, it’s quite interesting to know about it, but overlooked by most of the users. This toolbar is the top right most blank space located above the Tab Ribbons.

Particularly, by default there are Eight tabs in Excel. They’re the Home tab, the Insert tab, the Page Layout tab etc. Also, the other tabs are the Formulas tab and the Data tab. Further, are the Review tab and the View tab. The Developer tab remains hidden by default.

The Quick-Access-Toolbar helps users to access the buttons of the groups quickly. Also, it helps to save time and speeds up the work in Microsoft Excel. So, to add a button in the Quick Access Toolbar follow theses steps.

  • Right Click with Mouse Button on any of the button from a group.
  • A Menu will show up having five options.
  • Then, select the Add to Quick Access Toolbar.
  • And, the selected button gets add to the QAT.

 (QAT) Quick Access Toolbar Microsoft Excel – continued

Apart, from the Add to Quick Access Toolbar, the other options are the Customize Quick Access Toolbar etc. In addition, are the Show Quick-Access-Toolbar Below the Ribbon, the Customize the Ribbon and the Collapse the Ribbon.

So, after the button is added to the QAT, it becomes easily accessible to the user. The other powerful advantage of adding buttons to the Quick-Access-Toolbar is that; all the required buttons come into a single place.

Also, suppose that we’ve currently opened the Formulas tab. And, we need to apply the Freeze on the worksheet. So, now without clicking the View tab; we can quickly jump & use the Freeze Panes button from the QAT, isn’t it.

Lastly, to reach to the QAT buttons even more faster, click the Show Quick-Access-Toolbar Below the Ribbon options. By doing so, the Quick Access Toolbar will now move from the top; and show up below the ribbon, above the Formula Bar. Therefore, now all the buttons are more near to the worksheet for the speed access.

See Next Post: Advantages Text Box over Cell content Microsoft Excel 2016


About the Author

After working on Microsoft Excel for so many years, now its time to share & spread my Experience and Knowledge, which I have gained on Excel with the world. Myself, Piyush Kr. Pandey is an Excel enthusiast and founder of IndiaExcel.com (Learn Microsoft Excel), a website since 2016. Kindly, Subscribe our blog email newsletters for daily vital and essential informative posts on Microsoft Excel. Email: indiaexcelblog@gmail.com

Post a Reply

Your email address will not be published. Required fields are marked *