Types of Toolbars in MS Excel (All Details Explained)

Get FREE Advanced Excel Exercises with Solutions!

MS Excel is a software program that is used to create spreadsheets. It helps the users to format, organize and calculate data using different types of toolbars in MS Excel. In order to perform its purposes quite efficiently, We use different toolbars.

What Is Toolbar in MS Excel?

A toolbar is a band of icons displayed on the computer to perform certain functions just by clicking on them. It reduces workloads and saves time. It is also very easy to operate. So, the Types of toolbars in MS Excel are a must to learn.

All Types of Toolbars in MS Excel

Many toolbars were enlisted separately in the previous versions of MS Excel as types of toolbars like Standard Toolbar, Formatting Toolbar, Formula Toolbar, etc.  The latest version of MS Excel which is MS Excel 365, have toolbars arranged under different Tabs in the Ribbons.

In MS Excel 365, There are icons in the Ribbon under the Home Tab which were in the Standard Toolbar and Formatting Toolbar in the previous versions of MS Excel.

Types of Toolbars in MS Excel

1. Quick Access Toolbar

The Quick Access Toolbar, a types of toolbars in MS Excel, is actually a command line that normally appears above the main ribbon tabs in Excel. We can actually use the options just by clicking on them rather than going from the Tabs.

From the Quick Access Toolbar, I can create a New Workbook just by clicking.

Types of Toolbars in MS Excel

We can create it instead of going to File Tab.

Then, click on New option.

Types of Toolbars in MS Excel

We can also customize the Quick Access Toolbar by clicking on Customize Quick Access Toolbar option.

You can add any other Menu just by clicking on it. Here, I further added the Open menu.

Types of Toolbars in MS Excel

You will have that Menu on the Quick Access Toolbar.

You can customize the Quick Access Toolbar more advanced way by choosing the More Commands option.

Types of Toolbars in MS Excel

An Excel Options box will appear. Now you can Add or Remove commands of your need and choice.

Types of Toolbars in MS Excel

We can also use another way for the appearance of the Excel Options box. For this, We need to go to the File Tab.

Then, Click on the Options.

Types of Toolbars in MS Excel

The Excel Options box will come forward. We can then choose the Quick Access Toolbar.

Types of Toolbars in MS Excel

From the Quick Access Toolbar option, We can Add/Remove any other Menu to the Quick Access Toolbar. Here, I first choose the Copy menu and then click on the Add option.

Types of Toolbars in MS Excel

Afterward, I hit the OK button and the Copy menu will be added to The Quick Access Toolbar.

Types of Toolbars in MS Excel

You can also remove the Menu that was added before. Here, I chose the New File menu and pressed the Remove button to customize the Quick Access Toolbar. Finally, click on the OK button.

Types of Toolbars in MS Excel

Thus, We can have a Customised Quick Access Toolbar.

Read More: How to Show Toolbar in Excel (4 Simple Ways)

2. Standard Menu Bar

Standard Menu Bar is actually a compilation of Tabs. Under each Tab, there are some groups with a number of commands. It is usually placed on the top of the worksheet.

2.1. List of Tabs in Standard Menu Bar

  • File  ——> The File Tab contains mostly document and file-related commands such as Save, Save As, Open, Close, etc.
  • Home  ——> Home Tab comprises seven groups. With the help of it, We can edit and analyze text & tables.
  • Insert ——> We can add pictures, tables, symbols, etc through this Tab.
  • Draw ——> Draw tab offers options to draw through pen, pencil, and highlighter.
  • Page Layout ——> Page Layout allows you to arrange your document pages just the way you want them.
  • Formulas ——> It allows you to choose functions from over 300 functions arranged in financial, logical, text, date & time, lookup and reference, maths & trig, statistical, etc categories.
  • Data ——> Data is normally used for large amounts of data. It is very handy to import data from servers, and the web and also to filter & sort data.
  • Review ——>  It helps to proofread the documents.
  • View ——> View gives us the opportunity to view the worksheets in different ways.
  • Developer ——> Developer Tab provides options to create VBA applications, create macros, import and export XML data, etc.
  • Add-ins ——>  Add-ins allow using the features that are not directly offered or rarely needed.
  • Help ——> Help tab allows you to access quickly to the Help Task Panel and allows you to contact Microsoft support, suggest a feature, send feedback, and have quick access to training videos.

These are the features of Standard types toolbars in MS Excel.

2.2. Customizing Standard Menu Bar

In the List of Tabs in the Standard Menu Bar, I have mentioned all the names of the available Tabs. Anyone can customize his Standard Menu Bar by selecting the frequently used Tabs.


  • Select File Tab.

Types of Toolbars in MS Excel

  • Click on Options.

Types of Toolbars in MS Excel

An Excel Options box will appear.

  • Then, go to Customize Ribbon. Here, We will have all the Default Tabs in the Main Tabs section.

We can also create a new tab with the preferred groups. For this, We have to click on the New Tab button. Then, we will be able to customize it according to our choice.

Types of Toolbars in MS Excel

Read More: How to Unlock Grayed out Menus in Excel (5 Effective Ways)

3. Formatting Bar

Formatting Bar provides several functions in a few groups to format the selected texts.

3.1. List of Groups in Formatting Bar of Home Tab

Clipboard  ——> The Clipboard allows you to Copy or Cut data and Paste it to the places.

List of Commands

  • Paste
  • Cut
  • Copy
  • Format Painter

Font ——> Font helps you to change the format, size, and style of the texts.

List of Commands

  • Fonts
  • Font Size
  • Font Style
  • Underline
  • Color
  • Effects

Alignment ——> Alignment allows you to relocate the position of the texts.

List of Commands

  • Text Alignment
  • Text Control
  • Text Direction

Numbers ——> It gives the option to change the number format. We can change the numbers into time, date, currency, etc based on our needs.

Styles ——> Styles give you permission to highlight the tables as well as their cells in different ways.

List of Commands

  • Conditional Formatting
  • Format as Table
  • Cell Styles

Cells ——> We can add, vanish or edit cells using the functions in Cells.

List of Commands

  • Insert
  • Delete
  • Format

Editing ——> Editing helps you to organize data as well as apply it to mathematical functions.

List of Commands

  • AutoSum
  • Fill
  • Clear
  • Sort & Filter
  • Find & Select

Analysis ——> The Analysis gives the option to Analyze Data to show intelligent, personalized suggestions.

3.2. List of Groups in Formatting Bar of Insert Tab

Tables ——> Tables allow you to create a suitable table for the data and arrange complex & suitable data in a pivot table.

List of Commands

  • Pivot Table
  • Recommended Pivot Tables
  • Table

Illustrations ——> Illustrations allow you to insert pictures and shapes and take screenshots.

List of Commands

  • Pictures
  • Shapes
  • Icons
  • 3D Models
  • Smart Art
  • Screenshot

Add-ins ——> Add-in is actually a program to add additional functions. It can increase memory or add graphics or communication capabilities to a computer.

List of Commands

  • Get Add-ins
  • My Add-ins

Charts ——> Charts present the options to visualize the data in a graphical form.

List of Commands

  • Recommended Charts
  • Maps
  • Pivot Chart

Tours ——> Tours contain the command to launch Power Map and add selected data to the Power Map.

List of Commands

  • 3D Map

Sparklines ——> Sparklines allow you to create a small visual representation in a cell.

List of Commands

  • Line
  • Column
  • Win/Loss

Filters ——> Filters can be used to highlight the particular cells and hide the rest.

List of Commands

  • Slicer
  • Timeline

Links ——> Links are used to establish two or more files in a single click.

Text ——> Text Tab allows you to write text and modify the text.

List of Commands

  • Text Box
  • Header & Footer
  • Word Art
  • Signature Line
  • Object

Symbols ——> Symbols help to add arithmetic operators in Excel Formulas.

List of Commands

  • Equation
  • Symbol

3.3. List of Groups in Formatting Bar of Page Layout Tab

Themes ——> Themes help to change the overall appearance.

List of Commands

  • Themes
  • Colors
  • Fonts
  • Effects

Page Setup ——> Page Setup allows you to arrange the document page as your choice.

List of Commands

  • Margin
  • Orientation
  • Size
  • Print Area
  • Breaks
  • Background
  • Print Titles

Scale to Fit ——> Scale to Fit helps to resize the page.

List of Commands

  • Width
  • Height
  • Scale

Sheet Options ——> Sheet Options works to modify the worksheet appearances.

List of Commands

  • Gridlines
  • Headings

Arrange ——> Arrange is normally used to reposition the inserted images perfectly.

List of Commands

  • Bring Forward
  • Send Backward
  • Selection Pane
  • Align
  • Group
  • Rotate

3.4. List of Groups in Formatting Bar of Formulas Tab

Function Library ——> Function Library represents the Insert Function dialogue box which allows to search for a particular function and displays the list of functions in a category.

List of Commands

  • Insert Function
  • Auto Sum
  • Recently Used
  • Financial
  • Logical
  • Text
  • Date & time
  • Lookup & Reference
  • Math & Trig
  • More Functions

Defined Names ——> Defined Names symbolize a single cell, range of cells, constant value, or formula.

List of Commands

  • Name Manager
  • Defined Name
  • Use in Formula
  • Create from Selection

Formula Auditing ——> Formula Auditing helps to represent graphically the relationship between formulas and cells.

