When a list grows to hundreds of rows, scrolling through it to find what you need becomes impractical. By the end of this page you will be able to filter a list so that only the rows you care about are shown, without deleting or losing anything.
Filtering temporarily hides rows that do not match a condition you set, while leaving every row of data safely in place underneath. It is one of the most useful tools for working with long lists, such as customer records, orders, or expenses, because it lets you focus on exactly the rows that matter at that moment.
- Dropdown arrow to choose values
- Only matching rows stay visible
To turn filtering on, click any cell inside your data, then go to the Data tab and click Filter. Small dropdown arrows appear on each column heading. Clicking one of these arrows opens a list of every distinct value in that column, each with its own tick box. Untick the values you want to hide, or untick 'Select All' and then tick only the ones you want to see, and click OK. Excel instantly hides every row that does not match your ticked values.
Try it yourself
Set up a small list with headings such as Region, Product and Sales across a few columns and several rows.
Filtering needs headings and rows of data underneath them to work sensibly.
Click any cell inside the list, go to the Data tab, and click Filter.
This adds the dropdown arrows to every heading, turning filtering on for the whole table.
Click the arrow on the Region heading, untick Select All, then tick just one region, and click OK.
This hides every row that is not from the region you chose, letting you focus on it alone.
Look at the row numbers down the left of the sheet.
You will notice some numbers are missing and shown in blue, which is Excel's way of confirming rows are hidden by a filter, not deleted.
Click the same arrow on Region again and choose 'Clear Filter From Region', or click Select All and OK.
This brings every row back, showing that filtering never removed anything, only hid it temporarily.
Words people use
Filtering pairs very naturally with sorting, which you have likely already met, since both help you make sense of a long list without altering the data underneath. Reaching for Filter whenever a list feels too long to scan by eye will save you a great deal of time.
Check yourself
If you can say yes to each of these, you are ready for the next lesson.
- I can turn filtering on from the Data tab.
- I can use the dropdown arrow to show only chosen values.
- I understand that filtering hides rows rather than deleting them.
- I can clear a filter to bring every row back.