You’re going to make mistakes at some point when you’re using Excel. When this happens, you can use Excel’s handy undo command to instantly undo your last action. The related redo and repeat commands are also useful and powerful.
Before you perform the undo, redo, or repeat commands, you need to make some changes to your workbook.
- Make some changes to your workbook.
- Click the Undo button on the Quick Access toolbar.
Press Ctrl + Z.
Your last action is undone. For example, if you had deleted an item and then decided you wanted to keep it after all, undo would make it reappear.
Excel can also undo the other previous changes you make—up to 100 actions.
- Click the Undo list arrow.
A list of the last actions in Excel appear. To undo multiple actions, point to the command you want to undo. For example, to undo the last three actions, point at the third action in the list. Each action done before the one you select is also undone.
- Click the last action you want to undo.
The selected action and all subsequent actions are undone.
Redo is the opposite of undo: it redoes an action you have undone. For example, if you decide that you do, after all, want to delete an item that you have just brought back with undo, you can redo the delete action.
- Click the Redo button on the Quick Access toolbar.
Press Ctrl + Y.
The last action you undid is redone.
You can also click the Redo button list arrow to redo multiple actions.
Repeat is different from redo, because repeat applies the last command to any selected text. For example, rather than applying bold formatting by clicking the Bold button repeatedly, you can repeat the bold command with the keystroke shortcut or Repeat button.
- Perform an action.
- Select a cell or cell range where you want to repeat the action.
- Press the F4 key.
The command is repeated.
You can add the Repeat command to the Quick Access Toolbar for quick access.