Hi
If you don't use Data/Sort, Excel will guess whether you have a header row
or not. It will also guess at the range you want to sort. It's not
foolproof, though!
Andy.
"m.cain" wrote in
message ...
Hello,
If I select the blank row above my list and below my header, and then
activate the AutoFilter (Data/Filter/AutoFilter), when I click the Sort
Ascending or Sort Descending option, the first row in my list remains
the same.
How do I include the first row?
Thanks for your help!
--
m.cain
------------------------------------------------------------------------
m.cain's Profile:
http://www.excelforum.com/member.php...o&userid=32773
View this thread: http://www.excelforum.com/showthread...hreadid=526057