Quick Access Toolbar in Excel

Search
Generic filters

Table of Contents

Quick access toolbar important to have all the commands that you frequently use in one place so that you don’t need to move from tab to tab to find required commands.

  • On quick access toolbar, you can add options that you use frequently to access them easily.
  • You can even  change its position from the title bar to below the ribbon.
  • It is activated by default and you can’t hide it.

And in this tutorial, we will be exploring everything about the quick access toolbar. So, let’s get started.

What is Quick Access Toolbar?

Quick Access Toolbar is a thin line that can hold buttons for the commands, and it is located at the left side of the title bar, and is always visible regardless of which ribbon tab is active. You can add and remove buttons from the quick access toolbar and can change its position as well.

Below is the default quick access toolbar that you can see on opening an Excel application for the first time.

A picture containing screenshot, street, drawing Description automatically generated
 
It is a fixed toolbar that can’t be free-floating, and commands on the Quick Access toolbar always appear as small icons without any text (except autosave switch).
 

Default buttons on quick access toolbar

Even before you customize it and add your buttons for your favorite commands, it has for default buttons:

A screenshot of a cell phone Description automatically generated
  • Autosave: It is a switch that you can turn on to save a workbook to OneDrive and SharePoint on a real-time basis. That means Excel will save the workbook one small intervals so that you won’t lose data.
  • Save: This button saves the active workbook or works as “Save As” if the active workbook is not saved yet.
  • Undo: This button undoes the effect of the last action.
  • Redo: This button reverses the effect of the last undo.

What if the quick access toolbar not available

The quick access toolbar is always visible in the Excel window. But when you are using Excel in full-screen mode only in that case, it will be hidden, and displaying it (temporarily), you need to click on the title bar or press the alt key.

A close up of a sign Description automatically generated

 

How to Customize Quick Access Toolbar in Excel?

One of the most significant advantages of the quick access toolbar is you can customize it in so many ways. On the right side of the QAT, you have a small drop-down, and when you click on this drop-down who find options to customize it.

A screenshot of a cell phone Description automatically generated

In this drop-down, you have a list of some of the basic commands which you can add.

You simply need to select the option that you want to add, and it will add a new button to the QAT.

A screenshot of a cell phone Description automatically generated

Next to that list, you have a button to add more commands (we will discuss it in a few seconds), and in the end, there’s a button to show the quick access toolbar below the ribbon.

A picture containing clock Description automatically generated

Add more commands to the quick access toolbar

Once you click on the mode commands, it will take you to the Excel options where you have the whole bunch of these to customize the quick access toolbar.

A screenshot of a cell phone Description automatically generated
  1. On the left side, you have options to select.
  2. And on the right side, you have the list of the commands that you have on the already quick access toolbar.

Steps to customize quick access toolbar

  1. Open the dropdown “Choose Commands from” and select the tab from where you want to add the command.
    8-steps-to-customize-quick-access-toolbar
  2. After that, select the command that you want to add and click on the “Add” button. The moment you click on the add button, you’ll get that command in the quick access toolbar commands list.
    9-click-on-the-add-button
  3. In the end, click OK, and you will have the new command that you have just added the quick access toolbar.
    10-click-ok

I’m sure you have seen that there are a lot of options in the “Choose commands from” drop-down that you can add to the quick access toolbar.

A screenshot of a cell phone Description automatically generated

All the commands that you have in Excel but for the categorize under different groups.

  • Popular Commands: Here, you can find all the popular commands that Excel has, and most of these frequently used commands.
  • Commands that are not in the ribbon: It is a list of commands that are not listed in the ribbon, but you can add them on the quick access toolbar.
  • All Commands: It is a complete list of commands that Excel offers you to use.

To make it easy for you to find a command that you want to the add the quick access toolbar, you also have tab-wise commands that you can select.

The other way to add the command to the quick access toolbar is to go to that commands button and the ribbon and right-click on it and select “Add to quick access toolbar”.

A screenshot of a cell phone Description automatically generated

And this will add a button on the quick access toolbar for the command you have selected.

Remove buttons from the quick access toolbar

If you want to remove an option from the quick access toolbar, just right-click on that button and select “Remove from Quick Access Toolbar“.

A screenshot of a cell phone Description automatically generated

The second way is to open the more commands dialog box and select the command and click on the remove button.

A screenshot of a cell phone Description automatically generated

