Filter nonblanks

  • Thread starter Thread starter kherse sefid
  • Start date Start date
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?
 
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.
 
Back
Top