Filter nonblanks

K

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?
 
R

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.
 
Top