Sorting without moving column labels

[Guest]

How do I sort on a specific column without having the column labels which are
in the first row of each column sorted into the list?

Thanks for any help.

Ted

 

[doodle]

on the data sort form, specify that there is a header row.

-doodle

 

[Guest]

This did allow me to sort, but every sort I must go back and place the dot in
front of "header_row". How do I get it to stay there? I know it can be set
that way, because I opened some other Excel files I had previously created,
and the dot was in front of "head_row" without my doing anything.

Thanks for your help.

 

[Robert Morley]

Excel makes a "best guess" as to whether or not there's a header row. I'm
not 100% sure how it decides this, but typically it seems that if the first
row is formatted differently than the rest of the rows, Excel will guess
that there's a header row. I believe freezing the top row also triggers it,
but I'm not absolutely certain of that.


Rob

 

[Roger Govier]

Hi

If the Header is text and the data is numeric, then Excel "guesses" the
first row is a header.
If the header is text and the data is Text, it doesn't know
If you embolden the Header, then even if the data is Text, excel
"guesses" the first row is a header.