Removing a filter shows all the rows you hid when you applied it

When you filter a spreadsheet in Excel, you are hiding rows that do not match what you filtered for. Removing the filter unhides those rows so you see the complete dataset again. The steps differ slightly depending on whether you want to remove one filter from a single column or turn off filtering entirely.

The fastest way is to click the Data menu, then click Clear. This removes all filters at once and shows every row. If you want to remove a filter from just one column while keeping others active, click the filter button in that column's header and select Clear Filter From [Column Name].

Key Takeaways

  • Clicking Data, then Clear removes all filters and shows every hidden row in your spreadsheet.
  • To remove a filter from one column only, click the dropdown arrow in that column's header and choose Clear Filter From [Column Name].
  • A column with an active filter shows a blue funnel icon in its header; a cleared column shows a gray funnel.
  • Removing a filter does not delete any data — it only unhides rows that were hidden by the filter.
  • If you cannot see the filter buttons in your header row, click Data, then click Filter to turn filtering on.

Remove all filters at once using the Data menu

Open your spreadsheet in Excel and look at the top menu bar. Click the Data tab. In the ribbon that appears below it, look for a button labeled Clear. Click it. This removes every filter you have set and shows all rows in your spreadsheet.

You will know the filters are gone because the column headers will no longer show the small funnel icons that appear when a filter is active. All your data reappears when ready — nothing is deleted, only unhidden.

Remove a filter from one column while keeping others

If you have multiple filters set and want to remove only one, click the small dropdown arrow in the header of the column you want to clear. A menu appears with filter options. Near the top of this menu, you will see an option that says Clear Filter From [Column Name] — the actual column name will appear instead of the brackets. Click that option.

That single column's filter disappears, and all rows hidden by that filter reappear. Any other filters you set on different columns stay active and continue hiding rows. The column you just cleared will show a gray funnel icon instead of a blue one, indicating it no longer has an active filter.

Turn off filtering completely if you no longer need it

If you want to remove filtering from your spreadsheet entirely — not just clear the current filters but remove the filter buttons from the headers — click the Data menu again. Look for a button labeled Filter and click it. This toggles filtering off. The filter dropdown arrows disappear from all column headers.

You can turn filtering back on the same way: click Data, then click Filter. The filter buttons reappear in your headers, and any filters you had set before are still there, ready to use again. Turning filtering off and on does not change your data.

What to do if the filter buttons are not visible

Sometimes the small dropdown arrows in your column headers are not visible even though you have filtering turned on. This usually happens if your header row is formatted differently or if filtering was turned off accidentally. Click the Data menu and look for the Filter button. If it has a checkmark next to it, filtering is already on — the buttons may just be hidden by your view settings.

If Filter does not have a checkmark, click it to turn filtering on. The dropdown arrows will appear in your header row. If you still cannot see them, make sure you have selected a cell within your data range before clicking Data and Filter. Excel needs to know which data you want to filter.

Understanding the difference between clearing and removing filters

Clearing a filter and removing the filter feature are two different actions. When you clear a filter, you are telling Excel to stop hiding rows based on that filter — but the filter buttons stay in your headers. When you remove filtering entirely, the buttons disappear from your headers.

Most of the time, you only need to clear filters. You remove the filtering feature itself only if you are done using filters on that spreadsheet and want a cleaner view of your headers. If you change your mind, you can always turn filtering back on by clicking Data, then Filter.

Why filtered data sometimes looks confusing

When a filter is active, Excel hides rows but does not delete them. This can make row numbers look strange — you might see row 3, then row 7, then row 12, with gaps in between. Those gaps are hidden rows. The row numbers themselves stay the same; they do not renumber when you filter.

If you copy data from a filtered spreadsheet, Excel copies only the visible rows, not the hidden ones. This is useful when you want to work with just the filtered results, but it can be confusing if you forget a filter is active and think you are copying your entire dataset. Removing the filter before copying ensures you get all your data.

Frequently Asked Questions

Does removing a filter delete any of my data?

No. Removing a filter only unhides rows that were hidden by the filter. All your original data remains in the spreadsheet. If you want to permanently delete rows, you have to select them and use the Delete command — filtering alone never removes data.

Can I remove a filter from one column but keep filters on other columns?

Yes. Click the dropdown arrow in the column header you want to clear, then select Clear Filter From [Column Name]. The other filters stay active. You can also clear all filters at once by clicking Data, then Clear.

What does the blue funnel icon in the column header mean?

A blue funnel means that column has an active filter hiding some rows. A gray funnel means the column has filtering available but no filter is currently set. No funnel at all means filtering is turned off for the entire spreadsheet.

If I turn off filtering, will I lose my filter settings?

If you turn filtering off by clicking Data, then Filter, your filter settings are saved. When you turn filtering back on the same way, your previous filters reappear and are ready to use. You only lose filter settings if you delete the column or close the file without saving.

Why do my row numbers have gaps after I filter?

The gaps are hidden rows. When you filter, Excel hides rows that do not match your filter criteria but keeps them in the spreadsheet. The row numbers do not change or renumber — they stay the same so you can see which rows are hidden. Removing the filter unhides them and the gaps disappear.