Unable to correctly sort columns in spreadsheet

[Guest]

W-XP_Pro - Excel 2003
I receive spreadsheets from 10 agencies monthly. On only one agency
spreadsheet, when I try to sort on a column, the column header is included in
the sort. This doesn't happen on the other spreadsheets. Any suggestions
appreciated.
Thanks, Dan

 

[Peo Sjoblom]

If you do data>sort instead of hitting the A/Z icon you get an option to
select "My Data has: Header row/No header row". Most likely this workbook
has no header row so just select has header row and save the workbook and
you should be good for future sorting

--


Regards,


Peo Sjoblom

 

[Bob I]

Tick "header row" option under Data Sort.

 

[Guest]

Thanks, Peo. I just did that but it doesn't work. After I followed your
suggestion and saved, I went back to Data/Sort and it defaulted to "No header
row". It still won't work.

 

[Guest]

Thanks Bob, I did that. Please see my reply to Peo. I can work around fairly
easy but I don't know why this particular spreadsheet is different than the
rest I get in, where I don't have this problem.

 

[Bob I]

try format the top row to text?

Thanks Bob, I did that. Please see my reply to Peo. I can work around fairly
easy but I don't know why this particular spreadsheet is different than the
rest I get in, where I don't have this problem.

:

 

[Guest]

Update...
With the Data/Autofilter on, I can select "Sort" and select "Ascending" and
it works.
Thanks, Dan

 

[Bob I]

Thanks for posting back your solution!

Update...
With the Data/Autofilter on, I can select "Sort" and select "Ascending" and
it works.
Thanks, Dan

: