Excel: keeping rows together when ordering order of left column

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
 
J

Jacob Skaria

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
 
Top