Excel+t*

Excel

Cut down on Toolbar complexity

Are you aware that Excel has a handy feature for when you want to use Toolbar functions?

On the standard toolbar there’s an icon for Print and another for Print Preview.

You can rid yourself of many items in the clutter.

The Print and Print Preview buttons do exactly the same:

If you hold Shift when you press ’Print’, you will load the Print Preview dialogue, and vice versa.

Open and Save also bear the same relationship, as do Centre and Merge on Centre.

Other pairs include Increase / Decrease Decimal, and also Increase / Decrease Indentation,

Align Left / Right, Underline / Double Underline, along with various other pairs.

All these pairs work fine with a press of the button, or Shift and for the other of the pair.

If you can remember this little trick, you’ll find that it comes naturally to use just half of these icons, doubling up for the Shift function for each.

You can choose which ones to remove (and add back later) by visiting

View> Toolbars> Customise.