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.