This Excel tip shows you how to "undo" changes made to an Excel spreadsheet using a keyboard shortcut.
Note: It's important to remember that when you use Undo, it "undoes" your actions in the exact reverse order that you applied them.
Related article: Excel 2007's Undo Feature.
The key combination used to "undo" changes:
- Ctrl + " Z "
Example of How to Undo Changes using a Keyboard Shortcut
Note: For help with this example, see the image to the right.
- 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,
- underline,
- 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 Keyboard Shortcuts
