Filter nonblanks

[kherse sefid]

Hi

I have a column that looks like this:

2
43

23
21

3

12

it contains blank cells, but still when I go to DATA/Filter/Autofilter I
don't get the nonblanks option. How can it be?

 

[Roger Govier]

Hi

If you just place the cursor in the header cell and apply Autofilter, it
will think the range stops after 43 and your dropdown will only show 2 and
43.
Mark the complete range of data, then apply Autofilter and you will see each
of the numbers as well as Blanks and Non Blanks as options.