nonblank filters in excel 2007

M

Max

robert mills said:
how do i find nonblank filters in excel when working with spreadsheets
Click to expand...

Just sparing a thought here, as you haven't received any response yet (not
sure why, though <g>). ok, I don't have/know the latest xl2007, but would it
be any different from say, xl2003, where the option to choose: (NonBlanks) is
available in the autofilter dropdown (via Data > Filter > Autofilter)?
 
R

Ron de Bruin

Hi Robert

When you select the whole data column and there are blanks
you see "Blanks" in the filter list when you click on the arrow in the header
 
Top