Wauvel

Excel like a finance pro.

← The library

Rows & columns shortcut

Unhide rows in the selection

Ctrl + Shift + 9 on Windows, Ctrl + Shift + 9 on Mac.

OccasionalDifficulty 1050 · Capable
Practice · 2 questions →

When to use it

Unhides any hidden rows within the selection.

The shape of it

Windows
Ctrl + Shift + 9
Mac
Ctrl + Shift + 9

Worked examples

  • Unhide rows

    Select rows 1 to 50, Ctrl + Shift + 9 → All hidden rows in that span reappear

    Bring back detail.

  • Unhide everything

    Ctrl + A, Ctrl + Shift + 9 → Every hidden row on the sheet

    Full reveal.

  • One row

    Select across a hidden row, Ctrl + Shift + 9 → Just that row

    Targeted.

Worth knowing

  • The selection must span the hidden rows.
  • Ctrl + Shift + 0 for columns often does not work on Windows; use Format, Unhide Columns.
  • Filtered rows are not hidden rows; clear the filter instead.

Where it goes wrong

  • Does nothing if the selection does not cross the hidden rows.
  • Rows hidden by a filter stay hidden.

Related

Ctrl + Shift + +Ctrl + -Alt, H, O, ICtrl + 9Ctrl + 0Alt + Shift + →

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.