Show All

Hide All

You can undo and redo up to 16 actions in Microsoft Excel. You can repeat actions as many times as you want.

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 Edit menu.
• Press CTRL+Z.
• Click Undo on the Standard toolbar (toolbar: A bar with buttons and options that you can use to carry out commands. To display a toolbar, point to Toolbars on the View menu. If you don't see the button you want, click the arrows at the right end of the toolbar.).
• 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 the selected actions.

• To cancel an entry in a cell or the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) before you press ENTER, press ESC.

Notes

• Some actions can't be undone, such as clicking any command on the File menu. If you can't undo an action, the Undo command changes to Can't Undo.
• Macros can clear all items from the undo list.

<Back to top>

Redo actions that you undid

To redo an action that you undid, do one of the following:

• Click Redo on the Edit menu.
• Press CTRL+Y.
• Click Redo on the Standard toolbar.
• To redo several actions at once, click the arrow next to Redo , select the actions in the list that you want to redo, and then click the list.

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

<Back to top>

Repeat the last action

• To repeat the last action, click Repeat on the Edit menu, or 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.

<Back to top>