Excel's Undo feature provides a quick way to reverse changes made to a worksheet such as accidentally deleting data, applying incorrect formats, or moving formulas.
Related tutorial: Excel 's Redo Feature.
Beginning with Excel 2007, and unlike previous versions of Excel, the Undo list is not emptied every time you save a spreadsheet file. This means you have a greater opportunity to correct mistakes.
It's important to remember, however, that when you use Undo, it "undoes" your actions in the exact reverse order that you applied them.
What this means is that you can't undo the third item in the list, for example, without "undoing" the first two items as well.
Example using Excel's Undo Feature:
For help with this example, see the image above.
- 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
- Click on the small down arrow to the right of the Undo icon on the Quick Access Toolbar to open the drop down list.
- Click on the Center Alignment option at the top of the Undo list.
- The data in the cell should change back to left alignment.
- Open the Undo drop down list again.
- Click on the Column Width option in the middle of the Undo list.
- Not only will the width of the column revert to its original width, but the underline will be removed and 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.
- When we tried to undo the third item in the list the first two items were undone as well.
Other Excel Tips