Excel > Excel 2003 Foundation > Getting Started

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

Standard toolbar

The Formatting Toolbar

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.

Add missing toolbar 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.

Viewing missing toolbars

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.

Customise toolbars dialogue box

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

Facebook  Twitter  You Tube