Buy Now
excel-repeat-last-action

Excel Repeat Last Action: What is it and How Does it Work?

Jul 27, 2022

How often do you find yourself in a situation where you are required to do a series of tasks repeatedly within a Microsoft Excel worksheet.

Perhaps you need to insert a blank column or row, add a border to your work, or fill multiple cells. Whatever it may be, repeating the same task over and over can be extremely time-consuming.

In this article, I will take you through how to do this much quicker using an Excel shortcut.

Without further ado, let's jump straight in.

 What is the "Repeat Last Action" Shortcut in Excel?

The repeat last action shortcut is one of the best Excel shortcuts you have at your disposal. This action will repeat the last action In Excel. For example, if you implemented a border and yellow fill to a cell, you can implement this shortcut to execute the same format to one or more selected cells.

The Keyboard Shortcut for Repeat the Last Action

If you are keen to repeat your last action in Excel, such as inserting a row, formatting cells, or copying and pasting, you can use the keyboard shortcut F4.

Here is a step-by-step guide on how to insert blank rows multiple times with the F4 keyboard shortcut.

1) Choose the row above the one to which you want to add a blank row to.

2) Right-click and choose Insert

3) To quickly repeat this action, hit the F4 button, and the previous action will occur once more. 

Using the Repeat Command

Another simple option you have to complete the same operation in Excel is to add the repeat command to your Quick Access Toolbar. Then, to repeat the last action, all you have to do is click repeat from the toolbar!

Here's how to add the repeat command to your Quick Access Toolbar:

1) Choose the small arrow from the top of your Excel ribbon to get into the Quick Access Toolbar.

2) Choose the More Commands option from the list.

3) From the Excel Options dialog box, choose the Repeat command button under Popular Commands.

4) Select Add, and you will see Repeat has gotten added to the right.

5) Select OK

If you decide you no longer want to have the Repeat command button in your Quick Access Toolbar, you can remove it by following these steps:

1) Choose the small arrow from your ribbon to get onto the Quick Access Toolbar.

2) Choose More Commands.

3) From the Customize Quick Access Toolbar section, choose Repeat.

4) Select Remove and then hit OK.

5) You will now see the Repeat Command is now not part of the Quick Access Toolbar drop-down list.

Microsoft Excel Repeat the Last Action: Summary and Key Takeaways

There you have it! Now you can use the repeat last action shortcut in Excel. If you find yourself using it often, you can add the shortcut to your Quick Access Toolbar.

Be sure to check out the other how-to guides on our blog, and continue to improve your Excel and Google Sheets skillset!

Frequently Asked Questions About How to Repeat the Last Action in Excel

Is there a repeat command button on Mac?

To repeat the last action in Excel on a Mac, use Command+Y.

Are shortcut keys useful in Excel?

Excel shortcuts are extremely useful, as they allow you to save time by simply clicking the shortcut button, rather than having to find the action within Microsoft Excel.

What is the Excel shortcut key for repeat action?

Excel has many shortcut keys that allow users to execute actions in the program quickly. The F4 button will repeat the last action in Excel.

Related Articles

How to Delete Sheets in Excel: Deleting Multiple Sheets at Once

Microsoft Excel Certification: How to Become a Professional

Free Microsoft Excel Tutorial For Beginners

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras sed sapien quam. Sed dapibus est id enim facilisis, at posuere turpis adipiscing. Quisque sit amet dui dui.

Call To Action

Stay connected with news and updates!

Join our mailing list to receive the latest news and updates from our team.
Don't worry, your information will not be shared.

We hate SPAM. We will never sell your information, for any reason.