Auto-Sort Won't Sort All Column Cells

[TikiTembo]

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]

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?