Office 2000 Toolbars, Page 2

Toolbars, Page 1

Office Contents Page

Home

Excel 97 Toolbars

• Standard: In addition to the most frequently used commands (New, Open, Save, Undo and Redo, Cut, Copy, Paste, etc.), Excel's Standard toolbar also contains Summation and Function buttons, Ascending and Descending Sort buttons; buttons that open the Chart Wizard, the Map and the WordArt toolbars.
   

  
   

• Formatting: Commonly used formatting tools such as the Font Style and Size boxes, Bold, Italic, and Underline; text alignment buttons, Increase and Decrease Indent, etc.

  In addition, you'll find buttons to change cell formatting to Currency, Percent, and Comma thousands separator styles; and Borders, Background Color, and Font Color. There are also buttons to Increase and Decrease Decimal places without having to open the cell formatting dialog box.
   

• Chart: All of the tools that you need for creating, editing, and formatting charts using your Excel 97 data.
   
• Clipboard: All of the MS Office programs share the clipboard toolbar. See the previous page or Excel Help for more information.
   
• External Data: This toolbar contains several buttons to aid you when you're using external data in a query: Edit Query, Data Range Properties and Query Parameters, and Refresh Data, Refresh All, Cancel Refresh, and Refresh Status.

  If you need information on using data from external sources, please check Excel 2000's Help files. In the Index, search on 'external'. You'll find extensive information to help you.
   

• PivotTables: Here is what Excel 97's Help says about PivotTables:

  "A PivotTable is an interactive table that quickly summarizes, or cross-tabulates, large amounts of data. You can rotate its rows and columns to see different summaries of the source data, filter the data by displaying different pages, or display the details for areas of interest."

  Enter pivot table in Excel 2000 Help, then open About PivotTable reports: interactive data analysis to see if this Excel tool might be useful for you.

  The PivotTables toolbar contains various buttons to simplify up your use of this powerful analysis tool.
   

• Excel 2000's other toolbars are some of the same ones found in Word 2000 (as well as the other Office 2000 applications). You can read the descriptions above for the Control, Drawing, Forms, WordArt, and other toolbars.

Default Office 2000 Toolbars

When you install Microsoft Office 2000, all of the applications display the Standard and Formatting toolbars, which contain most of the tools you'll need to do ordinary document entry and formatting.

To see a button's function, hold the mouse pointer over it for a moment; a 'tool tip' will appear that describes the button's function and the shortcut key you can use to access it from the keyboard. Below are lists of the buttons on Word 97's default Standard and Formatting toolbars.

Standard Toolbar Buttons:

Formatting Toolbar Buttons:

Clicking on some toolbar buttons (e.g., the Drawing button) opens another toolbar. Other buttons can be dragged off of the toolbar to 'float' close to where you're working.

For example, if you're working in a table and want to apply borders to it or to put a border around certain paragraphs of your document, you can click on the arrow to the right of the Borders button to display all of the border choices.

Click on the colored bar at the top of the Borders palette and drag it somewhere close to your table or to the text you want to outline. When you're finished creating and formatting borders, close the toolbar by clicking on the Close button in the upper right corner (the X).

To display some of the other special function toolbars, highlight Toolbars... in the View menu then select a toolbar from the menu. You can also access the toolbar list by right clicking on an open toolbar, then left clicking on the one you'd like to open. Other available toolbars are:

Customize Toolbars

It's easy to remove toolbar buttons that you think you won't use or add any that aren't currently displayed (not all the buttons available for each toolbar are necessarily displayed).

• Add buttons to toolbars: Click anywhere on a toolbar with the right mouse button to display the toolbar shortcut menu, then click on Customize, OR

  Click on Toolbars... in the View menu, click on Customize..., then click on the Commands tab.

  On the left side of the Customize dialog box is a list of categories that correspond to the program's menus, with the first item highlighted. On the right are the commands that are available in that category.

  To find out what a button does, click once on it, then click on the Description button. If you want to add the button to your toolbar, simply drag it to the toolbar and drop it wherever you'd like.
   

• Delete buttons from toolbars: Open the Customize dialog box as described above and drag the button you want to delete off of the toolbar and drop it anywhere, except onto another toolbar. This removes the button from the toolbar, but it is still available through Customize; if you decide you need it at a later date, just add it as described above.
   
• Change the location of buttons on a toolbar: With the Customize dialog box open (see above), drag any button to a new location on the toolbar.
   
• Change the location of the toolbar: Click on the space between any two buttons on a toolbar to change it from 'fixed' to 'floating'; drag it anywhere on the screen and resize or reshape it to suit your needs. When you're through using it, either double click on the colored bar at the top (the title bar) to return it to its normal fixed position or click on the X in the upper right corner to close it.

If you're bored with the standard icons or need an extra toolbar for your most frequently used command buttons, look in Help for ways to change or modify the icons or create a new toolbar. In MS Word 2000 Help, look under Customizing Microsoft Word. Select Customizing Command Bars, then click on Customize menus and toolbars for step-by-step instructions.

Toolbars, Page 1

Office Contents Page

Home