Filters Not Picking Up Data

[mcgonma]

I have a sheet with columns that have "X"s in the cells. When I turn on the filters, none of them show the "X" as something to select. I only have the "Select All" and "Blanks".
There are no protections on the file or sheet.
I have even copied/pasted the data over into a new file and still cannot get it to work.

 

[gargamalebarbosa]

Hi,
on table have only X and empty cells in columns?

 

[mcgonma]

Hi,
on table have only X and empty cells in columns?

Yes. There's either only X or it is blank.

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Could you upload a copy of the file (any sensitive data removed or disguised) to DropBox or OneDrive or Google Drive etc and provide a publicly shared link here in the forum so that we can take a look to see if the same thing happens at our end?

 

[gargamalebarbosa]

The filter function selects the range up to the first empty cell of the table, not the entire column. Can you try the process again ?