How to Use Redo in Microsoft Excel to Automate Tasks

If you use Microsoft Excel, chances are you have found the redo button in the top left corner of the screen. Redo is typically used when a user changes their mind after pressing undo. However, redo can automate routine tasks in Microsoft Excel.

Difficulty: Easy

Instructions

1. Perform a series of edits in a cell, such as formatting the cell, adding formulas, or making changes to the font.

2. When you have finished the edits in the first cell, click the cursor on the next cell where you would like to perform a series of the same edits.

3. With the cell for the next series of edits highlighted, push the redo button at the top, left corner of the screen. Alternatively, you can
   press the control and Y key on your keyboard at the same time. The redo option will repeat the customization and changes made to the previous cell. The redo button is most valuable when used to perform several operations in a single cell.

Tips & Warnings

• Redo will only perform the last step of edits made. When repeating edits to several cells, stopping and to delete or correct something else, will wipe out the repeated action you are trying to perform.

[anthonya]

on 11/6/2009 Great tip! Redo saves a lot of time and is a very useful function.