![excel 2016 quick access toolbar excel 2016 quick access toolbar](https://excelinexcel.in/ms-excel/wp-content/uploads/sites/2/2020/08/2020-08-24-13_21_44-Window-2.png)
I will recommend that you should go through the article couple of times and practice each step.
#Excel 2016 quick access toolbar how to#
How to add commands in the Quick Access Toolbar? If you do more data crunching in Excel, you can choose commands such as Add or Remove Filter, Create Chart, Pivot Table, and Quick Print. and choose other commands based on your daily tasks and work. As a rule of thumb, you should have few standard commands such as Print, Redo, Undo etc. You can see all the commands available in the above screenshot. You can see all the available commands by clicking Customize Quick Access Toolbar and then More Commands. What are the commands available in the Quick Access Toolbar? In addition to exposing Commands, the Quick Access Toolbar (QAT) also includes a customizable drop-down menu that contains the complete set of default Quick Access Toolbar (QAT) Commands (whether. You can also change its place by clicking on Customize Quick Access Toolbar (the down arrow in the picture next to the re-do button) and choosing the option Show Below the Ribbon. By default, the Quick Access Toolbar (QAT) is located in the title bar of the application window but can be configured to display below the ribbon. The Quick Access Toolbar in Excel is placed just above the ribbon:
![excel 2016 quick access toolbar excel 2016 quick access toolbar](https://cdn.wallstreetmojo.com/wp-content/uploads/2015/05/Data-Tab-Excel-2016-1024x112.png)
So, if you want to print any document, instead of going through File – > Print, you can directly click the print button from quick access toolbar in Excel and get the document printed. For example, by default, Excel provides Print, Undo, and Redo options in the Quick Access Toolbar. It is very convenient for a user to perform the various task quickly without remembering any shortcut key for the command. Step 2: In the below window from the drop-down list, select Commands Not in the Ribbon. To add other features click on More Commands. The Quick Access Toolbar in Excel is a toolbar that contains commonly-used Excel commands. Step 1: On the top right corner, click on the down arrow, here we can see few features on the go like Email, Print Preview & Print, Quick Print, Spelling Check, Sorting, and many more, as shown in the below image.