Related tutorial: Excel's Undo Feature.
Beginning with Excel 2007 the Redo list was changed by Microsoft so that it is not emptied every time you save a spreadsheet file. The list therefore contains more steps in the order they were performed and allows you a greater opportunity for correcting mistakes such as data deletions or format changes.
Note: It's important to remember that when you use Redo, it "redoes" your actions in the exact reverse order that you removed them.
What this means is that you can't add back in the third item in the list, for example, without adding in the first two items as well.
Example using Excel's Redo 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
- Use the Undo feature to undo the last four actions - up to widening the column.
- Click on the small down arrow to the right of the Redo icon on the Quick Access Toolbar to open the drop down list.
- Click on the Column Width option at the top of the Redo list.
- The column should be widened again.
- Open the Redo drop down list again.
- Click on the Center Alignment at the bottom of the Redo list.
- Not only will the data be centered in the cell again, but the underline will return and the font will change back to Arial Black.
- This happens because, as mentioned above, the Redo feature "redoes" your actions in the exact reverse order that you removed them with the Undo feature.
- When we "redid" the third item in the list the first two items were "redone" as well.
Other Excel Tips