J
jrw562
I have a spread sheet with 10 columns when I try to sort on date - the second
column only the first four columns sort.
column only the first four columns sort.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anne Troy
You mean only the first 4 rows in the 2nd column? Please see: Data Isn't
Recognized here:
http://www.officearticles.com/excel/data_cleanup_tips_for_microsoft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Recognized here:
http://www.officearticles.com/excel/data_cleanup_tips_for_microsoft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
D
Dave Peterson
If you select the complete range yourself, then do data|sort, it'll work ok.
J
jrw562
No - I have some kind of range set up and all of the first four columns sort
correctly but nothing in the other 6 columns changes.
correctly but nothing in the other 6 columns changes.
J
jrw562
That works if I am sorting date and the dates are the first column. But if
the date is the second column when I select range (ten columns) and go back
to click on date column to sort on I loose the range selection.
the date is the second column when I select range (ten columns) and go back
to click on date column to sort on I loose the range selection.
D
Dave Peterson
Select your range, then use Data|Sort from the menu bar.
I do my best not to use those a->z and z->a icons. I think they cause more
trouble than they're worth.
I do my best not to use those a->z and z->a icons. I think they cause more
trouble than they're worth.
J
jrw562
That works - thanx
Dave Peterson said:Select your range, then use Data|Sort from the menu bar.
I do my best not to use those a->z and z->a icons. I think they cause more
trouble than they're worth.