Unable to correctly sort columns in spreadsheet
 

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

Unable to correctly sort columns in spreadsheet
 

If you do datasort 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


"Dan" wrote in message
...
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

Unable to correctly sort columns in spreadsheet
 

Tick "header row" option under Data Sort.

Dan wrote:

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

Unable to correctly sort columns in spreadsheet
 

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.

"Peo Sjoblom" wrote:

If you do datasort 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


"Dan" wrote in message
...
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

Unable to correctly sort columns in spreadsheet
 

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" wrote:

Tick "header row" option under Data Sort.

Dan wrote:

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

Unable to correctly sort columns in spreadsheet
 

try format the top row to text?

Dan wrote:

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" wrote:


Tick "header row" option under Data Sort.

Dan wrote:


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

Unable to correctly sort columns in spreadsheet
 

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

"Dan" wrote:

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" wrote:

Tick "header row" option under Data Sort.

Dan wrote:

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

Unable to correctly sort columns in spreadsheet
 

Thanks for posting back your solution!

Dan wrote:

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

"Dan" wrote:


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" wrote:


Tick "header row" option under Data Sort.

Dan wrote:


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

It may be that there is an imported imperfection to the data in their xls.
Select a cell, look at the contents in the text bar... lets say its 123.4
Whats after the .4? is there a space?
Select after the 4, hold shift and select everything to the right with the curser buttons.
Whatever it selects, Ctrl-c to copy it.
Select everything in the spreadsheet, use Ctrl-F (or open Find/Replace) and Ctrl-v the space into "Find".
For "Replace" enter nothing, no space, not nothing - this will replace some oddity with nothing. ('scuse the dbl -ve)
Replace All.
If it finds 17954 occurances (guessing at the number...) then that was the problem.

- if not after the 4, howsabout infront of the 1 ?

hope this helps.

I get this quite often with a copy/paste from one of our systems.