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