Lose row when clicking sort

[sowetoddid]

I sorted a list of data that does not have specific headers. I sorte
it according to column F. Next, I tried to resort the sam
data....without fail, row 1 always gets deselected when I click o
data-sort.


Any ideas?

 

[David McRitchie]

Hi "sowetoddid >" <<[email protected]> ,
Then you must indicate that you do not have headers
so that Excel will only sort what you want.

That was probably not mentioned in the following but may be
of interest.
http://www.mvps.org/dmcritchie/excel/sorting.htm

 

[Gord Dibben]

Perhaps the "my list has" "header row" is checked on.

Gord Dibben Excel MVP