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 / October 2007

Tip: Looking for answers? Try searching our database.

Sorting problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JM - 21 Oct 2007 05:39 GMT
This is strange...
I have a spreadsheet of name, address, city, state, zip etc., etc.  I can
sort the list by the "last name" column (which is the 1st column) fine using
the "Data Sort" drop down box (there is a header row).  But for some reason,
trying to sort on any other column, i.e. State or Zip columns, it does not
sort.  Yes, I could highlight all the rows and do it that way, but the list
will end up with hundreds of names and not be as easy.  I am using Excel
2000.  Am I missing something here?
Thanks.
Signature

JM

Kassie - 21 Oct 2007 10:26 GMT
I am most likely way off target here, but?  The only way to sort, is to
select everything you wish to sort, and then to sort by the column or columns
you want to sort by?  One way is to select the top leftmost cell, hold down
the <Shift> key, and then press <End><Down><End><Right>, or select a named
range.  Given that an area of more than one row, and more than one column is
selected, you will be able to sort that area by whichever of the selected
columns you wish.  A header row makes it easy to select criteria, while an
area without a header row merely requires you to select columns iso headers.

Signature

Hth

Kassie Kasselman
Change xxx to hotmail

> This is strange...
> I have a spreadsheet of name, address, city, state, zip etc., etc.  I can
[quoted text clipped - 5 lines]
> 2000.  Am I missing something here?
> Thanks.
JM - 21 Oct 2007 15:09 GMT
Thanks for the help.
Signature

JM

> I am most likely way off target here, but?  The only way to sort, is to
> select everything you wish to sort, and then to sort by the column or columns
[quoted text clipped - 14 lines]
> > 2000.  Am I missing something here?
> > Thanks.
 
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.