Filter is not showing "Blanks" or data in cells after

[audioboxer]

Hello,

I have office 365 and in Excel I am not getting the option to filter by "Blank" cells and if there are any cells with data after a blank cell, the filter does not show these values. I never had this issue in previous versions. Was there a change that now prevents this or an option that needs to be enabled? I can't find anything relating to the issue.

example

With a blank row

results in

Without a blank row

results in

Thanks

 

[Fluff]

I have office 365

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’)

If the entire row is blank then the autofilter will not look below that row & as far as I remember that has always been the case. To get round that you have to manually select the range before applying the autofilter.