Create a quick access key in the Quick Access section in Excel

The quick access toolbar provides quick access to Excel's built-in features like undo, create new files, save files, etc. The following article shows how to create a quick access key in the Quick Access section in Excel.

As its name implies, the Quick access toolbar provides quick access to Excel's built-in features such as undo, create new files, save files, etc. However, by default, the Quick access toolbar only contains certain keys, you want to create many quick access keys displayed on the Quick access toolbar to be more convenient for working. It is not difficult , the following article will guide you how to create a quick access key in Quick Access in Excel.

The location of the Quick access toolbar is on the top left of the interface:

Create a quick access key in the Quick Access section in Excel Picture 1Create a quick access key in the Quick Access section in Excel Picture 1

To create a quick access key on the Quick access toolbar, click the dropdown arrow in the bar -> select the features you need to create, for example, create a new key to create a new file -> select New:

Create a quick access key in the Quick Access section in Excel Picture 2Create a quick access key in the Quick Access section in Excel Picture 2

In addition to the features available on the toolbar, in case you want to create another key, it is not displayed on the toolbar, click More Commands:

Create a quick access key in the Quick Access section in Excel Picture 3Create a quick access key in the Quick Access section in Excel Picture 3

A dialog box appears and click the Quick access toolbar in the Chosse Command from section to select the features to create more on the Quick access toolbar ( for example, select the Paste Special -> feature after selecting, click Add -> feature need to add to the Customize Quick Access Toolbar -> finally click OK to complete:

Create a quick access key in the Quick Access section in Excel Picture 4Create a quick access key in the Quick Access section in Excel Picture 4

The result has been created a quick Paste Special key on the Quick access toolbar:

Create a quick access key in the Quick Access section in Excel Picture 5Create a quick access key in the Quick Access section in Excel Picture 5

The above is a detailed guide on how to create a quick access key in the Quick access toolbar hoping to help you.

Good luck!

5 ★ | 1 Vote