Button: New

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.
 

Button: Open

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.

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

  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.

You 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.

Button: Email

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

Button: Print 

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

Sometimes 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. 

Button: Print Preview

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.

Button: Spell Check

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

Buttons: 
Cut. Copy, & Paste

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.

When 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.

Button: Format Painter

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.

Format 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.

Buttons: Undo and Redo

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

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!

Button: Hyperlink

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.

Button: Paste Function 

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!!

In Excel 2002/2003 the Paste Function button is at the left of the Formula textbox.

Buttons: Sort 

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

Numerical
Before		After

Alphabetical
Before		After

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... 

 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
Before	After

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

Button: Chart Wizard 

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

Button: Drawing  

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. 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.)

Control: Zoom

The 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".

Button: Help

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

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

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.

Button: Arrow

If you see 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 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.

Want a local copy with no ads? - Download/CD
Want to help?