How to undo and redo changes in Excel

Excel has a powerful system for tracking changes so that they can be reversed when needed.

It’s called undo and redo.

Let’s take a look.

If you tap the Undo button again, you’ll step back one more step.

Each time you click Redo, Excel brings back another change.

Both Undo and Redo have keyboard shortcuts that are worth remembering.

Control Z for Undo and Control Y for Redo.

Using these shortcuts, we can Undo and Redo the same changes again.

Excel also labels each change with a simple description.

Let’s make some more changes to see how this works.

As before, we can step backwards and forwards through the changes.

For example, we can easily undo the last 10 actions.

Then, we can Redo the last 10 actions.

Note that Excel’s history of changes is not cleared when you save a workbook.

Tracked changes are only cleared when you close a workbook.