View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
jrw562
 
Posts: n/a
Default 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