How to filter data in Excel
Interactive walkthrough — 6 steps. Click through at your own pace.
Your version:
AutoSave ●Book1 — Excel—▢✕
HomeInsertPage LayoutFormulasDataViewReviewDraw
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
B3fx
Sheet1Ready100%
Simplified simulation — your Excel may show more buttons.
1
Click any cell inside your data — here cell B3 is selected, shown by the green border.
Steps in text
- Click any cell inside your data — here cell B3 is selected, shown by the green border.
- Click the Data tab.
- Click Filter — a dropdown arrow now appears on every column header.
- Click the arrow on the Region header to open its filter.
- Untick every region except West, then click OK.
- The East and North rows disappear.