Trending September 2023 # How To Use Quick Access Toolbar? # Suggested October 2023 # Top 9 Popular

You are reading the article How To Use Quick Access Toolbar? updated in September 2023 on the website Chivangcangda.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested October 2023 How To Use Quick Access Toolbar?

Excel Quick Access Toolbar (Table of Contents)

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Quick Access Toolbar in Excel

Quick Access Toolbar in Excel is a list of all the category and inbuilt tools available in Excel. There are 2 ways to access the Quick Access Toolbar.

In the first way, go to the File menu’s Excel Option, and from there, we can find the Quick Access Toolbar, and another way is accessing this from the title bar’s customized quick access toolbar. If we select More Commands, it will directly take us to the Quick Access Toolbar. Now, if we see, it has all the list of tools available in Excel. And we can see some of the names of the tools on the right side of the list. If we want to get the quick access option of any tool we use more frequently, we add those tools from the available list to the customized list. This will be seen in the title bar.

Customize Quick Access Toolbar in Excel

Step 2: In the below window from the drop-down list, select Commands Not in the Ribbon.

Step 3: This will show up all the features that are not there in the QAT currently.

Like this, I have selected some of the important features of the QAT. Then, I will discuss each of them one by one.

Now we can see all these enabled features in QAT.

AutoFormat

Designing our table is very important. Designing will take some of our productive time. Using AutoFormat QAT, we can do this in just a blink of an eye. I have simple data to format.

From the below window, you can select any one of the auto format tables.

Now my data looks like this.

Camera Tool

How to Insert Chart Quickly?

Now it will ask you to select a suitable chart for you. You can select any one of the available charts.

Based on the selection you make, it will insert the chart for you.

Sort Ascending & Descending

Sort is pretty much a regular job for all the excel users. Using this Quick Access Toolbar, we can sort the data according to your requirement, either Ascending or Descending.

Spell Check

After spending a considerable amount of time building the report, we need to write the executive summary for our report; we need to write some of the key findings. Then, we need to recommend some of the insights and maybe more things to be written. As human beings, we tend to make typing mistakes.

In order to do the spell check, press the spell check icon on the QAT; it will do the spell check in the entire worksheet and recommend the changes. Refer to our article on Spell check for more information.

Insert Pivot Table Quickly Send File as Email Attachment Things to Remember About Quick Access Toolbar in Excel

Based on the requirement of the user, we can customize the QAT.

We can add Excel Add-Ins to QAT.

In order to send an email system should be configured as an outlook email.

Most of the QAT features have shortcut keys.