View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
vicky vicky is offline
external usenet poster
 
Posts: 70
Default Auto-Sort Won't Sort All Column Cells

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?



"TikiTembo" wrote:

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!!