excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · 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

Edited on Fri 11 Jul 2008, 09:00

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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Quickly hide and unhide rows and columns

Use 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.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips


Server loaded in 0.09 secs.