Computer Training & Application Solutions made Simple
Contact us for a free consultation
  • Click to send us an email. We'd love to hear from you!   Ottawa       613-656-4229
  • Click to send us an email. We'd love to hear from you!   Montreal    514-342-9494

Making Your Toolbars Work for YOU!

By Deborah J. Sparks

Do you find yourself going back to the same menu over and over again to select an option that isn't available on a toolbar? Why not add a button to your toolbar instead? Or, better yet, create your own toolbar and add the items you use the most.


  1. Click the Tools menu, Customize option, Commands tab
  2. Select a Category to see its list of Commands
  3. Select a command button and drag it to a currently displayed toolbar (a vertical bar will indicate the destination)
  4. Once you've added the buttons, close the dialog box


  1. Click the Tools menu, Customize option, Toolbars tab
  2. Click the New button and type a name for the toolbar (hint: type in CAPS to distinguish your toolbar from the ones that come with the program)
  3. Click the Customize tab and follow the instructions above to add buttons to your toolbar

Hint: If you are a laptop user and don't have a numeric keypad, add the buttons most frequently required for Excel formulas, including: = + - * /

Note: In Office 2007 the Ribbon has replaced toolbars, but you can customize your Quick Access toolbar.

There are many other ways to customize and personalize
your computer environment so that it works for you - and not the other way around!

More Newsletter Articles

© 2009 DJH Training & Application Solutions Inc.

WOULD YOU LIKE TO USE THIS ARTICLE IN YOUR NEWSLETTER, EZINE OR WEB SITE? You can, as long as you include this complete blurb with it: An entrepreneur at heart, Deborah J. Sparks established DJH Training & Application Solutions Inc. over 20 years ago, realizing her dream of creating a company known for providing high quality computer software training, application development and support and exercising her passion for teaching. To learn more and to register for DJH's free newsletter, Innovations, please visit