EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

Excel Toolbar

By Madhuri ThakurMadhuri Thakur

Home » Excel » Blog » Excel Tools » Excel Toolbar

Toolbar in Excel example

Excel Toolbar (Table of Contents)

  • Toolbar in Excel
  • How to Use the Toolbar in Excel?

Introduction to Toolbar in Excel

The Toolbar is an area where you can add different commands or tools associated with excel. By default, it is located above the ribbon with different tools and visible in the Excel window’s upper right corner. To increase customer friendliness, toolbars have become customizable according to the frequent use of different tools. Instead of a set of tools, excel gives us the option to select and build a Quick Access Toolbar. This makes quick access to the tools that you want. So the toolbar is popularly known as Quick Access Toolbar.

Start Your Free Excel Course

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

Toolbar in Excel(Quick Access Toolbar)

It is a symbolical representation of built-in options available in Excel. By default, it contains the below commands.

  1. Save: To save the created workbook.
  2. Undo: To return or step back one level of an immediate action performed.
  3. Redo: Repeat the last action.

How to Use the Toolbar in Excel?

The Toolbar in Excel is a shortcut tool to avoid searching for the commands you often use in the worksheet. Using Toolbar in Excel is easy, and it helps us simplify access to the document’s commands. Let’s understand the working of the Toolbar in Excel by some examples given below.

Example #1

Adding Commands to the Toolbar in Excel

To get more tools, you have the option to customize the Quick Access Toolbar simply by adding the commands.

  • Click on the downward-facing arrow at the end of the Toolbar in Excel. A pop up will be shown as Customize Quick Access Toolbar.

Customize Quick Access Toolbar

  • From the dropdown, you will get a list of commonly used commands. Click any of the options that you want, and it will be added to the toolbar.

Toolbar in Excel(will be added to the toolbar)

  • A new command is selected, and this will be added to the toolbar highlighted as the command is added with already available tools.

Toolbar in Excel (New command will add)

In a similar way, you can add the tools which you want to access quickly. So instead of clicking and finding the tools from the multiple hierarchies, you can access the option within a single click.

Example #2

Adding Commands to the Toolbar in Excel

There are options to add more tools Instead of the listed commands. You can add more commands to the quick Access Toolbar by selecting More Commands.

Popular Course in this category
Sale
Excel Advanced Training (16 Courses, 23+ Projects)16 Online Courses | 23 Hands-on Projects | 140+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.8 (10,984 ratings)
Course Price

View Course

Related Courses
Excel Training (21 Courses, 9+ Projects)
  • Click on the downward-facing arrow at the end of the toolbar. Select the More Commands option.

Toolbar in Excel (More Commands)

  • You will get a new window which gives you all the options available with excel to add to your toolbar.

Toolbar in Excel (File tab)

From the Choose commands from the drop-down, you can select which list of tools you want to add. Each list will lead to a different list of commands that you can add to the toolbar.

  • Click on the Popular Commands, which shows the set of most commonly used commands. Select the Fill color which you want to add to the toolbar. You can see an add button right next to the list of commands; by pressing it and clicking on the OK button, you can add the selected tool to the Excel Toolbar.

Fill color

  • Once you add the command, it will appear in the list next to the add button. This is the list of tools added to the Toolbar. The “Fill Color” command will be added to the Customize Quick Access Toolbar.

Fill Color" command

  • You can see the “Fill Color” command added to the Quick Access Toolbar as below and the existing commands. Since this is the last item added to the Quick Access Toolbar, it will appear in the listed order.

last item added

  • To reorder the added items, you can use the up and down arrow highlighted on the right to the list of items.

down arrow

  • Select the command which you want to reorder or change the position. By clicking the Upward arrow, the “Fill Color” command is moved upwards in the list shown as below.

Upward arrow

  • By pressing the OK button, the selected format will be applied to the Quick Access Toolbar. The “Fill Color” Command is visible before the “New File” Tool.

Toolbar in Excel example 2-8

You can see the visibility order of the listed tools is changed. According to the new list order, the “Fill Color” position has been changed to the second last from the end.

Example #3

Removing Command

The commands can be removed from the quick access toolbar if you are no longer using them or not using them frequently. The commands can be removed in a similar way to how you added the commands to the Quick Access Toolbar.

  • Click on the downward-facing arrow at the end of the toolbar. Select the More Commands option.

More Commands

  • You will get a new window which will show the already added commands on the right side. This is the list of commands which are already in the quick access toolbar.
  • Select the command which you want to remove from the quick access toolbar. In the center, below the add button, a Remove button will be enabled. Press the OK button to make the applied changes.

Toolbar in Excel(Remove)

  • The Fill Color command is removed, and it will be disappeared from the Quick Access Toolbar, as shown below.

Toolbar in Excel example 3-3

Example #4

Moving the Position

According to your convenience, you can change the position of the toolbar. You can change the position from top to below the ribbon or vice versa.

  • Select the downward-facing arrow at the end of the toolbar, then select the Show Below the Ribbon option from the list.

Show below ribbon

  • Now the Toolbar is moved below to the ribbon.

Toolbar in Excel (Toolbar is moved)

Example #5

Adding Ribbon Commands

  •  Right-click on the tool within the ribbon which you want to add to the Toolbar in Excel. You will get the option to Add to Quick Access Toolbar. Here we right-clicked on the Table tool to add from the insert command.

Toolbar in Excel example 5-1

  • The command will be added to the Quick Access Toolbar as below.

Toolbar in Excel example 5-2

Things to Remember

  • Similar to the name Quick Access Toolbar, this is a customizable toolbar to access the tools easily.
  • It is possible to add any of the available commands in excel to the Excel Toolbar.
  • The visibility of the toolbar can be set above or below the ribbon.
  • Just through a right-click, you will get the option to add most of the command to the Toolbar in Excel.

Recommended Articles

This has been a guide to Toolbar in excel. Here we have discussed How to Use and Customize the Toolbar in Excel, along with practical examples. You can also go through our other suggested articles –

  1. Excel Shortcut For Merge Cells
  2. Insert New Worksheet In Excel
  3. Table Styles in Excel
  4. Add Rows in Excel Shortcut

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

7 Shares
Share
Tweet
Share
Primary 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 Reference Functions in Excel (34+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (23+)
  • Statistical Functions in Excel (58+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (21+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE
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

© 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
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.

Let’s Get Started

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA Login

Forgot Password?

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

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

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.

Special Offer - EXCEL ADVANCED Training Learn More