To allow row one to be the header row, you should be able to go to Data -
Sort - and then check the box that says "My data range has header row".

"bro. Billy" wrote:

Office 97 allowed me to keep an Excel spreadsheet row 1 as header row
onscreen while sorting date in any column's date in any row below row 1.
Newer Office 2003 Excel grabs row 1 in any data column sort. I even have row
1 protected with "Freeze Windows".

Help please...