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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximum Row Height Greater than 409.5 4
How do I reverse the order of a column or row? 3
move a row of data values to a column in sorted order 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Spreadsheets keep moving 0
Arrange B values ascending order but keep attached to column A in. 1
I can only delete an entire row not a cell in excel 2013? 1
VBA- Excel Programming:- 0

Back
Top