Opens Go To, where you can type an address or name, and reach Go To Special, which selects cells by type: blanks, formulas, constants, visible cells, errors.

Windows

Ctrl + G (or F5)

Mac

Ctrl + G

• Jump to an address

  Ctrl + G, type Z500, Enter → The cursor jumps to Z500

  Named ranges work too.

• Select blanks

  Select a column, Ctrl + G, Alt + S, K (blanks), Enter → Only the empty cells are selected

  Then type a value and Ctrl + Enter to fill all the blanks at once.

• Find formulas

  Ctrl + G, Alt + S, F (formulas), Enter → Every formula cell is selected

  Color them to audit which cells are calculated.

• Go To Special (Alt + S inside it) selects blanks, formulas, constants, or visible cells only.
• F5 opens the same dialog.
• Go To Special, Constants, with only Numbers checked finds hardcoded numbers inside a calculation block.
• Visible cells only (Alt + ;) is also in this dialog.

• Go To Special works on the selection; select the area first or it scans the whole sheet.
• Filling blanks with Ctrl + Enter also fills cells that were meant to stay empty.