Home Office How to Customize the Quick Access Toolbar in Microsoft Excel 2019

How to Customize the Quick Access Toolbar in Microsoft Excel 2019

Microsoft Excel, as well as other tools on the Microsoft Office bundle, has a feature called Quick Access Toolbar. This feature is intended to help you effortlessly access commands on Microsoft Excel, in a single click. Each command in the Quick Access Toolbar is represented with an icon.

The default location of the Quick Access Toolbar is above the ribbon. In Microsoft Excel 2019, the Quick Access Toolbar contains 4 commands by default. They are Save, Undo, Redo, and Email. If Microsoft Excel is your main work tool — in which you always use it on your daily basis — then the Quick Access Toolbar is pretty handy since it can save you a lot of time. This feature has a similar role as the keyboard shortcuts, but you don’t need to recall any key combination.

You can customize the Quick Access Toolbar to fit your needs. You can add more commands, remove the unnecessary commands, arrange the order, and change the default location of the Quick Access Toolbar.

How to add more commands to the Quick Access Toolbar

In addition to the default commands you see on the Quick Access Toolbar, there are several other commands you can add to it. As mentioned, Microsoft Excel 2019 adds only 4 commands on the Quick Access Toolbar. To add more commands, you can click the tiny arrow button on the right-most of the bar. You will see a selection of 12 common commands, including the default commands already added. Simply check (by clicking it) a command you want to add to the bar.

Actually, Excel has more commands you can add to the Quick Access Toolbar, other than the 12 items you can see on the list when you click the tiny arrow button. To see them all, you can click the tiny arrow button and select More Commands. To add a new command, you can simply select a command you want to add click the Add button. Click the OK button to bring it to the Quick Access Toolbar.

In Excel, commands are put together into groups. You can use the dropdown menu to see the commands on a certain group. By default, you are presented the commands grouped in the “Popular Commands”.

How to remove commands from the Quick Access Toolbar

Adding too many commands to the Quick Access Toolbar is not a wise decision since it can make your Excel interface looks weird and a bit messy. You can remove the unnecessary commands to make your Excel interface look neat. To do so, you can simply click the tiny arrow button and uncheck the commands you want to remove. Or, if you want to remove a command that is not available on the list, you can right-click the icon of the command and select Remove from Quick Access Toolbar.

How to arrange the order of the commands

Each command on the Quick Access Toolbar has an order number (from left to right). This number is invisible but it doesn’t mean it has no meaning. The order numbers are used to access the keyboard shortcuts of the commands. Yes, you can access each command on the Quick Access Toolbar with a keyboard shortcut by pressing the Alt+Order Number (you can press the Alt key on the keyboard to see the order numbers).

To arrange the order of the commands on the Quick Access Toolbar, click the tiny arrow button on the right-most of the bar and select More Commands. Select a command you want to change its order and use the up/down arrow button to change the order. Click the OK button to apply the new orders.

How to change the default location of the Quick Access Toolbar

By default, Microsoft Excel puts the Quick Access Toolbar above the ribbon. If you don’t like this default placement, Microsoft Excel gives you a chance to change it. You can move it below the ribbon. To do so, click the tiny arrow button once again and select Show Below the Ribbon.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

MOST-READ THIS WEEK