Excel: keeping rows together when ordering order of left column

  • Thread starter Thread starter Tangojon
  • Start date Start date
T

Tangojon

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
 
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
 
Back
Top