When I try to sort in Excel only part of the table sorts
 

I have a spread sheet with 10 columns when I try to sort on date - the second
column only the first four columns sort.

When I try to sort in Excel only part of the table sorts
 

You mean only the first 4 rows in the 2nd column? Please see: Data Isn't
Recognized he
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"jrw562" wrote in message
...
I have a spread sheet with 10 columns when I try to sort on date - the
second
column only the first four columns sort.

When I try to sort in Excel only part of the table sorts
 

If you select the complete range yourself, then do data|sort, it'll work ok.

jrw562 wrote:

I have a spread sheet with 10 columns when I try to sort on date - the second
column only the first four columns sort.

--

Dave Peterson

When I try to sort in Excel only part of the table sorts
 

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.

"Anne Troy" wrote:

You mean only the first 4 rows in the 2nd column? Please see: Data Isn't
Recognized he
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"jrw562" wrote in message
...
I have a spread sheet with 10 columns when I try to sort on date - the
second
column only the first four columns sort.

When I try to sort in Excel only part of the table sorts
 

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.

"Dave Peterson" wrote:

If you select the complete range yourself, then do data|sort, it'll work ok.

jrw562 wrote:

I have a spread sheet with 10 columns when I try to sort on date - the second
column only the first four columns sort.

--

Dave Peterson

When I try to sort in Excel only part of the table sorts
 

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.

jrw562 wrote:

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.

"Dave Peterson" wrote:

If you select the complete range yourself, then do data|sort, it'll work ok.

jrw562 wrote:

I have a spread sheet with 10 columns when I try to sort on date - the second
column only the first four columns sort.

--

Dave Peterson


--

Dave Peterson

When I try to sort in Excel only part of the table sorts
 

That works - thanx

"Dave Peterson" wrote:

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.

jrw562 wrote:

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.

"Dave Peterson" wrote:

If you select the complete range yourself, then do data|sort, it'll work ok.

jrw562 wrote:

I have a spread sheet with 10 columns when I try to sort on date - the second
column only the first four columns sort.

--

Dave Peterson


--

Dave Peterson