List All Toolbars
Removed in 2007
* These were 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. |
Annotation Pens | You must be using a Tablet PC. Added in 2003. |
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 was 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. |
Borders | Lets you quickly add and remove lines from your cells. |
Callouts* | Lets you insert callouts which are boxes with lines leading from them. This was an AutoShape tear off toolbar. |
Chart Type | Lets you quickly select the different parts of a chart and aallow you to change the chart type easily. |
Chart | Lets 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. |
Circular Reference | Lets you identify any circular references in your formulas and helps to remove them. |
Clipboard | This was replaced in Excel 2002 with the Clipboard task pane. |
Compare Side by Side | Lets you compare and switch between windows. Added in 2003. |
Connectors* | Lets you insert lines that are attached to shapes and remain attached when they are stretched or moved. This was 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. |
Discussions | Lets you discuss files and tasks. |
Draw Border* | Lets you quickly add or remove a border or border grid to a range of cells. |
Drawing Canvas | Lets you arrange and resize the objects in your drawing. |
Drawing* | Lets you add autoshapes, textboxes, diagrams and org charts as well as apply formatting including colours, arrows, shadows and 3D effects. |
Envelope | Lets you print envelopes. |
Exit Design Mode | Lets you easily exit design mode when you are working with ActiveX controls from the Control Toolbox toolbar. |
External Data | Lets you manage and update any external data that is linked to your workbooks (eg web queries, database queries). |
Fill Color | Lets you apply background shading to the current selection of cells. This was a tear off toolbar from the Formatting toolbar. |
Flowchart* | This was an AutoShape tear off toolbar. |
Font Color | Lets you change the colour of the font for the current selection. This was a tear off toolbar from the Formatting toolbar. |
Formatting | Lets you apply and change the basic formatting of your worksheet such as font, font size, bold, alignment, number format, indenting as well as colours. |
Forms | Lets you create your own forms by adding controls to the worksheet. |
Formula Auditing | Lets you trace errors, display precedent and dependent arrows, provides quick access to the evaluate formula dialog box. |
Full Screen | If 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. |
Ink Annotations | Lets you annotate your work. Added in 2003. |
Ink Drawing and Writing | Lets you converts digital ink to text. Added in 2003. |
Insert Shape* | This was 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 was an AutoShape tear off toolbar. |
List | Lets you create, update and manipulate your lists quickly. Added in 2003. |
Nudge* | Lets you move selected objects up. Down, left and right in small increments. |
Online Meeting | Lets you have online meetings with other users that have Windows XP Net Meeting installed. |
Order* | Lets you move the selected object in front or behind other overlapping objects. |
Organisation Chart* | Lets you create, edit and format hierarchical organisation charts. |
Pattern | Lets you apply background patterns to the current selection of cells. This is not accessible by default but the command can be added from the Customise dialog box. This was a tear off toolbar from the Formatting toolbar. |
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 Table Field List | This was actually a task pane. |
Pivot Table | Lets you manipulate, change and refresh a pivot table and pivot chart. |
Protection | Lets you lock, unlock cells, protect worksheets and workbooks. |
Refresh | |
Reviewing | Lets 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* | This can be displayed from the Shadow Style command on the Drawing toolbar. |
Standard | Lets 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 Recording | Lets you easily stop recording a macro. |
Text To Speech | Lets you listen to cell contents. |
Visual Basic* | Lets you record and write your own macros to perfrom repetitve tasks. |
Watch Window | Lets you monitor the output generated from cell references by allowing you to debug and analyse complicated formulas. This was actually a dialog box. |
Web | Lets you access the internet directly from Excel. |
WordArt* | Lets you format and edit text effects. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext