Datasheet

Undoing, Redoing, and Repeating
This tip describes three procedures that every Excel user needs to understand. These pro-
cedures help you recover from mistakes and improve your editing efficiency.
Undoing
Just about every command in Excel can be reversed by using the Undo command. In Excel
2007, the Undo command is located on the Quick Access Toolbar (QAT), which is normally
displayed on the left side of the Excel title bar. You can also press Ctrl+Z to undo your
actions.
Choose Undo after issuing a command in error and it’s as though you never issued the com-
mand. You can reverse the effects of the last 100 commands that you executed by selecting
Undo multiple times.
Some actions, however, can’t be reversed. Anything that you do by using the Office
button — for example, saving a workbook — is not undoable.
NEW
Undoing 100 actions is new to Excel 2007. In previous versions, the Undo list was limited
to 16 actions.
If you click the arrow on the right side of the Undo button, you see a description of the
recent commands that can be reversed (see Figure 5-1).
Figure 5-1: The Undo button displays a list of recent actions that can be undone.
Tip 5: Undoing, Redoing, and Repeating
21
Part I
04_137666 ch01.qxp 5/22/07 7:31 PM Page 21