You are currently offline, waiting for your internet to reconnect

F4 keyboard shortcut does not work as expected in Excel 2013, Excel 2010, and Excel 2007

Symptoms
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.
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 is a predefined keyboard shortcut in Excel that repeats your last command or action. However, the shortcut does not always work.
Properties

Article ID: 2761244 - Last Review: 11/01/2012 09:20:00 - Revision: 1.0

Microsoft Office Excel 2007, Microsoft Office Excel 2007 (Home and Student version), Microsoft Excel 2010, Microsoft Excel Home and Student 2010, Microsoft Excel 2013

  • kbprb kbexpertisebeginner kbsurveynew KB2761244
Feedback
om/c.gif?DI=4050&did=1&t=">