That said, most intermediate to advanced users use at least one or two of these, such as Ctrl C to copy, Ctrl V to paste, Ctrl Z to undo, F2 to edit a formula or what I use frequently, F4 to repeat an action.

It is said that the F4 key is the most used keyboard shortcut in Excel.

There are various ways to use it, they save keystrokes and mouse movement.

While it is incredibly useful it is important to note that the F4 key does not repeat every action possible, and that there are also reported problems with the hotkey.

The best way to know what it will and will not do is to try it as you work on your workbook.

But before you do, read what is below, look at the links that take you to some of the best resources on the web when it comes to Microsoft Excel.

The way I do it is to activate the cell where I want to insert rows.

For each additional row I then hit F4 key and it will repeat the action.

Notice what happens to the formula each time you it the F4 key.

Why show this to you Because if you want to take the formula from one cell and place it in other cells, and still have it display the correct result, you will need to understand this, like it or not.

However, in Excel 20102013 it does not seem to work anymore for charts.

To learn more about the problems, See what Jon Peltier Microsoft Excel MVP has to say about it.

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.

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.

If you have just added cell borders to a range and you format another range the same way, F4 will repeat the previous action for you.

You must pay it a couple of s if you want to change the reference style from relative (A2) to absolute (A2).

But whos got the time to carefully navigate between A and 2 and then type SHIFT4 So I use F4 key and Excel changes the referencing style for me.

Enter your email address:nbsp nbspnbspnbspnbspnbspnbspnbspnbspnbspnbsp.

F4 For Mac Excel