Datasheet

Undo and Redo

Undo

and Redo

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 of 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 that 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 then

immediately use the Redo feature again, Excel restores

the typing.

1 Perform an action.

In this example, text is typed.

2 Perform another action.

In this example, italics are added.

Note: See Chapter 3 for details on adding italics.

3 Click the Undo button ( ).

05_181706 ch01.qxp 1/31/08 9:44 PM Page 14