Excel Toolbars Personalizing

It is useful therefore, to know how to effectively use toolbars e.g. how to access hidden buttons, move them, view them and customise them.

It is useful therefore, to know how to effectively use toolbars e.g. how to access hidden buttons, move them, view them and customise them.

Floating and Docking

When a toolbar is positioned to one of the sides of the screen (usually the top), they are known as docked. And when they are hovering anywhere on screen they are known as floating.

You can move and dock a toolbar wherever you want on screen, placing it in the ideal position. To move a toolbar, you simply click and drag it.

2005_excel.pdf
For a floating toolbar, drag it by its Title Bar (the blue bar along the top)
For a docked toolbar, drag it by its 4 dots on the far left of the bar
Showing Hidden Buttons

A toolbar may not have enough room to display all of the buttons it has. If this is the case it will display the buttons that you use more regularly, hiding those that it deems are not so important.

To display a hidden button;

Click on the chevrons at the end of the toolbar
Click on the button you want to use from the drop down list
This button now replaces one of the buttons on the toolbar.

Display a Hidden Toolbar

Toolbars usually appear when needed. For example, on inserting a PivotTable into Excel, the PivotTable toolbar appears. However if the toolbar was closed the last time it was used, this will not happen.

There are 2 main ways to view a toolbar;

Click View > Toolbars
Select the toolbar you want to use
Or

Right click any toolbar button
Select the toolbar you want to use from the shortcut menu
Adding and Removing Buttons

Excel toolbars can be customised to suit your needs. You can add buttons to them, and also remove unwanted buttons.

To add a button to the toolbar;

Click Tools > Customize
Click the Toolbars tab and check the box of the one you want to customise, if necessary
Click the Commands tab
Scroll through the Categories list and select the category containing the button you want to add. For example, select Data to add the AutoFilter button
Scroll through the Commands list and click and drag the button you want to use onto the bar. Drop the button positioning it wherever you want along the bar
To remove a button from a toolbar;

Click Tools > Customize
Click and drag the button off the bar

See more Microsoft Excel training guides at Computergaga.com.

Article Source: http://EzineArticles.com/?expert=Al_Murray

Leave a Reply