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.