EXCEL KEYBOARD SHORTCUTS

DATA SELECTION / NAVIGATION FORMATTING
Ctrl + Pg Up / Pg Down Move to Prior / Next Worksheet
Alt + E + S, then: Paste Special (copy first)
Shift / Ctrl + Spacebar Select Entire Row / Column F, T, V Formulas, Format, Value
Ctrl + * (Ctrl + Shift + 8) Select All Adjacent Cells E Transpose (Values only)
Ctrl + A Similar to Ctrl + *, Twice for All Cells S, D, M, I Add, Divide, Multiple, Divide
Shift + F8 Add to Selection
Ctrl + B / U / I Toggle Bold / Underline / Italic
Shift + Alt + => / <= Group / Ungroup Selection
Ctrl + 1 Format Cells
Ctrl + 0 / 9 Collapse (Hide Columns / Rows)
Ctrl + Shift + 7 Box Selection
Ctrl + Shift + 0 / 9 Expand (Unhide Columns / Rows) Ctrl + Shift + Underline No Border
Ctrl + Shift + F / P Format Font Face / Size
Ctrl + Arrow Keys Move by Blocks of Cells
Shift + Arrow Keys Select Cells Ctrl + (Shift) + Alt + Tab Increase / Decrease Indent
Ctrl + Home / End Move to Upper Left / Lower Right Alt + O, C, A AutoFit Column Width
Ctrl + . (within selection) Move Clockwise to next Corner Alt + O, H, R Change Worksheet Name
Ctrl + – / Ctrl + + Delete / Insert Selected Cells EDITING
Alt + ¯ Show Dropdown List Options F2 Toggle Edit / Navigation Mode
Alt + (Ctrl + Tab) Navigate Menu Items / Toolbar F4 (edit mode) Toggle Anchoring ($ in cell ref)
F4 (non-edit mode) Repeat Last Action (like Ctrl + Y)

DATA MANIPULATION
Ctrl + Enter Fill Selection with Formula / Text
Ctrl + C / Ctrl + Insert Copy Shift + F10 Show Context Menu (right click)
Ctrl + X / Shift + Delete Cut
Ctrl + V / Shift + Insert Paste Shift + F2 Insert Comment (Esc twice to exit)
Shift + F3 Display Formula Dialog Box
Ctrl + R / D Autofill (Copy Paste Right / Down) F9 / Shift + F9 Calc Entire File / Active Sheet Only
Ctrl + Z / Y Undo / Redo Last Action Alt + Enter Start New Line in Cell
Ctrl + F / H Find / Replace
Alt + 0150 / 0151 Insert "N" Dash "–" / "—"
Alt + = Summation (AutoSum) Ctrl + ; / : Insert Date / Time as Value
Ctrl + ' / " Copy Formula / Value Above Ctrl + ` (tilda) Toggle Cell Values / Formulas
Ctrl + Shift + Enter Enter Formula as an Array


More to come...