Microsoft Office Tutorials and References
In Depth Information
Redoing what you’ve undone
With the drop-down list visible, move your pointer down the list, and select the number of
actions you want to undo. When you click, your worksheet reverts to the condition it was in
before the selected actions.
Undo reverses the effect of most editing actions and restores any entry in the formula bar.
For example, if you accidentally delete a range of data, use Undo to replace the entries. If
you edit the contents of a cell and subsequently discover that your changes are incorrect,
use Undo to restore the original cell entry. In addition, you can use Undo to reverse
formatting and many other types of actions.
Unfortunately, Excel has many actions that Undo can’t reverse, such as saving workbooks
and deleting worksheets. Closing a workbook erases all the undoable actions displayed in
the Undo list. Predictably, actions you cannot undo do not appear in the Undo drop-down
list.
Redoing what you’ve undone
After you use Undo, you can then use Redo, which, unsurprisingly, reverses Undo. You can
press Ctrl+Y to redo the last action or click the Redo button on the Quick Access Toolbar,
which operates similarly to Undo. Redo also offers a drop-down list with all the undone
editing actions. When you redo an action, Excel transfers it to the Undo drop-down list.
Redo is valid only if Undo was your last action. After you have redone all the “undos” (up to
100), you’re back to the “true” last action—that is, the last action you performed before you
used Undo.
You can take advantage of Undo and Redo to see the effects of an editing change in your
worksheet. If you edit a cell that is referred to in several formulas, you can use Undo and
Redo to get a “before and after” look at the results displayed by the formulas.
Repeating your last action
To repeat the last editing action, press Ctrl+Y. (The Repeat button does not ordinarily
appear on the Quick Access Toolbar, but you can add it. See “Customizing the Quick Access
Toolbar” in Chapter 3, “Custom-tailoring the Excel workspace.”)
Redo and Repeat share the same keyboard shortcut because you can do only one or the
other at any given moment. Being able to repeat the last action is a great timesaver and is
particularly handy with repetitive chores.
Search JabSto ::




Custom Search