DemoClick

How to hide 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
3Ben OrtizEast9,880Mar 4
4Cara NgWest15,220Mar 5
5Dan ParkNorth7,410Mar 6
6Elle KimSouth11,030Mar 7
7Finn RossEast8,650Mar 8
8Gia TorresWest13,910Mar 9
Sheet1Ready100%

Simplified simulation — your Excel may show more buttons.

1

Select the rows you want to hide by dragging across their row numbers.

Here rows 3 and 4 are selected (shown highlighted).

Steps in text

  1. Select the rows you want to hide by dragging across their row numbers.
  2. Right-click one of the selected row numbers to open the context menu.
  3. Click Hide — quicker than digging through the Format menu.
  4. Rows 3 and 4 vanish.

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