Excel: keeping rows together when ordering order of left column

Excel: keeping rows together when ordering order of left column

Post by VGFuZ29qb2 » Thu, 07 Jan 2010 17:15:01


in my spreadsheet I want to order the left hand column (in ascending numbers)
but when I do I want the rows to move with cells too, keeping the items of
data in the rows with the original items of data in the left hand cells when
they move place
 
 
 

Excel: keeping rows together when ordering order of left column

Post by SmFjb2IgU2 » Thu, 07 Jan 2010 17:48:02

Select the data say A1:J10 and then from menu Data>Sort>

--If your data has headers then select 'My data range has' headers ..
--Select 'Sortby'..and hit OK


--
Jacob