How do I sort the whole row at once in Excel?

  • Thread starter Harried in Hicksville
  • Start date
H

Harried in Hicksville

Here's what I have. I have a document used to record and track dog licenses
in my city. There are 11 columns in the document. One column contains
numbers as currency (not set up as text). I want to sort the document in two
ways. I want to be able to sort so they are listed by license number (column
1), but I also want to be able to sort so they are listed by owner's name
(column 2). Two different lists. My problem is that I can't seem to get the
sort to carry across the 11 columns. When I try to sort a row by license
number, for example, the sort only takes some of the columns with it, so I
end up with wrong information in the row.

Hope this makes sense!
 
F

Fred Smith

Select the range you want sorted first. Then use the Sort function.

Regards,
Fred.
 

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

Lose relative connection in formula on sort 2
Sorting day names chronologically 5
How do I pick row 3 to be the header row in Excel 1
how to sort my whole sheet 2
Macro To Sort By Column Header Names 6
Multiple Column Sorting 2
How can I sort one column and have the entire row sort. (binding) 10
How do I sort by row instead of by column? 7

Top