Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Harried in Hicksville - 20 Mar 2008 21:46 GMT
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!
FSt1 - 20 Mar 2008 21:57 GMT
hi
see this site
http://office.microsoft.com/en-us/templates/CT101172771033.aspx
time sheet templates - various. surely one was made for you.

Regards
FSt1

> 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
[quoted text clipped - 7 lines]
>
> Hope this makes sense!
Fred Smith - 21 Mar 2008 03:30 GMT
Select the range you want sorted first. Then use the Sort function.

Regards,
Fred.

> Here's what I have.  I have a document used to record and track dog
> licenses
[quoted text clipped - 11 lines]
>
> Hope this makes sense!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.