Instructions for customizing the Quick Access bar on Excel

The Quick Access bar on Excel helps users quickly perform some commonly used operations without having to access them manually. To suit each user and their Excel usage habits, we can completely customize the Quick Access bar on Excel for ease of work. Below are instructions for customizing the Quick Access bar in Excel.

Move the location of the Quick Access bar on Excel

We can adjust the Quick Access bar below the Ribbon or above the Ribbon if desired. Right -click on the Ribbon and select Show Quick Access Toolbar Below the Ribbon to move down .

Instructions for customizing the Quick Access bar on Excel Picture 1

As a result, you will see the quick access bar displayed under Quick Access as shown below.

Instructions for customizing the Quick Access bar on Excel Picture 2

To move up , right-click and select Show Quick Access Toolbar Above the Ribbon.

Add commands to the Excel Quick Access bar

Commands are available from the Ribbon

In the Ribbon , right-click on the command you want to add to the quick access bar and select Add to Quick Access Toolbar to add.

As a result, we will see the command added to the quick access bar on Excel as shown.

Add new commands to Quick Access

Step 1:

At the Quick Access interface, click on the drop-down triangle icon and select More Commands….

Step 2:

Displays a new interface for you to select the command you want to add to Quick Access. You click on the command and then select the Add button to add it.

As a result, we will see the command displayed on the Quick Access bar as shown.

Delete commands in the Quick Access bar

To remove a command from the Quick Access bar, right-click the command and select Remove from Quick Access Toolbar .

Change command order in the Quick Access Excel bar

Step 1:

Click on the triangle icon and then select More Commands. to access the interface to customize the quick access bar on Excel.

Step 2:

Displays a custom interface for commands in the Quick Access bar. We click on the command and then select the up and down triangle icon to change the position of the commands in the Quick Access bar.

Reset the Excel Quick Access bar to default

After a long time of using the quick access bar with different commands, if you get confused, you can reset this Quick Access bar.

We click on the triangle icon and then select More Commands in Customize Quick Access Toolbar. In the new interface, users click Customization and then select:

Reset only Quick Access Toolbar: Return Quick Access to default.
Reset all Customizaton: Return everything to default, including the Ribbon and Quick Access Toolbar.

Click on the reset option you want and then click Yes to execute.

Lesley Montoya

Update 10 July 2024

You should read it

May be interested

Active Office 2024 is forever free using CMD
office 2024 is the latest product in microsoft's office software line, for both windows and mac users. in this article, taimienphi will guide you to active office 2024, using this application suite permanently.
Instructions for turning on Dark Mode on Office 2019
dark mode is a feature that allows users to convert office 2019 to a dark background interface mode. this helps reduce eye strain and improve the working experience in low light environments. dark mode is integrated to optimize comfort when working at night or in low light conditions. here's how to turn on dark mode on office 2019.
How to install only Word and Excel in the Office 2016 suite
installing only word and excel from the office 2016 suite helps you save space and system resources. with detailed instructions, you will easily customize settings to choose the right applications, ensuring your computer runs smoother and more efficiently.
Learn how to fix Excel errors showing formulas not displaying results
with excel displaying formulas that do not display results, you can fix it with a number of ways listed in tipsmake's article.
How to convert PDF files to PowerPoint
pdf is one of the most used file formats in the world. however, it's not easy to use pdf in powerpoint presentations. this article will show you how to convert pdf files to ppt and provide some formatting tips.
How to check if Microsoft Office version is 32-bit or 64-bit
not only you, but many other users who are using the microsoft office program also don't know whether the office version they are using is 32-bit or 64-bit. if you want to know or need to know whether the office version you are using is 32-bit or 64-bit, please refer to the steps in the article below from network administrator.