Page 18 of 23PREVNEXT

Get to know Excel 2007: Create your first workbook

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

Callout 1 Double-click a cell to edit the data in it.
Callout 2 Or, after clicking in the cell, edit the data in the formula bar.
Callout 3 The worksheet displays 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. There are two ways to do it:

  • Double-click the cell. Then edit it.
  • Click in the cell, and then click in 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.

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 18 of 23PREVNEXT