Both ‘Redo’ and ‘Repeat an Action’ have the same shortcut — ‘F4’ or ‘Ctrl + Y’ (‘⌘ + Y’ for Mac). However, they have entirely different functions. Here’s a quick differentiation between the. In this video, you’ll learn how to use absolute references with the F4 key in Excel. Visit https://www.gcflearnfree.org/excel-tips/absolute-references-with-t.
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Symptoms
F4 For Excel Machining
The F4 keyboard shortcut does not work as expected in Microsoft Excel 2013, Excel 2010, or Excel 2007.
For example, when you sort a row (row A), and then you press F4 to repeat the action on another row (row B), row B is not sorted. Or, when you copy and paste a cell, and then you press F4, the cell is pasted. However, when you press F4 again, the cell is not pasted.
![F4 for excel macro F4 for excel macro](/uploads/1/1/8/2/118299319/950339215.png)
F4 For Excel On Mac
Cause
This is a known issue in Excel 2013, Excel 2010, and Excel 2007.
Workaround
If you cannot use the F4 keyboard shortcut to repeat a command or action, manually perform the command or action that you want to repeat.
More Information
F4 Key Excel Mac
F4 is a predefined keyboard shortcut in Excel that repeats your last command or action. However, the shortcut does not always work.