Microsoft Office Tutorials and References
In Depth Information
Correcting Errors After Entering Data into a Cell
If you i 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 click the
Enter box or press the enter 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 the Edit mode as described below.
a. 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 l ashing
insertion point in the active cell (Figure 1– 74). With Excel in Edit mode, you
can edit the contents directly in the cell — a procedure called in-cell editing .
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 at the location 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 delete key or place the
insertion point to the right of the character you want to delete and then
press the backspace key. You also can use the mouse to drag through
the character or adjacent characters you want to delete and then press
the delete key or click the Cut button (Home tab | Clipboard group).
(3) When you are i nished editing an entry, click the Enter box or press
the enter key.
For a table that lists how
to complete the tasks
covered in this topic
using the mouse, Ribbon,
shortcut menu, and
keyboard, see the Quick
Reference Summary at
the back of this topic, or
visit the Excel 2010 Quick
Reference Web page
An alternative to double-
clicking the cell to edit it is
to select the cell and then
press the F2 key.
contents of cell B3
appear in formula bar
insertion point displayed
in cell after double-clicking
Figure 1– 74
When Excel enters the 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 insert key. In Overtype mode , Excel overtypes, or replaces, the character
to the right of the insertion point. The insert 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.
Editing the Contents
of a Cell
Rather than using in-cell
editing, you can select
the cell and then click the
formula bar to edit the