May 03, 2004

Customizing Toolbars, Part 2

In addition to customizing buttons, you can also customize the toolbars themselves.

Turning them on or off is quite easy. Right click any toolbar and select or deselect the toolbars you want to show or hide.

You can also make your own toolbars. Select Tools, Customize and then click on the Toolbars tab.

Push New (right hand corner). A small window should appear for you to input the new toolbar's name. I've decided to call my toolbar 'Quick Lines'.

When finished, switch back to the Commands tab and select the buttons you like. As the name implies, I have dragged across some line buttons to my toolbar. Place the toolbar anywhere you want, top, bottom, left or right.

How about menus? While the Customize dialog box is open, you can drag menus or submenus to wherever you like. If you look closely, you will see that some menus and commands (buttons) have a small line under one of their letters. This is to help navigate quickly by just using your keyboard.

For example, if you push Alt, 'I', 'N' and 'D' you will notice that the Define Name box appears. The shortcut keys used were Insert, Name and Define which become accessible when you push the Alt key. If you remember the shortcut keys that you use regularly, you will find that your work is completed a lot faster.

And in the absence of pre-defined shortcut keys? You can make your own.

With the Customize dialog box open, right click any button you want to change. In the menu that appears, you should see 'Name:' with the name of the menu or button. Add an ampersand (&) just in front of where you want to place the shortcut. For example, S&ave will give you Save.

That's it for the time being. Believe it or not, I'm on vacation and might take a few days off. In fact, tomorrow I will be meeting some fellow Excel people and hope to learn some new tricks. Of course, I will be sure to pass them onto you too...eventually :)

This page is powered by Blogger. Isn't yours?