Standard Toolbar

Toolbar: Standard (floating)

Icon: Excel 97Icon: Excel 2000 Button: New New button

The New button creates a new blank document using the default template.

The  File  |  New  command on the menu opens the New dialog, which gives you a choice of templates.

Icon: Excel 97Icon: Excel 2000 Button: Open Open button

The Open button brings up the Open dialog box for you to choose a document to open. The illustration is for Excel 2000 in Windows 98, but it is very similar in other versions.

Open dialog in Windows 98

TipRecently opened files are listed at the bottom of the File menu. So using the menu may be faster for documents you worked on recently.

Icon: Excel 97Icon: Excel 2000  Button: Save Button: Save

The Save button saves the current document back where it came from. If the document has never been saved before, you will get a dialog box to choose a folder and filename.

WarningYou can get into trouble if you are editing an old document for a new purpose and don't want to lose the old one. You must use the menu command  File  |  Save As  to get the dialog box you need to save with a different filename. Otherwise you will overwrite the old document.

Icon: Excel 97Icon: Excel 2000 Button: Email Email button

The Email button lets you send someone the current worksheet or the entire workbook by email.

Icon: Excel 97Icon: Excel 2000 Button: Print  Button: Print

Will print all rows and columns that it thinks contain data.

WarningSometimes Excel gets confused if you delete data or format blank cells. Always preview before you print a spreadsheet.

Suggestion: Use  File  |  Print  to open the Print dialog, where you can choose to print only part of the sheet or workbook. 

Icon: Excel 97Icon: Excel 2000 Button: Print Preview Print  Preview button

Shows what your document will look like when it is printed. You should always preview before you print. By checking carefully before you actually print, you can avoid mistakes and save a lot of time and paper. It is especially important to preview spreadsheets because they often are too wide to fit on one sheet.

Icon: Excel 97Icon: Excel 2000 Button: Spell Check Spell Check button

Checks spelling for your text but will not check spelling in your formulas. Excel will not check your grammar.

Icon: Excel 97Icon: Excel 2000 Buttons: 
Cut. Copy, & Paste Cut, Copy, and Paste buttons

The Cut, Copy, and Paste buttons work as usual.

