1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Shortcut Keys - Undo

Undoing Changes or Mistakes in Excel

By

Undoing Changes or Mistakes using Shortcut Keys

Undoing Changes or Mistakes using Shortcut Keys

© Ted French

This Excel shortcut key tutorial shows you how to "undo" changes made to an Excel worksheet.

Related tutorial: Excel 's Undo Feature.

Note: It's important to remember that when you use Undo, it "undoes" your actions in the exact reverse order that you applied them.

The shortcut key combination used to "undo" changes is:

  • Ctrl + " Z "

Example of How to Undo Changes using Shortcut Keys

  1. Type some data into a cell, such as A1 in the spreadsheet and press the Enter key on the keyboard.

  2. Click on that cell to make it the active cell.

  3. Click on Home tab of the ribbon.

  4. Apply the following formatting options to your data:
    • change the font color,
    • widen the column,
    • underline,
    • change the font type to Arial Black,
    • center align the data

  5. Press and hold down the Ctrl key on the keyboard.

  6. Press and release the letter " Z " on the keyboard.

  7. The data in the cell should change back to left alignment as the last change (center alignment) is undone.

  8. Press and hold down the Ctrl key on the keyboard again.

  9. Press and release the letter " Z " on the keyboard twice without releasing the Ctrl key.

  10. Not only will the underline be removed but the font will no longer be Arial Black.

  11. This happens because, as mentioned above, the undo feature "undoes" your actions in the exact reverse order that you applied them.

Other Excel Shortcut Keys Tutorials

©2014 About.com. All rights reserved.