View Single Post
  #3   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Sun, 5 Jun 2005 17:55:30 -0700, Cactus
wrote:

I have copied and pasted data in cells in a particular row amongst other rows
not in any order. I would like to know if there is a method other than manual
sorting to place the individual cells in this row in ascending or descending
order, without disturbing the cells in the rest of the rows. And then to skip
to the next row and do the same thing over again. Treating each row
seperately on the same worksheet.

Many thanks
Cactus


Select the cells you wish to sort; only one row.

Data/Sort
Continue with the current selection
Sort
Options
Orientation: Sort Left to Right
<OK
<OK

Then select your next row and continue the process.

--ron