Nothing to do with frozen panes.

If you have one header row.....row 1, simply tell Excel in the Sort process
that you have a header row.

To not sort the top 6 rows, do not include them in your sort range.

This means you have to select from row 7 to end of data rows.

Now sort with no header row.


Gord Dibben MS Excel MVP

On Thu, 19 Nov 2009 10:39:01 -0800, Subtox
wrote:

When I freeze one or more rows, and then I click a single column header and
sort by that column, sometimes the frozen rows are included in the sort, and
sometimes they are not. I don't ever want them to be included, so I'm trying
to figure out what is causing this to happen and how to prevent it.

For example, say I have a "Name" column containing three rows: Tom, Dick,
and Harry. The top row (containing the header) is frozen. If I sort by that
column, I'd expect "Name" to stay in the top row, and the other rows to be
sorted Dick, Harry, and Tom. Sometimes this works exactly as I'd expect, but
other times the column header is included in the sort, so I'll end up with
rows sorted as Dick, Harry, Name, and Tom.

This can really mess things up when I have, say, 6 rows containing a sheet
title, user instructions, and header data frozen at the top and I don't want
any of these rows to be included when sorting. Can anyone tell me how to
control this?