Excel 2007's Redo feature provides a quick way to re-apply changes to your spreadsheet that were removed with the Undo feature.
Related article: Excel 2007's Undo Feature.
Unlike previous versions of Excel, in Excel 2007 the Redo list is not emptied every time you save a spreadsheet file. This means you have a greater opportunity to correct mistakes.
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:
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
- 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 2007 Tips
