Undoing and Redoing an Action

You may realize you've made a mistake shortly after completing an action or a task. The Undo feature lets you "take back" one or more previous actions, including data you entered, edits you made, or commands you selected. For example, if you were to enter a number in a cell, and then decide the number was incorrect, you could undo the entry instead of selecting the data and deleting it. A few moments later, if you decide the number you deleted was correct after all, you could use the Redo feature to restore it to the cell .

Undo an Action

Click the Undo button on the Standard toolbar to undo the last action you completed.

Click the Undo button list arrow to see recent actions that can be undone.

Click an action. Excel reverses the selected action and all actions above it.

Redo an Action

Click the Redo button on the Standard toolbar to restore your last undone action.

Click the Redo button list arrow to see actions that can be restored.

Click the action you want to restore. All actions above it will be restored as well.

Did You Know?

You can display the Redo button . Click the Toolbar Options list arrow, and then click Redo. Once a button is used, it remains on the toolbar.