Microsoft Office Tutorials and References
In Depth Information
Correcting Errors while Entering Data into a Cell
If you notice an error while you are entering data into a cell, press the
key to erase the incorrect character(s) and then enter the correct character(s). If the
error is a major one, tap or click the Cancel box in the formula bar or press the key
to erase the entire entry and then reenter the data from the beginning.
Correcting Errors after Entering Data into a Cell
If you nd an error in the worksheet after entering the data, you can correct the
error in one of two ways:
1. If the entry is short, select the cell, retype the entry correctly, and then tap or click
the Enter box or press the key. The new entry will replace the old entry.
2. If the entry in the cell is long and the errors are minor, using Edit mode may
be a better choice than retyping the cell entry. Use Edit mode as described below.
a. Double-tap or double-click the cell containing the error to switch Excel to
Edit mode. In Edit mode , Excel displays the active cell entry in the formula
bar and a ashing insertion point in the active cell. With Excel in Edit mode,
you can edit the contents directly in the cell — a procedure called in-cell
editing (Figure 1– 71).
Figure 1– 71
b. Make changes using in-cell editing, as indicated below.
(1) To insert new characters between two characters, place the insertion
point between the two characters and begin typing. Excel inserts the
new characters to the left of the insertion point.
(2) To delete a character in the cell, move the insertion point to the left of the
character you want to delete and then press the key, or place
the insertion point to the right of the character you want to delete and
then press the key. You also can drag to select the character or
adjacent characters you want to delete and then press the key or
+ , or tap or click the Cut button (HOME tab | Clipboard group).
(3) When you are nished editing an entry, tap or click the Enter box or
press the key.
When Excel enters Edit mode, the keyboard usually is in Insert mode. In Insert
mode , as you type a character, Excel inserts the character and moves all characters to
the right of the typed character one position to the right. You can change to Overtype
mode by pressing the key. In Overtype mode , Excel overtypes, or replaces,
the character to the right of the insertion point. The key toggles the keyboard
between Insert mode and Overtype mode.
While in Edit mode, you may have reason to move the insertion point to various
points in the cell, select portions of the data in the cell, or switch from inserting
characters to overtyping characters. Table 1– 5 summarizes the more common tasks
performed during in-cell editing.