DemoClick

How to unhide rows in Excel

Interactive walkthrough — 4 steps. Click through at your own pace.

Your version:
AutoSave ●Book1 — Excel—▢✕
HomeInsertPage LayoutFormulasDataViewReviewDraw
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
A1fx
ABCD
1NameRegionSalesDate
2Ava ChenWest12,400Mar 3
5Dan ParkNorth7,410Mar 6
6Elle KimSouth11,030Mar 7
7Finn RossEast8,650Mar 8
8Gia TorresWest13,910Mar 9

Rows 3–4 are hidden — notice the row numbers jump from 2 to 5.

Sheet1Ready100%

Simplified simulation — your Excel may show more buttons.

1

Notice the jump in row numbers — rows 3 and 4 are hidden.

Select the rows on either side by dragging across row numbers 2 and 5, so the hidden rows in between are included.

Steps in text

  1. Notice the jump in row numbers — rows 3 and 4 are hidden.
  2. Right-click either row number bordering the gap to open the context menu.
  3. Click Unhide — much faster than the Format menu.
  4. Rows 3 and 4 reappear — the row numbers now run 1 through 8 with no gaps.

More Excel walkthroughs

How to freeze the top row in Excel

5 steps

How to freeze a row in Excel

6 steps

How to freeze a column in Excel

6 steps