how do i set the default sort option to recognize a header

[Guest]

In Excel 2002 you could press the sort button and the data would be sorted
and the header would be excluded. Now using excel2003 I can't do it this way
because excel is not recognizing the header, Is this a setting I can change,
if so, how can I change this.

 

[Dave Peterson]

Sometimes if you format the header row differently (bold/larger font), then
excel will be able to guess if you have headers.

Personally, I think it's a bad idea to let excel guess at the headers or the
range to be sorted--I don't trust it!