autofilter help

M

max power

when i set my auto filter it stops at blank lines rather than allowing me to
select "blanks or non blanks"

the data that it filters doesnt pass the blank line so i have

dispatched
arrived
arrived

dispatched

when i set the auto filter to show "arrived" it still shows the second
"dispatched" because it is after the blank line

is there some setting causing this
 
M

MartinW

Hi Max,

If you have only selected the first cell in a column or columns
then applied Autofilter it will only select as far as the first
blank it comes to.

If you want it to select all of your data blanks included then
highlight all of your data before applying Autofilter.

You can also select the entire column or columns by
highlighting the column headers A,B,C etc.

HTH
Martin
 
Top