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
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
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.
Create your own menu in Excel including the tools and features you use regularly
Become comfortable using toolbars in Excel. This article explains the various techniques required to manipulate toolbars in Excel 2003.
More by this Author
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...
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...
If you are using Microsoft Project to schedule and track your projects, at some point you will probably want to export your project data into Excel. Excel can then be used to analyse and summarise your project data...
No comments yet.