View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Sorting with AutoFilter

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