Datasheet
16
2
3
1
2 Perform another action.
In this example, italics are
added.
Note: See Chapter 3 for more
on using italics.
3 Click the Undo button
(
).
1 Perform an action.
In this example, text is
typed.
Undo and Redo
Y
ou can use the Undo feature in Excel to
recover from editing mistakes that might
otherwise force you to re-enter data. The
Undo feature in Excel is cumulative, meaning that
Excel keeps track of all the actions you take until you
close the program. When you use the Undo feature,
Excel begins by reversing the effects of the last action
you took. If you undo four times, Excel reverses the
effects of the last four actions you took in the order
you took them. For example, suppose you edit a text
label and remove some characters. If you undo the
action, Excel reinserts those characters.
The Redo feature works like the Undo feature — but in
reverse. After you undo an action, you can redo it. If
you undo several actions in a row, you can redo all of
them in the order you undid them. For example, if
you undo typing and then the effects of resizing a
column, when you use the Redo feature, Excel first
restores the effects of resizing the column. If you
immediately use the Redo feature again, Excel restores
the typing.
Undo
and Redo
04_577691-ch01.indd 1604_577691-ch01.indd 16 6/3/10 10:45 AM6/3/10 10:45 AM