Select the range of rows and columns you want to include before you sort or
filter. Don't let Excel guess which range you want.
--
David Biddulph

"vssimmons" wrote in message
...
I have a large spread sheet with three rows used as headers and on row
three
I have all columns as auto filter. when I try to fiter on one of the
columns
the rows do not follow the column sort.