How do I pick row 3 to be the header row in Excel
 

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.

How do I pick row 3 to be the header row in Excel
 

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.