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
- Type some data into a cell, such as A1 in the spreadsheet and press the Enter key on the keyboard.
- Click on that cell to make it the active cell.
- Click on Home tab of the ribbon.
- Apply the following formatting options to your data:
- change the font color,
- widen the column,
- change the font type to Arial Black,
- center align the data
- Press and hold down the Ctrl key on the keyboard.
- Press and release the letter " Z " on the keyboard.
- The data in the cell should change back to left alignment as the last change (center alignment) is undone.
- Press and hold down the Ctrl key on the keyboard again.
- Press and release the letter " Z " on the keyboard twice without releasing the Ctrl key.
- Not only will the underline be removed but the font will no longer be Arial Black.
- 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