Tuesday, April 03, 2007

Toolbars in Microsoft Excel

What are tool bars?
Tool bars available in Microsoft Excel
Can custom tool bars be created in Microsoft Excel?

Definition:
Tool bars are list of commands arranged in a bar to facilitate one click action. It's a set of buttons arranged in a organised manner, the set of buttons being called tool bars and the buttons being called command buttons (other names are also being used to define a command button). Clicking a button on the tool bar triggers an action.

Excel standard toolbar
Shown above is the standard tool bar in Microsoft Excel.

Tool bars in Microsoft Excel:
The following tool bars are available in Microsoft Excel (Excel 2003)

  1. Standard
  2. Formatting
  3. Borders
  4. Chart
  5. Control Tool box
  6. Drawing
  7. Exit design mode
  8. External Data
  9. Forms
  10. Formula Auditing
  11. List
  12. Picture
  13. Pivot table
  14. Protection
  15. Reviewing
  16. Text to speech
  17. Visual Basic
  18. Watch Window
  19. Web
  20. Word Art
  21. Worksheet Menu Bar
The above are the frequently used tool bars in Microsoft Excel that are displayed by right clicking the worksheet menu bar. There are also other tool bars such as 3D, Shapes, Color and more in Microsoft Excel.

Custom tool bars in Microsoft Excel:
You can create custom tool bars in Microsoft Excel and also assign actions and events to the tool bars you have created. Excel supports this feature. But you need to program in Visual Basic environment to create and assign actions in tool bar.

No comments: