Adding Excel Icons to the toolbar
Adding excel
icons to the toolbar for your commonly used functions is one
way to improve your efficiency in using Excel. For example,
you have an excel worksheet that has been preset with a print area.
After making some changes to the excel worksheet, the print area is no
longer valid. To set the print area, most people would normal go to the
menu and click on file, print area and then set print area. A total of
3 steps are involved. By adding an icon in the toolbar, I am able to do
the same action in one single step. The time saved is 67%! And the
soltuion is given below.
Adding excel icons to the toolbar
1. Move the mouse cursor somewhere in the toolbar area.
Click on the right mouse button and select customize which
is located at the end of the list. Alternatively, you can go
to the main menu, select tools and customize.
2. Activate the command tab.
3. In the category section, select file. Now go to the command category.
4. Scroll down the list until you find the description for set print area.
5. Move your mouse cursor over the label. Click and hold on to the
left mouse button, drag the icon out of the dialog box and place it
within the toolbar in a location of your choice.
6. Once you have done that, you can close the dialog box.
7. The icon has been added to the toolbar.
Removing excel icons from the toolbar
1. Move the mouse cursor somewhere in the toolbar area.
Click on the right mouse button and select customize which
is at then end of the list. Alternatively, you can go to the
main menu, select tools and customize.
2. Activate the command tab.
3. Move your mouse button over the icon you want to remove from the excel toolbar.
4. Click and hold on to the left mouse button, drag the icon
anywhere within the dialog box.
5. Let go of the left mouse button.
6. Once you have done that, you can close the dialog box.
7. The icon has been removed.
If you find the above steps difficult to follow, try this
video
on adding excel icons to the toolbar.
|
