Sorting with AutoFilter

M

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!
 
G

Guest

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.
 
Top