Sorting/Locking Header
I've done all that. I have everchanging data. When I select sort, the
header sorts with it. I don't want the header row to move.
"Gord Dibben" wrote:
Then try center and underline also.
Gord
On Sun, 28 Oct 2007 11:33:01 -0700, Sapphire927
wrote:
It is in bold and still won't hold.
"Gord Dibben" wrote:
Excel recognizes a header row if it has different formatting like Bold text.
Gord Dibben MS Excel MVP
On Sat, 27 Oct 2007 20:30:00 -0700, Sapphire927
wrote:
I am trying to be able to sort and not have my header sort with it. I want
the header row to be locked. I've used the excel help where it says to click
Data, Sort, then My Data has Header Row. I then click ok. But, then it
defaults back to No Header Row. How do I make it stick? Or is there
something I need to do in order to do so.
|