Filter & Sort

[Karin]

I have an excel document with an autofilter turned on in the row above my
data. I'm running Office 2007 but always save my docs in 97-2003 compatible
format because 1/2 our staff has not yet been migrated to the 07 version.
When I try to sort my columns in ascending or descending order, it works
perfectly. However, when the folks on backlevel versions of Excel perform the
same sorts, they end up with the first entry in the column not being included
in the sort - the rest of the column sorts properly. Any ideas?

 

[Gord Dibben]

On older versions, instead of using the sort from the Autofiklter
dropdown.........

Go through Data>Sort>My data range has "no header row"

Checkmark it.


Gord Dibben MS Excel MVP

 

[Karin]

It's already set to 'no header row'. Here's a little more detail. Older
version is 2003. Data looks similar to:
COLHDRTEXT
blank row with filter
1
504
78
360

If I choose through the autofilter to sort in descending order I get
1
504
360
78

 

[Gord Dibben]

That's what I said...........if you use the AF sort Excel always assumes the
filter arrow row is a header so leaves it out of the sort.

With the Data>Sort method you can change this to "no header"


Gord