And you can also untick commands from the dropdown menu that are listed there.

A screenshot of a cell phone Description automatically generated

Rearranging the icons

From the Excel options, you can rearrange the icons that you have on the quick access toolbar.

When you select a button, it activates the up and down arrow at the right side of the list, and you can use these arrow buttons to rearrange the selected command’s button.

A screenshot of a cell phone Description automatically generated

We Create Your Life Easy With Our Free Excel Templates & Spreadsheet Dashboards

Use free Excel Templates, Tools and Dashboards to create and draft a professional looking dashboards and computation sheet for your personal and business use. You can Explore Calendars, Activity Planners, Invoice Templates, Sales Forecast Sheets, Budget templates and various business information delivering Templates in Excel and Spreadsheet at XLSX Templates. 

These templates, dashboards and tools are useful in various occasions. You can also customize these templates as per your requirement. Modification of fields and data source helps in making the template more relevant.

Learn Microsoft Excel : Blogs and Articles

Learn about various tips and tricks in Microsoft Excel and Spreadsheet. Create best templates and dashboards using free tricks and tutorials in excel and spreadsheet. These tutorial posts are useful for everyone who wants to master the skills in excel and spreadsheet.

How to CONCATENATE a RANGE of Cells [Combine] in Excel

How to CONCATENATE a RANGE of Cells [Combine] in Excel

Table of Contents How [CONCATENATE + TRANSPOSE] to Combine Values The best way of  combining text from different cells into …

Deselect Cells in Excel

How To Deselect Cells in Excel

Table of Contents How to Deselect Cells in Excel After adding the deselecting cells feature in Excel, this  becomes so  …

Select Non-Contiguous Cells in Excel

Learn how to Select Non-Contiguous Cells in Excel

Table of Contents Select cell without using Ctrl Key By following these simple steps we can do it. At first, …

Format Painter in Excel

How to use Format Painter in Excel

Table of Contents Where’s the Format Painter Button? It’s there on your Home Tab. If you look at the clipboard …

Apply Strikethrough in Excel [Shortcut + Command]

How to apply Strikethrough in Excel [Shortcut + Command]

Table of Contents Shortcut Key to Apply Strikethrough to a Cell Let’s say you’re in hurry and don’t want to …

Formula Bar in Excel

Formula Bar in Excel

Table of Contents Key Points To Consider Using Formula Bar You can hide or unhide the formula bar. You can …

Basic VBA Macro Codes in Excel

Custom Header & Footer

Sub CustomHeader() Dim myText As String myText = InputBox(“Enter your text here”, “Enter Text”) With ActiveSheet.PageSetup .LeftHeader = “” .CenterHeader …

Get Macro Code

Add Header and Footer Date

Sub DateInHeader() With ActiveSheet.PageSetup .LeftHeader = “” .CenterHeader = “&D” .RightHeader = “” .LeftFooter = “” .CenterFooter = “” .RightFooter …

Get Macro Code

Open Calculator

Sub OpenCalculator() Application.ActivateMicrosoftApp Index:=0 End Sub In Windows, there is a specific calculator and by using this macro code you …

Get Macro Code

Unmerge Cells

Sub UnmergeCells() Selection.UnMerge End Sub Unmerge Cells code simply uses the unmerge options which you have on the HOME‌ tab. …

Get Macro Code

Remove Text Wrap

Sub RemoveTextWrap() Range(“A1”).WrapText = False End Sub This code will help you to remove text wrap from the entire worksheet …

Get Macro Code

Auto Fit Rows

Sub AutoFitRows() Cells.Select Cells.EntireRow.AutoFit End Sub You can use this code to auto-fit all the rows in a worksheet. When …

Get Macro Code

Auto Fit Columns

Sub AutoFitColumns() Cells.Select Cells.EntireColumn.AutoFit End Sub Use above Excel macro code to auto fit rows in all your sheet at …

Get Macro Code

Insert Multiple Columns

Sub InsertMultipleColumns() Dim i As Integer Dim j As Integer ActiveCell.EntireColumn.Select On Error GoTo Last i = InputBox(“Enter number of …

Get Macro Code

Insert Multiple Rows

Sub InsertMultipleRows() Dim i As Integer Dim j As Integer ActiveCell.EntireRow.Select On Error GoTo Last i = InputBox(“Enter number of …

Get Macro Code