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

excel

ResolvedVersion 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

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.