Sorting error?

N

NikkoW

I'm hoping someone can help me with a problem I am having with Excel 2000.

I have several columns of data with a header row and want to alpha sort all
the data according to the names in column C.

I click in column c and click on the sort button. My header row gets sorted
along with everything else. If I use the Data>Sort dialog I don't have this
problem. This used to work until recently.

BTW, I have the header row separated from the rest by a Freeze Pane. There
is no empty row under the header.

Any idea what gives???

Nick
 
F

Frank Kabel

Hi
Excel 'guesses' the structure of your data and maybe gets confused by
freezed panes. So easiest solution is to use the menu
 
M

Myrna Larson

Does your header row have any special formatting, like bold face or bottom
borders? If not, try applying something like that. In looking for a header
row, Excel also looks for a top row that's formatted differently than the data
below it.
 
Top