Excel 2000

Introduction

By the end of this lesson, learners should be able to:

• Enter and Delete data
• Edit data
• Select multiple cells

Entering Data

You can enter three types of data in a worksheet: text, numbers, and formulas. Text is any entry that is not a number or formula. Numbers are values used when making calculations. Formulas are calculations.

To Enter Data into a Cell:

• Click the cell.
• Begin typing the data.
• An insertion point appears, and the text you are entering appears in the active cell and in the formula bar.

• The formula bar buttons (Cancel button and Enter button) appear.
• Clicking the Enter button ends the entry and turns off the formula bar buttons.

To Delete Data:

• Click the cell.

AND

• Click the Cancel button to delete an entry and turn off the formula buttons.

OR

• Cancel an entry by pressing the Escape key.

OR

• Right-click and choose Clear Contents from the shortcut menu.

OR

• Select data and press Delete or Enter key.

Excel’s AutoComplete feature keeps track of text entered in a column and can complete other entries in the same column. For example, if you typed GCFLearnFree.org in cell A1 and enter "G" in A2, Excel automatically fills the cell with GCFLearnFree.org. If GCF Global Learning is the text you want to enter, press Enter or Tab to move to the next cell. If it’s not what you want, just keep typing until you overwrite the AutoComplete feature.

Editing Data

You may find you need to edit or change data you enter into a cell. You can do this two ways.

Quick and Easy Method:

• Click the cell and type the new entry; the old entry is replaced.

If the original entry is long and only requires a minor adjustment (in spelling, for example), edit the entry.

To Edit:

• Click on the cell and edit the entry in the formula bar.

OR

• Double-click on the cell. This opens the cell for direct editing.
• Press Enter or click the Enter button on the Formula bar to complete the entry.

Selecting Multiple Cells

In Excel, the cell that is currently selected is the active cell. A group of cells is called a range.

To Select a Range of Cells:

• Move to the first cell in the range.
• The mouse pointer becomes a large cross.
• Hold down the left mouse button and drag to the last cell you want to select.
• Release the mouse button.
• The cells you selected are shaded.

To Select All Cells in a Column or Row:

• Click the Column or Row heading.

To Select Multiple Columns or Rows:

• Click one heading and drag to select the others.

To Select the Entire Worksheet:

• Click the gray rectangle in the upper left corner to select entire worksheet .

If the cells and columns you want to select are not directly next to one another, select one of the ranges you want to select, and hold down the Control key while selecting other ranges. For example, you may want to select column A and column C, but not column B.

Challenge!

Practice selecting a range of cells using one of the methods taught in this lesson:

• Click on a cell and drag to select a number of cells.
• Click a column or row heading.
• To Select Entire Worksheet, click the gray rectangle in the upper left corner.