While working on Excel worksheet, you may need to redo the last action, for instance inserting blank rows multiple times in a worksheet. Here in this article, we will show you how to redo the last action or perform the same action repeatedly in Excel.
How to Redo the Last Action in Excel
How to Perform Redo Last Action in Excel
There are two ways to redo the last action in Excel, either by shortcut keys or by adding the Repeat Command button into the Quick Access Toolbar.
Press the F4 key or the Ctrl + Y keys if you want to insert blank rows multiple times in your worksheet. However for Mac operating systems press ⌘+Y to repeat your last action.
In this example, if you want some of the headings of my data table to be Bold. After using this action, I pressed F4 or Ctrl+Y and Redo icon to apply these changes to other cells.
Figure 1. Example of Redo Last Action
Following are the steps to add Repeat Command button into the Quick Access Toolbar for easily repeating your previous action.
- Click the Customize Quick Access Toolbar button on the ribbon, and from the drop-down list click More Commands. See screenshot
Figure 2. Step 1 Adding Redo Last Action Button into Quick Access Toolbar
- In the Excel Options dialog box of Popular Commands, choose Repeat option. Then click the Add button and press the OK button. See screenshot:
Figure 3. Step 2 Adding Redo Last Action Button into Quick Access Toolbar
- Now the Quick Access Toolbar shows the Repeat command button in the ribbon. You can now redo the last action by just clicking on it.
Figure 4. Step 3 Adding Redo Last Action Button into Quick Access Toolbar
Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Your first session is always free.