Undo, redo, or repeat an action

Show All

Hide All

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.

• Undo the last action or actions that you made
• Redo actions that you undid
• Repeat the last action
• View demo

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  Press CTRL+Z or F2. For the F2 function key to undo your last action, you might need to press the F-Lock key.

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

 Notes 

• Some actions can't be undone, such as clicking any Office Button 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 (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.
• 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 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.

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

Top of Page

Repeat the last action

• Excel
• PowerPoint
• Word

Excel

By default, the Repeat command 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 , 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 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.

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

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

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

View demo

The following video shows you how to use the Undo, Redo, and Repeat commands.

Watch this

Top of Page