DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2761244 - Last Review: November 1, 2012 - Revision: 1.0

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.

Applies to
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2007 (Home and Student version)
  • Microsoft Excel 2010
  • Microsoft Excel Home and Student 2010
  • Microsoft Excel 2013
Keywords: 
kbprb kbexpertisebeginner kbsurveynew KB2761244
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support