If you highlight your entire table before activating the filter, all rows
will be included.

If you don't, they Excel tries to guess the extent of the table. It figures
that a blank line is the end of the table.

To avoid this, change the height of the row, rather than using blank lines.

Regards,
Fred

"Allison" wrote in message
...
When filtering: some of my sheets have blank lines inserted & i am still
able
to filter the data below the blank lines. Sometimes I can not. Why?