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 / General Excel Questions / March 2008

Tip: Looking for answers? Try searching our database.

Auto-Sort Won't Sort All Column Cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TikiTembo - 25 Mar 2008 16:55 GMT
Hi. I'm having some trouble with the Auto-Sort feature in Excel 2003. The
spreadsheet has several columns which sort easily, but the last column will
only sort a select tiny block of cells. Is there a way to correct this so the
Auto-Sort will sort the entire column?  Many thanks!!
Vicky - 25 Mar 2008 20:00 GMT
Check for blank rows or columns (hidden rows and columns too)  

Also, look at your column headers.  Does the last column have a column
header that uses the same formatting as the other columns?  

What about Data - Sort and trying it from there?

> Hi. I'm having some trouble with the Auto-Sort feature in Excel 2003. The
> spreadsheet has several columns which sort easily, but the last column will
> only sort a select tiny block of cells. Is there a way to correct this so the
> Auto-Sort will sort the entire column?  Many 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.