Create a New Toolbar in Excel 2003

Excel 2003 provides many toolbars such as Picture, PivotTable and Formula Auditing, that enable you to complete Excel tasks at the click of a button.  These toolbars usually appear whenever necessary, for example, the PivotTable toolbar appears on inserting a PivotTable.

However they do not have toolbars to include every Excel feature and it may be beneficial to create your own toolbar that contains the features you use the most.

All Office 2003 applications allow you to create your own toolbar. For this hub we will create a toolbar with the AutoFilter, Freeze Panes, Sort Ascending and Clear Formatting buttons. These are four extremely useful and popular tools within Excel.

Create a New Toolbar

1. Click Tools > Customize

2. Click the Toolbars tab in the Customize dialogue box

3. Click the New button

4. Enter a name for the new toolbar. For this hub, the toolbar will be called Useful Tools

Creating a new toolbar in Excel 2003
Creating a new toolbar in Excel 2003

5. Click Ok

6. The toolbar is created and should be visible on screen

Adding Buttons to the Toolbar

1. With the Customize dialogue box still open, Click the Commands tab

2. In the Categories list on the left, select Data

3. In the Commands list on the right, find AutoFilter and click and drag it onto your toolbar

Dragging the AutoFilter button onto the toolbar
Dragging the AutoFilter button onto the toolbar
Finished Toolbar
Finished Toolbar

4. Then find Sort Ascending in the Commands list and click and drag the button onto the toolbar

5. Select Edit in the Categories list, select Clear Formatting from the list of commands and move it onto the toolbar

6. And finally, select Window from the Categories list, find Freeze Panes in the Commands list and drag it onto the Useful Tools toolbar

7. Click Close

The toolbar has been created and includes 4 regularly used Excel tools. You can add as many buttons as you want to the toolbar so that it is customised completely to your needs.

It can then be placed (docked) anywhere on screen and will be available whenever need to create or edit a spreadsheet.

Find more great Excel tips in our Microsoft Excel Training Guides.

Related Links

Software training videos

Online training videos for Excel, Word, PowerPoint, Photoshop, Dreamweaver, Flash, JavaScript and much much more..

Create a new menu in Excel 2003

Create your own menu in Excel including the tools and features you use regularly

Using toolbars in Excel 2003

Become comfortable using toolbars in Excel. This article explains the various techniques required to manipulate toolbars in Excel 2003.

More by this Author

  • Sort Pictures in an Excel List
    0

    If you are using pictures in your Excel spreadsheet you may be having some difficulty with sorting the pictures along with the other data in the list. The good news is that you can sort pictures in an Excel list just...

  • Create an Interactive Excel Chart using Option Buttons
    6

    Form controls can be added to an Excel spreadsheet to create interactivity with the user. This article looks at using option button controls to allow a user to choose the data they want to see on a chart. The first...

  • Brock Lesnar Nutrition and Workouts
    2

    Brock Lesnar is a phenomenon of a man and an athlete. Brock Lesnar weighs a lean 265 lbs and yet possesses extreme speed, agility and athleticism. How a man carrying so much muscle mass can maintain such high levels of...


No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working