Easy question I presume

[googs]

In my workbook, whenever I try sort all my data, the first row is sorted as well but this is my title row. I would not like my first row to be inserted in my sorting...anyway to fix this?


Thanks

 

[farnuckl]

Hello, just check the "header" option on the sort dialogue box. It will then ignore the first row.

-farnuckl

 

[NBVC]

Make sure to select "My Range has header" at the bottom of the Sort dialogue box

 

[Norie]

How are you doing the sort?

Have you selected Header row when you goto Data>Sort...?

If at some point you have disabled that feature, ie selected No header row it might affect subsequent sorts.