Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sort function for dates does not sort properly in Office 2007 Exc. Rosalie Excel Worksheet Functions 1 November 22nd 07 10:25 PM
data, sort option is grayed. how to sort on a column? Steve Richter Excel Discussion (Misc queries) 1 September 25th 07 03:25 PM
Sort from SQL view does not sort in EXCEL Pat M - City of Reno Excel Discussion (Misc queries) 0 August 31st 07 07:38 PM
Excel sort by Fill Color by custom list sort Dash4Cash Excel Discussion (Misc queries) 2 July 29th 05 10:45 PM
Excel Sort function should not sort the cell formatting! Lisa D.N.1 Excel Worksheet Functions 1 December 28th 04 08:37 PM


All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"