Microsoft Office Tutorials and References
In Depth Information
insertion point in the active cell (Figure 1–94). With Excel in Edit mode, you
can edit the contents directly in the cell — a procedure called in-cell editing .
An alternative to double-
clicking the cell to edit it
is to select the cell and
then press the F2 key.
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 on the Home tab on the Ribbon.
(3) When you are ﬁ nished editing an entry, click the Enter box or press the
contents of cell
B3 appear in
displayed in cell after
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 charac-
ters to overtyping characters. Table 1–5 summarizes the more common tasks used during
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