Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Toolbars & Menus > List all Toolbars< Previous | Next > 

 

New for 2003

 
 
Annotation PensYou must be using a Tablet PC.
Compare Side by Side 
Drawing and Writing Pens 
Ink Annotations 
ListLets you create, update and manipulate your lists quickly.
 

 

Note: * These are the identical in Word and PowerPoint

 
 
3-D Settings*Lets you give objects, lines and autoshapes a 3D appearance by changing the colour, depth, rotation and surface texture.
Align or Distribute*Lets you align multiple objects on the worksheet and to space them evenly.
AutoShapes*Lets you quickly insert lines, connectors, arrows, flowcharts, callouts and banners.
Basic Shapes*Lets you insert normal and 3D shapes such as triangles, squares, circles. You can also insert brackets and many more. This is an AutoShape tear off toolbar.
Block Arrows*Lets you insert many different types of both straight and 3D arrows. This is an AutoShape tear off toolbar.
BordersLets you quickly add and remove lines from your cells.
Callouts*Lets you insert callouts which are boxes with lines leading from them. This is an AutoShape tear off toolbar.
ChartLets you create a chart from data on a worksheet and allows you to access and toggle various chart items including the legend and data table.
Chart TypeLets you quickly select the different parts of a chart and aallow you to change the chart type easily.
Circular ReferenceLets you identify any circular references in your formulas and helps to remove them.
Connectors*Lets you insert lines that are attached to shapes and remain attached when they are stretched or moved. This is an AutoShape tear off toolbar.
Control Toolbox*Lets you add ActiveX controls to your worksheet which can be used with VBA.
Diagram*Lets you insert different types of diagrams including organisation, cycle, pyramid and radial.
Draw Border*Lets you quickly add or remove a border or border grid to a range of cells.
Drawing*Lets you add autoshapes, textboxes, diagrams and org charts as well as apply formatting including colours, arrows, shadows and 3D effects.
Drawing CanvasLets you arrange and resize the objects in your drawing.
Envelope 
Exit Design ModeLets you easily exit design mode when you are working with ActiveX controls from the Control Toolbox toolbar.
External Data 
Fill ColorLets you apply background shading to the current selection of cells.
Flowchart*This is an AutoShape tear off toolbar.
Font ColorLets you change the colour of the font for the current selection.
FormattingLets you apply and change the basic formatting of your worksheet such as font, font size, bold, alignment, number format, indenting as well as colours.
FormsLets you create your own forms by adding controls to the worksheet.
Formula AuditingLets you trace errors, display precedent and dependent arrows, provides quick access to the evaluate formula dialog box.
Full ScreenIf you select (View > Full Screen) to remove all the toolbars and row and column headings, this toolbar is displayed and allows you to close the full screen view.
Insert Shape*This is a tear off toolbar from the Organisation Chart toolbar.
Line Color*Lets you change the colour of the line around the border of an AutoShape.
Lines*Lets you add. This is an AutoShape tear off toolbar.
Nudge*Lets you move selected objects up. Down, left and right in small increments.
Online Meeting 
Order*Lets you move the selected object in front or behind other overlapping objects.
Organisation Chart* 
Pattern 
Picture*Lets you insert pictures from files and lets you apply formatting including changing the contrast, brightness, format as well as letting you crop and rotate the picture.
Pivot TableLets you manipulate, change and refresh a pivot table and pivot chart.
Pivot Table Field ListThis is actually a task pane.
Protection 
Refresh 
ReviewingLets you review changes, highlight changes and accept or reject changes made to a worksheet which is shared.
Rotate or Flip*Lets you rotate and flip any objects, lines or autoshapes on your worksheet.
Shadow Settings* 
StandardLets you perform most of the basic operations such as opening, saving, printing, copying, sorting as well as a quick way to access the help.
Stars and Banners*This is an AutoShape tear off toolbar.
Stop RecordingLets you easily stop recording a macro.
Task Pane 
Text To Speech 
Visual Basic*Lets you record and write your own macros to perfrom repetitve tasks.
Watch Window 
Web 
WordArt*Lets you format and edit text effects.
 

 

Redundant Toolbars

 
 
ClipboardThis has been replaced in Excel 2002 with the Clipboard task pane.
 

 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >