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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

limit autofilter drop down menu entries 1
How to Sort within AutoFilter with Protection on (and AutoFilter . 1
Autofilter header row 3
AutoFilter defect or my mistake? 2
autofilter sort not visible 1
autofilter fails, not because of blank row 5
Enabling Autofilter and Sorting in a Protected Sheet 2
Sorting while protected - this question may not have been covered. 1

Top