Select every error cell in Excel

Select every error cell in Excel: Ctrl+G, Alt+S, K, Enter (Mac: Ctrl+G, Special, Formulas, Errors)

Windows	`Ctrl+G, Alt+S, K, Enter`
Mac	`Ctrl+G, Special, Formulas, Errors`
Group	navigation

Practice this shortcut

Drill: Next error. Pro drill. Twenty-five drills are free.

What it does and when to use it

Go To Special can select every cell of a kind: blanks, constants, formulas, or formulas that return errors. Ctrl+G, Alt+S opens it; K picks formulas with errors; Enter selects them all and lands on the first.

The common mistake

Scrolling for #DIV/0! cells by eye. On a large sheet you will miss one; Go To Special never does.

Related shortcuts

Jump to the edge of the data Ctrl+Arrow
Jump to the last column of a row Ctrl+Right arrow
Return to cell A1 Ctrl+Home
Jump back up to the header Ctrl+Up arrow
Go to the start of the row Home
The printable cheat sheet

Questions

How do I find all #REF! errors in a sheet?

Ctrl+G, Alt+S, K, Enter selects every error cell. Then Tab moves through them one at a time.

Can I select all constants or all formulas the same way?

Yes: in the Special dialog, O selects constants and F selects formulas. Analysts use it to color inputs and formulas in one pass.

Learn it by pressing it

Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.

Start the drill