Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort the whole row at once in Excel?
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort the whole row at once in Excel?
Select the range you want sorted first. Then use the Sort function.
Regards, Fred. "Harried in Hicksville" <Harried in wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
Sort from SQL view does not sort in EXCEL | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |