Experiment with adding new buttons so that any task that you perform regularly has a one-click option.Your effi ciency with Excel would increase if you had a oneclick option for closing workbooks.
Customize the Standard toolbar to include a Close option near the Save option. Follow these steps.
1. From the menu, select View –> Toolbars –> Customize. The Customize option is the final choice in the list of toolbars.
2. This will display the Customize dialog box.While the Customize box is displayed, the toolbars are in a special state. You can take any toolbar button and drag it to a new location, to a new toolbar, or even drag it off the toolbar to delete it. Also, there are hundreds of new icons that you can add to your toolbars.
3. From the Customize dialog box, choose the Commands tab.
4. Choose a Category in the left listbox. From the right listbox, you can scroll through dozens of buttons in that category.
5. The Close button is located in the File category. Choose File from the left listbox.
6. Click on Close in the right listbox. Drag the item towards a toolbar. When you are on the toolbar, choose the desired location. Excel will display an I-Beam at the location where the button will be added.
7. When the I-Beam is in the proper location, release the mouse button. The button is added to the toolbar.
8. Choose OK to close the Customize dialog. The Close button will remain on your Standard toolbar in this and all future Excel sessions until you remove it.
discuss this topic to forum
