DemoClick

How to remove a filter 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
Name ▼Region ⧩Sales ▼Date ▼
2Ava ChenWest12,400Mar 3
4Cara NgWest15,220Mar 5
7Gia TorresWest13,910Mar 9

Row numbers jump (2, 4, 7) — East and North rows are filtered out, leaving only West.

Sheet1Ready100%

Simplified simulation — your Excel may show more buttons.

1

This data is filtered to only West.

Notice the funnel icon on the Region header and the row numbers jumping 2, 4, 7. Click the Data tab.

Steps in text

  1. This data is filtered to only West.
  2. Click Clear to remove every filter at once and restore all rows.
  3. Every row is back and the funnel icon is gone.
  4. To turn the arrows off too, click Filter again.

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