How to undo the last action in excel

The method to undo the last action in Excel uses the Undo command, and Excel reverses your most recent change.

Windows

1. Press Ctrl + Z.

2. Select the Undo button in the Quick Access Toolbar.

3. Open the Undo drop-down arrow to reverse multiple actions.

Mac

1. Press Command + Z.

2. Select the Undo button on the toolbar.

3. Open the Undo drop-down to revert multiple actions.

How to Add the Undo Button to the Quick Access Toolbar

1. Open Excel.

2. Select the Customize Quick Access Toolbar icon.

3. Select More Commands.

4. Choose Undo from the command list.

5. Select Add, then select OK.

How Excel Stores Undo History

Excel keeps a stack of recent actions.
Excel records typing, formatting changes, and structural changes.
Excel removes undo history when you save the workbook or run macros.

Common Actions You Can Undo

1. Data entry.

2. Cell formatting.

3. Row or column insertion.

4. Row or column deletion.

5. Formula entry.

6. Cut, copy, and paste actions.

7. Chart edits.

Actions You Cannot Undo

1. Saving a workbook.

2. Running VBA macros.

3. Some external data refresh operations.

4. Some add-in-based operations.