View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default How do I sort the whole row at once in Excel?

hi
see this site
http://office.microsoft.com/en-us/te...172771033.aspx
time sheet templates - various. surely one was made for you.

Regards
FSt1

"Harried in Hicksville" wrote:

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!