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.