Excel 2010 For Dummies
Book image
Explore Book Buy On Amazon

The Undo feature in Excel 2010 can quickly correct mistakes that you make in a worksheet. The Redo button lets you "undo the Undo." The Undo button appears next to the Save button on the Quick Access toolbar, and it changes in response to whatever action you just took; the Redo button becomes active whenever you use Undo.

Undoing edits

When you want to reverse your last action in a worksheet, click the Undo button or press Ctrl+Z. For example, when you delete a cell selection, the Undo button's ScreenTip says Undo Clear (Ctrl+Z) when you point to the button; clicking that button puts that cell's contents back. If you move an entry to a new part of the worksheet by dragging it, the Undo button's ScreenTip changes to Undo Drag and Drop.

If you forget to strike when the iron is hot, so to speak — by using the Undo feature to restore the worksheet to its previous state before you choose another command — you then need to click the drop-down button that appears to the right of the Undo icon. After the Undo drop-down menu is open, click the action on this menu that you want undone. Excel will then undo this action and all actions that precede it in the list (which are automatically selected).

You can undo multiple actions at one time.
You can undo multiple actions at one time.

Undo doesn't work all the time. Although you can undo your latest erroneous cell deletion, bad move, or unwise copy, you can't undo your latest imprudent save. (You know, like when you meant to choose Save As from the File tab to save the edited worksheet under a different name but instead chose Save and ended up saving the changes as part of the current workbook.) The ScreenTip for the Undo button displays Can't Undo when you cannot reverse the previous action.

Using Redo

After using the Undo button on the Quick Access toolbar, Excel 2010 activates the Redo button to its immediate right. If you delete an entry from a cell and then click the Undo button or press Ctrl+Z, the ScreenTip that appears when you position the mouse pointer over the Redo button appears as Redo Clear (Ctrl+Y).

When you click the Redo button or press Ctrl+Y, Excel redoes the thing you just undid. Actually, this sounds more complicated than it is. It simply means that you use Undo and Redo to switch back and forth between the result of an action and the state of the worksheet just before that action until you decide how you want the worksheet.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is president of Mind Over Media, Inc. He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. He's also an experienced educator.

This article can be found in the category: