Tell me about the issue and I’ll help you find the solution you need.
F4 keyboard shortcut does not work as expected in Excel 2013, Excel 2010, and Excel 2007
Content provided by Microsoft
Applies to: Microsoft Office Excel 2007Microsoft Office Excel 2007 (Home and Student version)Microsoft Excel 2010Microsoft Excel Home and Student 2010Excel 2013More
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.
This is a known issue in Excel 2013, Excel 2010, and Excel 2007.
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.
F4 is a predefined keyboard shortcut in Excel that repeats your last command or action. However, the shortcut does not always work.