View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Billy

You have to tell Excel you have a header row when in the DataSort dialog box.

OR..make sure the header row is formatted differently from your other rows.

Make it Bold or larger font or something unique.

Gord Dibben Excel MVP

On Wed, 8 Dec 2004 10:41:02 -0800, "bro. Billy" <bro.
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...