F4: A little Known Microsoft Excel Masterkey
The F4 key is a little known and yet extremely powerful shortcut key that works in all Microsoft applications such as Word, Excel and PowerPoint. In any Microsoft program, F4 can be used to repeat the last action.