Sorting

[kevs]

I click inside a cell and choose data, sort. I select header row because no
header row is selected. I then click to sort by the various columns I want.

I then make a few changes. I then choose data, sort. I now have to start
all over because no header rows is now selected. Is this the way it is
supposed be? Thanks!!!

 

[J.E. McGimpsey]

I click inside a cell and choose data, sort. I select header row because no
header row is selected. I then click to sort by the various columns I want.

I then make a few changes. I then choose data, sort. I now have to start
all over because no header rows is now selected. Is this the way it is
supposed be? Thanks!!!

Not sure about "supposed to be" - but XL appears to use some
heuristics to determine whether a header is present, and uses that
each time.

For instance, if the first row is in bold, Header Row is selected,
or if the first row is text and the data is numbers.

 

[kevs]

Not sure about "supposed to be" - but XL appears to use some heuristics to
determine whether a header is present, and uses that each time.

For instance, if the first row is in bold, Header Row is selected, or if the
first row is text and the data is numbers.

Thanks JE:
That's interesting, so what I did was I made the fist row all bold, and now
it's defaulting to a header row, which is what I want.