EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Excel Quick Access Toolbar
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Excel Quick Access Toolbar

By Jeevan A YJeevan A Y

Quick Access Toolbar in Excel

Excel Quick Access Toolbar (Table of Contents)

  • Quick Access Toolbar in Excel
  • Customize Quick Access Toolbar in Excel
  • How to Insert Chart Quickly?

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

We can add our own feature to Quick Access Toolbar in Excel. Adding those features easily than the other complicated things in excel. To add features, follow the below steps.

You can download this Quick Access Toolbar Excel Template here – Quick Access Toolbar Excel Template

Step 1: On the top right corner, click on the down arrow, here we can see few features on the go like Email, Print Preview & Print, Quick Print, Spelling Check, Sorting, and many more, as shown in the below image.

Start Your Free Excel Course

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

To add other features click on More Commands…

Step 1

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

Step 2

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

Step 3

Step 4: In order to add the feature to the QAT, select the feature that you want to use and click on Add.

Step 4

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

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,639 ratings)

Step 5

Now we can see all these enabled features in QAT.

Step 6

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.

Quick Access Toolbar in Excel step 1

Place a cursor inside the table and click on AutoFormat from QAT.

Quick Access Toolbar in Excel step 2

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

Quick Access Toolbar in Excel step 3

Now my data looks like this.

Quick Access Toolbar in Excel step 4

Camera Tool

The camera tool works exactly the same way how it works on our mobile phones. We can capture live images of the excel data. In order to capture a live picture, select the data you want to capture and click on Camera.

Quick Access Toolbar in Excel step 5

As soon as you click on the camera, it will copy the range, but you need not paste; rather, you need to draw the picture where you want to show it. Then, it will paste the picture as a linked picture; if any changes happen, it will update the picture automatically.

Quick Access Toolbar in Excel step 6

How to Insert Chart Quickly?

Inserting a simple chart will take some of our time. By using QAT, we can insert the chart instantly. Select the data and click on the Chart icon in the QAT.

Quick Access Toolbar in Excel step 7

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

Quick Access Toolbar in Excel step 8

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

Quick Access Toolbar in Excel step 9

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

We all use a pivot table for our analysis purpose. Inserting the pivot table is super quick now; we just need to select the data and click on the Insert Pivot Table icon on the Quick Access Toolbar.

Send File as Email Attachment

In order to send the current workbook as an email attachment, you need to configure your system to Outlook. Once the outlook is configured, click on the Email icon on the QAT.

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.

Recommended Articles

This has been a guide to Quick Access Toolbar in Excel. Here we discuss how to use the Quick Access Toolbar in Excel along with practical steps and a downloadable excel template. You can also go through our other suggested articles –

  1. Examples of Scrollbar in Excel
  2. Excel Quick Analysis
  3. Excel Tool for Data Analysis
  4. Excel vs Access
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

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

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

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

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Quick Access Toolbar Excel Template

EDUCBA

Download Quick Access Toolbar Excel Template

EDUCBA

डाउनलोड Quick Access Toolbar Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more