List All Toolbars
Removed in 2007
* These were identical in Word and PowerPoint.
|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.
|You must be using a Tablet PC. Added in 2003.
|Lets you quickly insert lines, connectors, arrows, flowcharts, callouts and banners.
|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.
|Lets you insert many different types of both straight and 3D arrows. This is an AutoShape tear off toolbar.
|Lets you quickly add and remove lines from your cells.
|Lets you insert callouts which are boxes with lines leading from them. This was an AutoShape tear off toolbar.
|Lets you quickly select the different parts of a chart and aallow you to change the chart type easily.
|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.
|Lets you identify any circular references in your formulas and helps to remove them.
|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.
|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.
|Lets you add ActiveX controls to your worksheet which can be used with VBA.
|Lets you insert different types of diagrams including organisation, cycle, pyramid and radial.
|Lets you discuss files and tasks.
|Lets you quickly add or remove a border or border grid to a range of cells.
|Lets you arrange and resize the objects in your drawing.
|Lets you add autoshapes, textboxes, diagrams and org charts as well as apply formatting including colours, arrows, shadows and 3D effects.
|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.
|Lets you manage and update any external data that is linked to your workbooks (eg web queries, database queries).
|Lets you apply background shading to the current selection of cells. This was a tear off toolbar from the Formatting toolbar.
|This was an AutoShape tear off toolbar.
|Lets you change the colour of the font for the current selection. This was a tear off toolbar from the Formatting toolbar.
|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.
|Lets you create your own forms by adding controls to the worksheet.
|Lets you trace errors, display precedent and dependent arrows, provides quick access to the evaluate formula dialog box.
|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.
|Lets you annotate your work. Added in 2003.
|Ink Drawing and Writing
|Lets you converts digital ink to text. Added in 2003.
|This was a tear off toolbar from the Organisation Chart toolbar.
|Lets you change the colour of the line around the border of an AutoShape.
|Lets you add. This was an AutoShape tear off toolbar.
|Lets you create, update and manipulate your lists quickly. Added in 2003.
|Lets you move selected objects up. Down, left and right in small increments.
|Lets you have online meetings with other users that have Windows XP Net Meeting installed.
|Lets you move the selected object in front or behind other overlapping objects.
|Lets you create, edit and format hierarchical organisation charts.
|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.
|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.
|Lets you manipulate, change and refresh a pivot table and pivot chart.
|Lets you lock, unlock cells, protect worksheets and workbooks.
|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.
|This can be displayed from the Shadow Style command on the Drawing toolbar.
|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.
|Lets you easily stop recording a macro.
|Text To Speech
|Lets you listen to cell contents.
|Lets you record and write your own macros to perfrom repetitve tasks.
|Lets you monitor the output generated from cell references by allowing you to debug and analyse complicated formulas. This was actually a dialog box.
|Lets you access the internet directly from Excel.
|Lets you format and edit text effects.
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext