Types of Toolbars in MS Excel – A Guide

What Is a Toolbar in Excel?

A toolbar is a band of icons displayed on the computer to perform certain functions by clicking.

Different Types of Toolbars in Excel

In MS Excel 365, there are icons on the Ribbon under the Home tab.

1. Quick Access Toolbar

The Quick Access Toolbar is a command line above the ribbon tabs.

Using the Quick Access Toolbar, you can create a new workbook.

You can also go to the File tab.

And click New.

You can customize the Quick Access Toolbar by clicking  Customize Quick Access Toolbar.

You can add a Menu by clicking it. Here, Open was added.

The Menu will be displayed in the Quick Access Toolbar.

You can choose More Commands.

In the Excel Options box, Add or Remove commands.

To change the appearance of Excel Options, go to the File tab.

Click Options.

Choose the Quick Access Toolbar.

In Quick Access Toolbar, Add/Remove a Menu in the Quick Access Toolbar. Here, Copy was added.

Click OK.

To remove a Menu (New File, here), click Remove.

Click OK.

The Quick Access Toolbar is customized.

2. Standard Menu Bar

The Standard Menu Bar is a compilation of tabs. Under each tab, there are groups with a number of commands.

2.1. List of Tabs in the Standard Menu Bar

• File  ——> contains mostly document and file-related commands such as Save, Save As, Open, Close, etc.

• Home  ——> comprises seven groups used to  edit and analyze text & tables.

• Insert ——> is used to add pictures, tables, symbols, etc..

• Draw ——>  offers drawing options: pen, pencil, and highlighter.

• Page Layout ——> allows you to arrange the document pages.

• Formulas ——>  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 ——> is normally used for large amounts of data:  to import, filter & sort data.

• Review ——>  helps to proofread documents.

• View ——> allows you to view the worksheets in different ways.

• Developer ——> provides options to create VBA applications, create macros, import and export XML data, etc.

• Add-ins ——>  provides features that are rarely needed.
• Help ——>  allows you to access the Help Task Panel and to contact Microsoft support.

2.2. Customizing the Standard Menu Bar

Steps:

• Select the File tab.

• Click Options.

The Excel Options will be displayed.

• Go to Customize Ribbon.
• In Main Tabs , choose Default Tabs .

• To create a new tab, click New Tab and customize it.

3. Formatting Bar

3.1. List of Groups in Formatting Bar of Home Tab

Clipboard  ——> allows you to copy or cut data and paste it.

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

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

Numbers ——>  gives you the option to change the number format.

Styles ——> allows you to highlight  tables and cells.

Cells ——> you can add, delete, or edit cells.

Editing ——>  helps you to organize data and apply mathematical functions.

Analysis ——> gives you the option to analyze data.

3.2. List of Groups in Formatting Bar of Insert Tab

Tables ——> You can create a table and arrange complex data in a pivot table.

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

Add-ins ——> adds additional functions.

Charts ——> provides options to visualize data in a graph.

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

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

Filters ——> can be used to highlight or hide cells.

Links ——>  are used to connect two or more files.

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

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

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

Themes ——>  helps to change the overall appearance.

Page Setup ——>  allows you to arrange the document.

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

Sheet Options ——> modifies the worksheet.

Arrange ——> is used to reposition images.

3.4. List of Groups in Formatting Bar of Formulas Tab

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

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

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

Calculation ——> gives the scope to evaluate data.

3.5. List of Groups in Formatting Bar of Data Tab

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

Queries & Connections ——>is used to find queries.

Sort & Filter ——>  sorts and filters.

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

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

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

Analysis ——> provides an overview of the entire data.

3.6. List of Groups in Formatting Bar of Review Tab

Proofing ——>  allows you to check the spelling.

Accessibility ——>  finds errors and the way to fix them.

Insights ——>  finds and highlights patterns.

Language ——> allows data translation.

Comments ——> allows to add or show additional words.

Protect ——> helps to secure the given data.

Ink ——>  allows you to draw or highlight.

3.7. List of Groups in Formatting Bar of View Tab

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

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

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

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

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

3.8. List of Groups in Formatting Bar of Developer Tab

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

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

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

XML ——> is used to represent structured information.

3.9. List of Groups in Formatting Bar of Help Tab

Help ——>  allows you to contact Microsoft.

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

Read More: How to Add Strikethrough in Excel Toolbar

Related Articles

• How to Show Toolbar in Excel
• How to Hide Toolbar in Excel
• How to Restore Toolbar in Excel