Undo, redo, or repeat an action

You can undo and redo up to 100 actions in the following 2007 Microsoft Office system programs: Word, PowerPoint, and Excel. For information about the Undo and Redo features in Access, see Undo or redo typing or design changes.

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 Button image on the Quick Access Toolbar.

    Keyboard shortcut  Press CTRL+Z or F2. For the F2 function key to undo your last action, you might need to press the F-Lock key.

    Quick Access Toolbar

    For more information about the Quick Access Toolbar, see Customize the Quick Access Toolbar.

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

    All of the actions that you selected are undone or reversed.

Note: 

  • Some actions can't be undone, such as clicking any Office Button Office button image command or saving a file. If you can't undo an action, the Undo command changes to Can't Undo.

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

  • In Excel, macros can clear all items from the undo list.

Top of Page

Redo actions that you undid

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

    Keyboard shortcut  Press CTRL+Y or F3. For the F3 function key to redo your last action, you might need to press the F-Lock key.

    Quick Access Toolbar

    For more information about the Quick Access Toolbar, see Customize the Quick Access Toolbar.

Top of Page

Repeat the last action

Which 2007 Microsoft Office system program are you using?

Excel

Excel

By default, the Repeat command Button image is not available on the Quick Access Toolbar. If you want to repeat the last action, you need to add the Repeat command to the Quick Access Toolbar first.

  1. Add the Repeat command to the Quick Access Toolbar by doing the following:

    1. Click Office Button Office button image , and then click Excel Options.

    2. Click Customize.

    3. Under Choose commands from, click Popular Commands.

    4. In the list of commands, click Repeat, and then click Add.

    5. Click OK.

      For more information about the Quick Access Toolbar, see Customize the Quick Access Toolbar.

  2. Repeat the last action by clicking Repeat Button image on the Quick Access Toolbar.

    Keyboard shortcut  Press CTRL+Y or F4. For the F4 function key to repeat your last action, you might need to press the F-Lock key.

    Quick Access Toolbar

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

Top of Page

PowerPoint

  • To repeat the last action, click Repeat Button image on the Quick Access Toolbar.

    Keyboard shortcut  Press CTRL+Y or F4. For the F4 function key to repeat your last action, you might need to press the F-Lock key.

    Quick Access Toolbar

    For more information about the Quick Access Toolbar, see Customize the Quick Access Toolbar.

    Note: If you can't repeat the last action, the Repeat command changes to Can't Repeat.

Top of Page

Word

  • To repeat the last action, click Repeat Button image on the Quick Access Toolbar.

    Keyboard shortcut  Press CTRL+Y or F4. For the F4 function key to repeat your last action, you might need to press the F-Lock key.

    Quick Access Toolbar

    For more information about the Quick Access Toolbar, see Customize the Quick Access Toolbar.

    Note: If you can't repeat the last action, the Repeat command changes to Can't Repeat.

Top of Page

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×