Page 17 of 22PREVNEXT

Audio course: Get to know Excel: Create your first workbook

Type either in the selected cell or in the formula bar; when you revise data, the status of the worksheet changes to Edit

Callout 1 Double-click a cell to edit the data in it.
Callout 2 Or click the cell, and then edit the data in the formula bar.
Callout 3 The worksheet now says Edit in the status bar.

Say that you meant to enter Peacock's name in cell A2, but you entered Buchanan's name by mistake. Now you spot the error and want to correct it. You need to select the cell, and there are two ways:

  • Double-click it.
  • Click the cell, then click the formula bar.

What's the difference? Your convenience. You may find the formula bar, or the cell itself, easier to work with. If you are editing data in many cells, you can keep your pointer at the formula bar while you move from cell to cell by using the keyboard.

After you select the cell, the worksheet says Edit in the lower-left corner, on the status bar. If you don't see the status bar, click Status Bar on the View menu.

While the worksheet is in Edit mode, many commands are temporarily unavailable (these commands are gray on the menus). You'll see more about this in the practice at the end of the lesson.

What can you do? Well, you can delete letters or numbers by pressing BACKSPACE, or by selecting them and then pressing DELETE.

You can edit letters or numbers by selecting them and then typing something different.

You can insert new letters or numbers into the cell's data, by positioning the insertion point and typing.

Whatever you do, when you're all through, remember to press ENTER or TAB so that your changes stay in the cell.

Page 17 of 22PREVNEXT