98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2003
Cindy has attended:
Excel Intermediate course
Excel Introduction course
Visio Introduction course
Visio Advanced course
Excel Advanced course
Excel
How do I customise toolbars in Excel
RE: Excel
Hi Cindy, Thank you for your post, in answer to your question:
To Customise your toolbars:
1. From the Tools menu choose Customize to open the Customize dialog box.
2. Click the Commands tab.
3. From the Categories list, select the category of the command you want to find.
4. From the Commands list, select the desired command.
5. Drag the command onto the desired toolbar.
6. Repeat Steps 3 to 5 for adding additional buttons.
7. Click Close when finished.
To Reset your toolbars:
1. From the Tools menu choose Customize to open the Customize dialog box.
2. Click the Toolbars tab.
3. Select the Toolbar you want to reset back to default.
4. Click Reset.
5. Click OK to the confirmation dialog box.
6. Repeat Steps 3 to 5 to reset addition toolbars.
7. Click Close when finished.
To Customise your menus:
Be VERY CAREFUL when following these steps. It's easy to lose menus.
1. From the Tools menu choose Customize to open the Customize dialog box
2. Click the Commands tab.
3. From the Categories list, select the menu to which you want to add a command.
4. From the Commands list, select the command you want to add.
5. Drag the selected command onto the appropriate menu.
6. Repeat Steps 4 to 6 for additional menu additions.
7. Click Close when finished.
I hope that has helped, if so please click the resolved link, regards Pete
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quickly hide and unhide rows and columnsUse the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D. |