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:
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:
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:
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:
The result has been created a quick Paste Special key on the Quick access toolbar:
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!