G gil.qi.zhang Jun 20, 2007 #1 Each time when I sorting, Excel always include header row. Is there any way to exclude header row when sorting?
Each time when I sorting, Excel always include header row. Is there any way to exclude header row when sorting?
D Dave Peterson Jun 20, 2007 #2 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.
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.
G gil.qi.zhang Jun 21, 2007 #3 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. Click to expand... It works. Can't believe it's so tricky. Thanks a lot, Dave.
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. Click to expand... It works. Can't believe it's so tricky. Thanks a lot, Dave.