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.