Column Headers Not Fixed
 

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

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

Thank you Dave, you're right that I am using the A-Z sort feature. But the
headers were already bold and gave the appearance of headers. For some reason
Excel is not perceiving these as headers.

Anyone else have a suggestion to why the headers are not being perceived by
Excel as headers?

Is there a way to format the cells to be designated specifically as headers?
I've searched through the online help and haven't found a way to do this, but
maybe someone else has stumbled into it.

"Dave Peterson" wrote:

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