Undo, redo, or repeat an action

You can undo and redo up to 100 actions in Microsoft Office Excel, even after a worksheet is saved. You can repeat actions as many times as you want.What do you want to do?

Undo the last action or actions that you made

Redo actions that you undid

Repeat the last action

Undo the last action or actions that you made

To undo an action, do one or more of the following:

• Click Undo on the Quick Access toolbar.

  

  Keyboard shortcut You can also press CTRL+Z.

• To undo several actions at once, click the arrow next to Undo , select the actions in the list that you want to undo, and then click the list.

  Excel reverses all of the selected actions.

• To cancel an entry in a cell or the formula bar before you press ENTER, press ESC.

Notes:

• Some actions can't be undone, such as clicking any Microsoft Office Button command, or saving a workbook. If you can't undo an action, the Undo command changes to Can't Undo.
• Macros can clear all items from the undo list.

Redo actions that you undid

• To redo an action that you undid, click Redo on the Quick Access toolbar.

  

  Keyboard shortcut You can also press CTRL+Y.

Note When you redo all of the actions that were undone, the Redo command changes to Repeat .

Repeat the last action

• To repeat the last action, click Repeat on the Quick Access toolbar.

  

  Keyboard shortcut You can also press CTRL+Y.

Note Some actions, such as using a function in a cell, cannot be repeated. If you can't repeat the last action, the Repeat command changes to Can't Repeat.