Useful Excel keyboard shortcuts

Here is another guide in the same vein as my other post about useful keyboard shortcuts, but this time I present you with some useful Excel keyboard shortcuts!

It’s time to make it so your status as an Excel ninja is beyond question. (These shortcuts were tested on Excel 2007 but should work on all verions).

F2Edit the cell without double clicking it.
F4Automatically makes the cell reference absolute (When focused on formula bar).
Ctrl + Arrow keysMove position to the edges of contiguous cells.
Ctrl + RFill a formula right when you have cells selected.
Ctrl + DFill a formula down when you have cells selected.
Ctrl + HomePuts you directly in cell A1.
Ctrl + SpaceSelect the whole column.
Shift + SpaceSelect the whole row.
Crtl + –Delete a column/row that’s selected.
Ctrl + Shift + =Insert a column/row left/above the one you have selected.
Alt, E, SPaste special.
Crtl + Shift + Number keysFormats the cells to the alternate character on the key (i.e. 4 is $ format, 5 is % format)
Ctrl + PgUp/PgDnSwitch between different worksheets within the same file.
TabStart typing your formula and hit tab. It will autocomplete it and add the opening bracket.
Ctrl + 1Format cells.
Shift + F11Inserts a new worksheet
Alt + EnterInserts a line break in a cell instead of going to the cell below.