How to keep column headings from being sorted with data?
 

I occasionally have to re-sort my Excel file data by a different column and
then back to Last name. Every time, my headings sort with the other data and
it's a hassel getting the row back at the frozen top.
Is there a setting to keep the top row from sorting with the rest?

How to keep column headings from being sorted with data?
 

Yes.

In the Sort dialog, there is a choice: My data range has Header row/No header row

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"oldockbunny" wrote in message ...
|I occasionally have to re-sort my Excel file data by a different column and
| then back to Last name. Every time, my headings sort with the other data and
| it's a hassel getting the row back at the frozen top.
| Is there a setting to keep the top row from sorting with the rest?

How to keep column headings from being sorted with data?
 

Generally it helps to have the titles formatted differently.

i.e. Bold or Centered or similar.

Then make sure under DataSortMy Date Range Has "header row" checked.

Save the workbook and the setting should stick.


Gord Dibben MS Excel MVP

On Thu, 26 Oct 2006 10:05:02 -0700, oldockbunny
wrote:

I occasionally have to re-sort my Excel file data by a different column and
then back to Last name. Every time, my headings sort with the other data and
it's a hassel getting the row back at the frozen top.
Is there a setting to keep the top row from sorting with the rest?