Show All

Hide All

You can undo and redo up to 100 actions in Microsoft Office programs, such as Microsoft Office Word 2007, Microsoft Office PowerPoint 2007, Microsoft Office Excel 2007, and Microsoft Office Access 2007. 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

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

  All of the selected actions are reversed.

• 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 Office Button command or saving a file. If you can't undo an action, the Undo command changes to Can't Undo.
• 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  You can also press CTRL+Y.

 Top of Page

Repeat the last action

• Excel

• PowerPoint

• Word

Excel

The Repeat command is not available on the Quick Access Toolbar by default. 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.
2. Repeat the last action by clicking 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.

 Top of Page

PowerPoint

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

  Keyboard shortcut  You can also press CTRL+Y.

 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  You can also press CTRL+Y.

 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 insert a pre-defined equation, create a new equation, modify an equation, and save the equation for later use.

Watch this

 Top of Page