Customizing the Excel Toolbar
  Back to
List of Topics
 
  Home
This article will show you how to make your own customized toolbar. This will allow you have those often used menu command readily available to you. 
 

This exercise was written in Excel 2000. 

  • Click on  View  (in the menu) then Toolbars

  •  
  •  Click on Customize

  •  
  • Click on the  Toolbars  tab

  •  
  • Click on  New  button

  •  
  • Type a name for the new toolbar, such as  MyToolbar

  • A new toolbar is displayed on the screen. 
    The new toolbar may not be obvious at first, look for a toolbar that is only large enough to hold one button. It is many times located on the left side of your screen, but it could be anywhere

  • Click on the  Commands  tab

  •  
  • Click on the File category, then:

  •  
  • Drag the  Set Print Area  button onto the new toolbar

  • Click on the button, hold down the left mouse button and drag the button to its new location.
     
  • Click on the  Edit  category, then:

  •  
  • Click on the  Paste Formatting  button and drag it to the new toolbar

  •  
  • Click on the  Paste Values  button and drag it to the new toolbar

  •  
  • Click on the  Clear Contents  button and drag to the new toolbar

  •  
  • Click on the  Clear Formatting  button and drag it to the new toolbar

  •  
  • The toolbar should now look something like this:


     
  • Click on the  Paste Formats  button in the new toolbar and drag it to the right about one-half the width of a button

  • You should now have a separator between the first two buttons
     
  • Click on the  Clears Formulas/Values  button and drag it about the same distance to the right

  • You should now have a space between these two buttons
     
  • Click on the  Format  category, then:

  •  
  • Click on the  Left Border   button and drag it to the new toolbar

  • When you do so leave a space between this new button and last button on the toolbar
     
  • Click on the  Right Border   button and drag it to the new toolbar

  • Do not place a space between it and the Left Border button
     
  • Click on the  Top  Border   button and drag it to the new toolbar

  •  
  • Click on the  Bottom  Border   button and drag it to the new toolbar

  •  
  • Click on the  Double Bottom  Border   button and drag it to the new toolbar

  •  
  • Your new toolbar should now look like:

  •  
     
     
  • Click on Close 

  • To close the Customized dialog box
You now have the custom toolbar
 

Some Comments and Notes:
 

  • The new toolbar is most likely floating in the spreadsheet, you can move it simply by dragging it. 
     
  • It can be dragged to the toolbar section above the spreadsheet, just the like the standard toolbars.
     
  • The standard toolbar can be dragged down into the spreadsheet and become floating toolbars.
     
  • You can right click on a toolbar which is the same as View Toolbars.
     
  • When in the Toolbars secton of the Customize dialog box, unchecking the box next to the toolbars name hides it. Checking the box causes it to display.
     
  • To delete the toolbar, select it the Toolbars and click on the Delete button.

 

 

 
Top

 
 
 
 
 
 
 
 
 
 
 
 

 

solutions@info-stat.com