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

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.