How to Use the Quick Access Toolbar in Excel?

The Quick Access Toolbar is used to quickly complete the repetitive tasks. If you are a regular user of MS-Excel, then you might be using some of its features much more frequently, such as Free pans, Data validation, Bold text, Fit to row height, fit to column height, etc. To use this kind of tabs, you have to jump to different tabs like Home, Insert, Formula, View, Data etc. To simplify this process, you can use the Quick Access Toolbar in Excel. It comes in very handy and saves a lot of time.

How to Navigate to the Quick Access Toolbar? 

Open an Excel sheet and check the top left corner of the sheet; here you will find the Quick Access Toolkit. We have highlighted it in the following screenshot. (example below).

How to Add New Buttons to the Quick Access Toolbar? 

Open the File menu and click Options, as shown in the following screenshot - 

Click the Quick Access Toolbar option.

All major popular commands will be shown here, we are going to add Copy to Quick access toolbar like as below. 

Follow the steps and the Copy button will be added as shown below -

You also can remove the tools by following the same steps and selecting the tool and pressing the Remove button.

Play around with different shortcuts and check and take advantage of it. Happy Learning!