Microsoft Office Tutorials and References
In Depth Information
Undoing, Redoing, and Repeating
Undoing, Redoing, and Repeating
This tip describes three operations that help you recover from mistakes and improve your editing
You can reverse just about every command in Excel by using the Undo command, located on the
Quick Access toolbar. The Quick Access toolbar 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
command. You can reverse the effects of the last 100 commands that you executed by selecting
Undo multiple times.
You can’t reverse some actions, however. Anything that you do by using the File button — for
example, saving a workbook — is not undoable.
If you click the arrow on the right side of the Undo button, you see a description of the recent
commands that you can reverse (see Figure 6-1). You can highlight a series of these commands
to undo several actions with one click. In the figure, seven actions are highlighted, beginning with
the command that inserted a chart.
Figure 6-1: The Undo button displays a list of recent actions that can be undone.
Keep in mind that you can’t undo the effect of executing a macro. In fact, running a
macro that changes a worksheet wipes out all the Undo information. This serious
weakness in Excel isn’t present in Microsoft Word.
Search JabSto ::

Custom Search