Fix an Excel filter that shows no data

In this article, you will learn how to filter columns in Excel.

Issue

You want to filter the column, but you don't see any data at all

'.Excel filter troubleshooting screenshot.'

Screenshot

Perhaps this error is caused by the fact that you have selected the entire top row for the filter.

There is an error somewhere and it does not allow filtering

Check whether the filters are on all columns, as in the picture below, or only on one.

'.Excel filter troubleshooting screenshot.'

Screenshot

Re-select the top row → Click Sort & Filter → Filter

'.Excel filter troubleshooting screenshot.'

Screenshot

I enlarged the picture in case it's hard to see

'.Excel filter troubleshooting screenshot.'

Screenshot

Making sure that the selection is removed

'.Excel filter troubleshooting screenshot.'

Screenshot

Select the desired column and set the filter again through Sort & Filter → Filter

'.Excel filter troubleshooting screenshot.'

Screenshot

Making sure that the filter works.

'.Excel filter troubleshooting screenshot.'

Screenshot

Article author: Arthur Isaev