Repeat last action

The repeat last action shortcut in Excel will repeat the previous command when it is available. Read more about the trick through examples!

The repeat last action shortcut is:

  • F4 on Excel for Windows
  • ⌘ + Y on Excel for Mac

Windows

F4 or Ctrl Y

Mac

Y

If you prefer to use the mouse, click Repeat on the Quick Access Toolbar. In the next section, you will learn how to do that.

How to check the repeat last action availability?

As first, add the Repeat command to the Quick Access Toolbar. You can perform various tasks in Microsoft Excel. If you want to know whether the repeat last action command is available or not, check the icon status on the QAT.

The repeat icon is inactive in the picture below, so you can not repeat the last action. In this case, you can not apply the shortcuts mentioned above.

repeat last action is not available

To demonstrate the differences between active and inactive statuses, let us see another example. In this picture, Excel highlights the repeat icon so that you can redo the last used command in the active Workbook.

active

Tip: if the F4 shortcut doesn’t seem to work, you may need to press the Function-lock key or Fn Key, then press F4.

Additional resources:

Istvan Vozar

Istvan is the co-founder of Excelkid. He writes blog posts and helps people to reach the top in Excel.