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. |
Map | In Excel 95 this was called Data Map and it allowed you to create maps using your data. In Excel 2000 this was not installed by default. This was then replaced with Microsoft MapPoint 2004. |
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. |
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