Cut removes the selected text to the Windows Clipboard.
Copy places a copy of selected text on the Windows Clipboard.
Paste places a copy of what was on the Windows Clipboard at the cursor location. (Do you see the tiny clipboard in the Paste button's picture?)

When you want to paste a range of cells that you have copied or cut, just select the cell you want to be at the upper left of the pasted data and Paste.

WarningWhen you paste data in Excel, it remains on the Windows Clipboard only until you execute a different command rather than until you copy something new. So you can paste the same data several times in a row to different places, but once you do something else, the data is cleared from the Clipboard.

Icon: Excel 97Icon: Excel 2000 Button: Format Painter Format Painter button

Format Painter copies the formatting from one cell to another.

How it works: First select the cell with the formatting you want to use. Click on the Format Painter button. The mouse pointer changes to the Format Painter shape. Click on the cell that you want to have that same formatting. The mouse pointer changes back and you are done.

You can apply Format Painter to more than one location if you double-click the button. The mouse pointer will remain in the Format Painter shape until you click the button again.

Format Painter works with whole cells only. You cannot use it to format only part of the text in a cell.

WarningFormat Painter will use the first formatting it finds. For example, if the cell's text uses 2 different colors, Format Painter uses the first color used in the cell it is copying from.

Cell formatted with Format Painter

Icon: Excel 97Icon: Excel 2000Buttons: Undo and Redo Undo and Redo buttons

The Undo button lets you reverse an action you just performed. Redo lets you change your mind and do that action all over again.

Button- Undo with list expandedNew for 97 Excel keeps track of only the last 16 actions. Before Excel 97 only the last action could be reversed. Not fun at all!

The list of actions gives the actual cell reference for some actions. There is only one Undo list that covers all sheets in the workbook. The cell references do not include the sheet name. It's easy to get confused!

Icon: Excel 97Icon: Excel 2000 Button: Hyperlink Hyperlink button

The Hyperlink button opens a dialog for you to create a hyperlink in the spreadsheet. When you view the spreadsheet on a computer, clicking on the link will open the resource at the URL used in the link. This could be a web page, another spreadsheet, a Word document, or a sound file.

Icon: Excel 97Icon: Excel 2000 Button: AutoSum AutoSum button

AutoSum will intelligently add up the numbers in the column above or the row to the left of the active cell. Once you leave the cell that contains the formula, you will see the total in the cell, instead of the formula.

AutoSum adds numbers in the column above AutoSum adds values of cells in row to the left.

Icon: Excel 97Icon: Excel 2000 Button: Paste Function   Paste Function button

The Paste Function button allows you to select one of the functions that Excel already knows and paste it into a formula. For most functions, you will then get another dialog where you can enter each of the numbers that the function needs. You can even select a cell or range of cells instead of typing actual numbers.

Using the dialogs means you won't have to remember where all the parentheses and commas go in the function. Very handy!!

Dialog - Paste Function

Button: Paste Function (Excel 2002) at left of Formula textboxIcon: Excel 2003 In Excel 2002/2003 the Paste Function button is at the left of the Formula textbox.

Icon: Excel 97Icon: Excel 2000 Buttons: Sort  Buttons: Sort ascending and descending

The Sort Ascending and Sort Descending buttons will rearrange the selected cells in a column in numerical or alphabetical order.


Cells before sort - numbers   Cells after sort - numbers





Cells before sort - names Cells after sort - names



If you select cells in rows and sort, the rows will be rearranged based on what is in the first cell of each row. To sort on a different column you must use the Sort dialog from the menu command  Data |  Sort... 

Selecting cells
in two columns
Sorted based
on first column



Warning Be careful when sorting in a spreadsheet. You can get your data mixed up if you do not select all of the cells that should remain together.

Error: Sorting cells in a column leaves the cells beside in place



Note: In Word these buttons are on the Tables and Borders bar.

Icon: Excel 97Icon: Excel 2000 Button: Chart Wizard  Chart Wizard button

The Chart Wizard button opens a wizard which helps you turn your data into a chart.

Dialog - Chart Wizard

Icon: Excel 97Icon: Excel 2000 Button: Drawing   Drawing button

Drawing toolbar The Drawing button opens a bar of drawing tools. This bar can be docked at any edge of the window, just like the other tool bars. Or it can float as a palette.

You use these tools to create graphics while still in an MS Office application. The tools create vector drawings, which use shapes instead of individual dots.

These lessons don't use the Drawing bar much. Frowning smiley There is only so much one can do in one course! (Ask the Office Assistant or use Help to learn more, if you are interested.)

Icon: Excel 97Icon: Excel 2000Control: Zoom Zoom control

Zoom control- list expandedThe Zoom control shows at what size the sheet is currently displayed. Clicking the arrow at the right of the control opens the list of your choices. Excel's Zoom has a shorter list of choices than in Word does. 

Excel does not include a "Whole Page" choice, but adds the choice "Selection".

Icon: Excel 97Icon: Excel 2000 Button: HelpHelp button

The Help button opens up either a Help window or the Office Assistant dialog.

Excel Help

 Help from Office Assistant

The Office Assistant can use any of a number of "actors" to make its advice more fun.

Collage of Office Assistant actors


To turn off Office Assistant you must first open the Assistant and then click on the Options button in the popup yellow dialog. The Office Assistant dialog appears. On the Options tab, uncheck the box for Use Office Assistant.

Dialog- Office Assistant | Options tab

Icon: Excel 97Icon: Excel 2000 Button: Arrow Arrows showing more buttons are out of sight arrow for toolbar menu

If you see Arrows showing more buttons are out of sight a double arrow at the end of a toolbar in a Microsoft Office application, there are more buttons assigned to the toolbar than can be shown. You can click the arrows to open a menu that lists the other buttons.

The down arrow arrow for toolbar menu is always at the end of the toolbar. It opens a menu with a Add/Remove command for modifying what buttons are show on the toolbar.

Close this window

Teachers: Request permission to use this site with your class

Copyright 1997-2012 Jan Smith   <>
All Rights Reserved

Icon: DonwloadIcon: CDWant a local copy with no ads? - Download/CD
Want to help?

~~  1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~