Each time when I sorting, Excel always include header row. Is there
any way to exclude header row when sorting?
You can specify whether you want the header row included on the Data|Sort
dialog.
Lots of times, excel will know how to guess correctly if you format that header
row differently--try making the header bold and test it.
> Each time when I sorting, Excel always include header row. Is there
> any way to exclude header row when sorting?

Signature
Dave Peterson
gil.qi.zhang@gmail.com - 21 Jun 2007 03:17 GMT
> You can specify whether you want the header row included on the Data|Sort
> dialog.
[quoted text clipped - 10 lines]
>
> Dave Peterson
It works. Can't believe it's so tricky. Thanks a lot, Dave. :)