Sorting with AutoFilter

[m.cain]

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!

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>