Microsoft Office Tutorials and References
In Depth Information
Undoing an Edit
Remember the formula bar—that strip in the upper reaches of your
screen that affords you a view of exactly what you entered in the cell.
Among other things, the formula bar gives you a place to very easily edit
a cell. Here you can click precisely at the place in the phrase you want
to change. and do some basic word processing. If you click to the left of
the a, press the Delete key once and the letter will disappear. If you click
to its right, press Backspace instead.
When you’ve finished your edits, press Enter or click the green check
mark, and the edit is completed. Simple!
You can also add text to the cell in much the same way:
Click in the formula bar at the appropriate point in the text and just type.
As with Word, the text will push the adjoining words aside.
Then press Enter or click the green check.
You can also edit data in a cell by deploying an ancient spreadsheet keystroke: the F2
key. Here, instead of clicking inside the formula bar, click the cell and press F2. The
cursor will be placed at the end of text, as shown in Figure 3–2.
Figure 3–2. Using the F2 key to get inside the cell
Once the cursor is in the cell, you can press the left arrow key to make your way back to
that surplus a. Once you’re there, just backspace or delete, and then press Enter, and
the deed is done.
Note as well that when you start to edit
cells, the mode indicator lurking in the
lower left of the status bar changes, as
shown in Figure 3–3.
Figure 3–3. The Edit mode indicator turns on when you
begin the cell-editing process.
Undoing an Edit
There’s yet another way to revise the
contents of your cells, though you might
not think of it as an editing command—it’s
the Undo button, stored in the Quick
Access toolbar (shown in Figure 3–4).
Figure 3–4. The Undo button