Make the Most of Microsoft Excel with the Best Office 365 Toolbar

188

The Excel Office 365 Toolbar is the most important part of Microsoft Excel. It provides quick and easy access to all the features that are available in Excel.

Quick Access Toolbar is located above the main ribbon tab, It contains commands that are used most often, for example, Redo, Undo, and Save. Hence, it provides us with a variety of functions. Here we are discussing how to customize Microsoft Excel’s Quick Access Toolbar. The first step in customizing your Excel toolbar is to open up Microsoft Office 365 and then click on the “Customize” button on the top right corner of your screen.

1. How to customize the Quick Access Toolbar?

Following are the steps by which you can customize your toolbar easily.

Click on File in the Ribbon.
Click Options.
Click the Quick Access Toolbar.

2. How to add/remove a command from Quick Access Toolbar?

You can add or remove almost any command you want by following these simple steps.

Method of Adding :

Search for the option More Commands at the bottom of the list.
Now you will see a new menu that gives you a lot of options

Click the dropdown button to select Commands Not in the Ribbon,
Click on Add to move it to the Toolbar list.
Now press Ok to finish.

Method of removing :

Right-click on the command from the Toolbar.
Now, select Remove from Quick Access Toolbar from the list.

3. How to move the Quick Access Toolbar?

You can change the position of the toolbar by moving it to below the ribbon. Follow these steps;

The quick Access Toolbar is usually located in the upper-left corner.
Click the downward-facing arrow at the end of the toolbar and select the option Show Below the Ribbon

How to Move the Quick Access Toolbar

Add these commands/menu to Quck access tool bar

Quick access command list

Insert Page Break
_ From Text (Legacy)
+/- Buttons
16:g
3-0 color
3-0 Effects
3-0 Effects Mo
3-0 On,’Off
3-0 Picture Rotation
3-0 Text Rotation
3D Map
3D Model Size
3D Model Views
3-D Rotation
9 Undo
A Date Occurring…
Above Average…
Accent
Accept/Reject Changes
Accessibility
Accessibility Checker
Accounting Number Format
Accounting Number Formats
Actions
Active Field
Add a Chart
Add a cool reflection below your
Add a Digital Signature
Add a Hyperlink
Add a Signature Line
Add Assistant
Add Chart Element
Add Current Pen to Favorite Pens
Add or Remove Filters
aright
Arrow: Down
Arrow: Right
As Picture
Aut oSave
AutoCorrect Options…
AutoFilter
AutoFormat…
Back
Back (WebG08ac
Back (WebG08ack
Border Line Color
Border Line Style
Brightness
Bring Forward
Bring to Front
Button (Form Control)
Calculate Full
Calculator
Camera
Check Box (ActiveX Control)
Check Box (Form Control)
Check for Updates
Close All
Close Window
Collapse the Ribbon
Colon
Combine Characters
Combo Box (ActiveX Control)
Combo Box (Form Control)
Combo Drop-Down – Edit (Form
Combo List – Edit (Form
Comma
Command Button (ActiveX Contr…
Comments
Compare and Merge Workbooks…
Connector: Elbow
Connector: Elbow Arrow
Constrain Numeric
Contrast
Convert to Freeform
Copy as Picture…
Copy Ink As Text
Create a Slicer or Assign an Existi…
Create Chart
Create Microsoft Outlook T
Create Microsoft Outlook Task
Curve
Custom Views
Customize Quick Access Toolbar…
Customize Ribbon
Cycle Font Colors
Dark Shading
Depth
Diagonal Down
Diagonal Down 8c
Diagonal Down Border
Diagonal Up Border
Dim
Direction
Discard Changes and Refresh
Distribute Text
Division Sign
Document
Document Location
Dollar Sign
Draw Border
Draw Border Grid
Draw Borders
Draw Outside Border
Edit Cell Styles
Edit Code
Edit Query…
Email
End Review…
Equal Sign
Erase Border
Expand Drawing
Exponentiation Sign
Fit Drawing to Contents
Fit Drawing to Conti
Flip Horizontal
Flip Vertical
Form…
Forward
Free Rotate
Freeform: Scribble
Freeform: Shape
Freeze First Column
Freeze Panes
Freeze Top Row
From Access (Legacy)
From Data Connection Wizard (L…
From OData Data Feed (Legacy)
From SQL Server (Legacy)
From Web (Legacy)
From XML Data Import (Legacy)
Group Box (Form Control)
gullets and Numbering…
Help Improve Office?
Hide Ribbon
Highlight Changes…
Image (ActiveX Control)
Import External
Import External Data
Insert a Power View Repo
Insert Cells…
Insert Sheet Columns
Insert Sheet Rows
Insert Slicer…
Insert Table
Insett Picture
Insett Sheet Rows
Insett Table
Inside Borders
Inside Horizontal Border
Inside Vertical Border
Isosceles Triangle
Justify
Label (ActiveX Control)
Label (Form Control)
Left Brace
Left Parenthesis
Less Brightness
Less Contrast
Light Shading
Lighting
List Box (ActiveX Control)
List Box (Form Control)
Merge & Center
Metal
Minimize Window
Minus Sign
More 3-0 Colors…
More Border Colors…
More Brightness
More Contrast
More Controls
More Shadow Colors…
Multiplication Sign
Name Manager
New Database Query…
New File
Normal Lighting
Nudge Down
Nudge Left
Nudge Right
Nudge Shadow Down
Nudge Shadow Left
Nudge Shadow Right
Nudge Shadow Up
Nudge Up
Office Insider
Open
Option Button (ActiveX Control)
Option Button (Form Control)
Options: Addlns
Options: Advanc
Options: Advanced Options
Options: Customize Ribbo
Options: Data
Options: Ease of Access
Options: Formulas
Options: Home
Options: Language
Options: Quick Access Toolbar
Options: Saving
Options: Spelling and Proofing
Options: Trust Center
Options: Trust Center Settings
Oval
Page Setup
Parallel
Paste
Paste and Keep Cell Formatting
Paste and Keep Source Column
Paste and Keep Source Formatting
Paste and Keep Text Only
Paste and Match Destination For…
Paste and Merge Conditional For…
Paste and Remove Borders
Paste and Transpose
Paste and Use Destination Theme
Paste as Hyperlink
Paste as Linked Picture
Paste as Picture
Paste Formatting
Paste Formulas
Paste Formulas and Number For…
Paste Ink
Paste Link…
Paste Special…
Paste Values
Paste Values and Number Format…
Paste Values and Source Formatti…
Percent Sign
Permission
Perspective
Picture Corrections Options
PivotChart
PivotChat
PivotTable
PivotTable and PivotChart Wizard
PivotTable Filter Connections
Plastic
Plus Sign
Print List
Print Preview and Print
Print Preview Full Screen
Privacy Options…
Privacy Settings
Property Sheet
Protect Sharing (Legacy)
Publish as Web Page…
Query Parameters
Quick Print
Rectangle
Rectangle: Rounded Corners
Redo
Refresh All
Repeat
Reply with Changes…
Reset Artistic Effects
Reset Office Add-in Shortcut Pref…
Reset Picture Color
Reset Picture Corrections
Resize Drawing
Restore Window
Right Brace
Right Parenthesis
Rotate Left
Rotate Right
Save
Save As
Scenario
Scroll Bar (ActiveX Contro
Scroll Bar (Form Control)
Select
Select All
Select Current Region
Select Multiple Objects
Select Names
Select Visible Cells
Semitransparent Shadow
Send Backward
Send for Review…
Send Now
Send to Back
Send to Exchange Folder
Send to Mail Recipient
Set AutoShape Defaults
Set Print Area
Shadow Color
Shadow Effects
Shadow On/Off
Shapes
Share
Share Workbook (Legacy)
Show Outline Symbols
Single Web Page r.mht)
Size and Position…
Sort Ascending
Sort Descending
Sort…
Speak Cells
Speak Cells – Stop Speaking Cells
Speak Cells by Columns
Speak Cells by Rows
Speak Cells on Enter
Speech Bubble: Rectangle with C…
Spelling…
Spin Button (ActiveX Control)
Spin Button (Form Control)
Split Cells…
Star: 5 Points
Start Inking
Straight Arrow Connector
Straight Connector
Strikethrough
Style
Subscript
Sum
Superscript
Surface
Surface Material
Synchronize List
Tab Order…
Text Box (ActiveX Control)
Text Field (Form Control)
Tilt Down
Tllt Left
Tllt Right
Tllt Up
Toggle Bottom Border
Toggle Button (ActiveX Control)
Toggle Full Screen View
Toggle Left Border
Toggle Read Only
Toggle Right Border
Toggle Top Border
Touch/ Mouse Mode
Touch/Mouse Mode
Track Changes (Legacy)
Undo
Update File
Version History
Vertically Distributed
Web Options…
Web Page Preview
What’s New
Wire Frame
WordArt Vertical Text
X
x Insert Function
z Toggle Button (ActiveX Control)
Zoom
Zoom In