Step 2: You will get a dialog box of popular Commands, select Repeat Option. Step 1: Click the Customize Quick Access Toolbar button in the ribbon, then click more commands from the dropdown list. This is another easy way to redo last action in excel. Method 2: Repeat Command button into the Quick Access Toolbar After adding a row the normal way, we press F4 multiple times until we get the number of blank rows we desire.
In our example below, we want to add blank rows below the name Dennis. Redo the Last Action in Excel through shortcut keys Example 1: If you are working on a Mac operating system, however, you will need to press # +Y to repeat the last action.įigure 1. All you need to do it press the F4 key or Ctrl +Y keys, and this will add blank rows multiple times in the worksheet you are working on. It is easy to redo the last action by using the shortcut keys. The second option is to add the Repeat Command button into the Quick Access Toolbar. The first method is through the use of shortcut keys. There are two ways in which one can redo the last action in Excel. This post will show you how to perform the last action repeatedly while working on an excel worksheet. An example is when you want to insert a blank row or column multiple times. When working in Excel, we often want to repeat the last action when working on an project. Learn How to Redo the Last Action in Excel
