Chat with us, powered by LiveChat

Undo in Excel

How to Use Undo, Redo, Repeat Commands in Excel

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.

Undo

Before you perform the undo, redo, or repeat commands, you need to make some changes to your workbook.

  1. Make some changes to your workbook.
  2. Click the Undo button on the Quick Access Toolbar.
    Undo

    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.

Undo Multiple Actions

Excel can also undo the other previous changes you make—up to 100 actions.

  1. 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.

  2. Click the last action you want to undo.
    Undo Multiple Actions

The selected action and all subsequent actions are undone.

Redo

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.

  1. Click the Redo button on the Quick Access Toolbar.
    Redo

    Press Ctrl + Y.

The last action you undid is redone.

You can also click the Redo button list arrow to redo multiple actions.

Repeat

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.

  1. Perform an action.
  2. Select a cell or cell range where you want to repeat the action.
    Repeat
  3. Press the F4 key.

The command is repeated.

You can add the Repeat command to the Quick Access Toolbar for quick access.

FREE Quick Reference

Click to Download