Related Tutorials
Excel Toolbars
Excel displays the Standard and Formatting toolbars by default. These are found below the menu bar at the top of the screen and provide a faster method of performing commands.
The Standard Toolbar
The Formatting Toolbar
Adding missing toolbar buttons
Depending on your settings the toolbars may be displayed on one or two rows. If they are displayed on one row, occasionally you will find the button that you want is missing. Click the chevrons at the end of the toolbar to show the missing buttons.
Click the button to use it. This button can now be seen on the toolbar in place of another button that has now been hidden.
Viewing and removing toolbars
There will be times when you need to use another toolbar, or maybe either the Standard or Formatting toolbars have gone missing.
To see a list of all the toolbars provided in Excel either right click a toolbar button or click Toolbars under the View menu and click the toolbar you wish to see or hide.
 |
Moving toolbars
Toolbars can be moved too. The toolbars at the top of the screen currently are known to be docked toolbars. You can move these by hovering your mouse over the ellipsis (the 4 dots) on the left of the toolbar and clicking and dragging them to another location.
The toolbar floats and can be dragged to any area of the screen. When you get close to any corner of the screen the toolbar will attempt to dock itself there.
Toolbar options
You can customise your toolbar settings. Right click on a toolbar button and click Customise.
 |
Notice the options in here to display the Standard and Formatting toolbars on two rows, and also the option to display screentips (when you hover the mouse arrow over an icon its function appears).
Follow us on
