Keyboard shortcuts — Excel guide

The keyboard is the fastest tool in Excel. These are the combos that pay rent daily, grouped by what they do.

Navigate

Jump around data instead of scrolling.

Keys	Action
Ctrl + Arrow	Jump to the edge of the data region
Ctrl + Home / End	Top-left / bottom-right of used range
Ctrl + PgDn / PgUp	Next / previous sheet
Ctrl + G or F5	Go To (→ Special: blanks, errors, formulas)

Selection is navigation plus Shift.

Keys	Action
Ctrl + Shift + Arrow	Select to the edge of the data
Ctrl + A	Select the data region (again: whole sheet)
Ctrl + Space / Shift + Space	Whole column / whole row
Ctrl + Shift + End	Select to the last used cell

The editing loop, hands on keys.

Keys	Action
F2	Edit the active cell
F4	Cycle $ locks while editing · repeat last action otherwise
Ctrl + D / Ctrl + R	Fill down / fill right
Alt + Enter	Line break inside a cell
Ctrl + ;	Today's date, static
Esc	Cancel the edit

The ones that look like magic in a meeting.