List of Commands

  • Trace Precedents
  • Trace Dependents
  • Remove Arrows
  • Watch Window

Calculation ——> Calculation gives the scope to evaluate the data.

List of Commands

  • Calculation Options
  • Calculate Now
  • Calculate sheet

3.5. List of Groups in Formatting Bar of Data Tab

Get & Transform Data ——> Get & Transform data helps to connect external data and customize it.

List of Commands

  • Get Data
  • From Text/CSV
  • From Web
  • From Table/Range
  • Recent Sources
  • Existing Connections

Queries & Connections ——> Queries & Connections is widely used to find queries when you have so many queries.

List of Commands

  • Refresh All
  • Queries & Connections
  • Properties
  • Edit Links

Sort & Filter ——> Sort & Filter helps to decorate by sorting and filtering.

List of Commands

  • Sort
  • Filter
  • Clear
  • Reapply
  • Advanced

Data Tools ——> Data tools are used to validate and modify data.

List of Commands

  • Text to columns
  • Flash Fill
  • Remove Duplicates
  • Data validation
  • Consolidation
  • Relationships
  • Manage Data model

Forecast ——> Forecast helps to predict the future values using linear regression.

List of Commands

  • What-If Analysis
  • Forecast Sheet

Outline ——> An Outline is used to add an organizational quality to a long or wide worksheet.

List of Commands

  • Group
  • Ungroup
  • Subtotal
  • Show Detail
  • Hide Detail

Analysis ——> Analysis is to overview the entire data.

List of Commands

  • Data Analysis

3.6. List of Groups in Formatting Bar of Review Tab

Proofing ——> Proofing allows you to check the spelling on the current worksheet.

List of Commands

  • Spelling
  • Thesaurus
  • Workbook Statistics

Accessibility ——> Accessibility is to find the error and the way to fix it.

List of Commands

  • Check Accessibility

Insights ——> Insights based on machine learning find and highlight patterns.

List of Commands

  • Smart Lookup

Language ——> Language helps to translate the data into another language.

List of Commands

  • Translate

Comments ——> Comments allow to add or show additional words with the data.

List of Commands

  • New Comments
  • Delete
  • Previous
  • Next
  • Show/Hide Comments
  • Show All Comments

Protect ——> Protect helps to secure the given data.

List of Commands

  • Protect Sheet
  • Protect Workbook
  • Allow Edit Ranges
  • Unshare Workbook

Ink ——> Ink allows you to draw something or highlight the content.

List of Commands

  • Hide Ink

3.7. List of Groups in Formatting Bar of View Tab

Workbook Views ——> Workbook Views is used to control the appearance of the workbook.

List of Commands

  • Normal
  • Page Break Preview
  • Page Layout
  • Custom Views

Show ——> Show allows you to modify the worksheet view.

List of Commands

  • Ruler
  • Gridlines
  • Formula Bar
  • Headings

Zoom ——> Zoom is used to control the size of the worksheet view.

List of Commands

  • Zoom
  • 100%
  • Zoom to Selection

Window ——> Window helps to open, create, freeze or hide the window.

List of Commands

  • New window
  • Arrange All
  • Freeze Panes
  • Split
  • Hide 
  • Unhide
  • View Side by Side
  • Synchronous Scrolling
  • Reset Window Position
  • Switch windows

Macros ——> Macros show or record the used code in the worksheet.

3.8. List of Groups in Formatting Bar of Developer Tab

Code ——> Code helps us to use and modify programming language.

List of Commands

  • Visual Basic
  • Macros
  • Record Macro
  • Use Relative References
  • Macro Security

Add-ins ——> Add-ins help to add the features that are rarely used.

List of Commands

  • Add-ins
  • Excel Add-ins
  • COM Add-ins

Controls ——> Controls help to edit the code and switch the design mode to on or off.

List of Commands

  • Insert
  • Design Mode
  • Properties
  • View Code
  • Run Dialog

XML ——> XML is used to represent structured information.

List of Commands

  • Source
  • Map Properties
  • Expansion Packs
  • Refresh Data
  • Import
  • Export

3.9. List of Groups in Formatting Bar of Help Tab

Help ——> Help allows you to contact Microsoft for any query.

List of Commands

  • Help
  • Contact Support
  • Feedback
  • Show Training

Community ——> Community helps to communicate with the Excel experts.

List of Commands

  • Community
  • Excel Blog

These are the formatting Bar’s options or commands which are also considered as toolbars types in MS Excel.

Read More: How to Add Strikethrough in Excel Toolbar (3 Easy Ways)


I have tried to elaborate as simple as possible to show the types of toolbars in MS Excel. I hope it will be helpful for Excel users. For any other queries, comment below.

Related Articles

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF