I select my range and use Data|Sort. On that dialog, I can choose header row or
no header row.

But I bet you're clicking one of those A-Z or Z-A buttons.

Sometimes just formatting the headers (bold, italics, say) will be enough to
give excel a hint that they're different (and they're headers).

Cabby wrote:

I have a 650-line sheet with columns A-P. When I use the sort feature for
different columns (such as sorting by last name, or zip code), the headers
keep sorting into the sheet. Anyone out there know a way to fix the column
headers? I use Excel regularly and have never had this problem before and I'm
stumped.

Many thanks--

--

Dave Peterson