Changed Titled bar and now sort doesn't default to "Header Row"

[Guest]

I feel like an idiot. I deleted the first row in a data field that I used to
be able to sort by. After inserting a new row and re-titling each column,
when I go to sort now the default comes up "No Header Row" and I have to
switch it back to "Header Row". Is there something I can do to get it to
default back to "Header Row" like it was before I messed it up?

 

[Dave Peterson]

Excel likes to see something different that distinguishes the header row. One
easy fix is to bold that header row.

 

[Myrna Larson]

Try changing the format of the header row: make it bold or italic, add a
border, etc.

 

[Guest]

Thanks Myrna and Dave but unfortunately neither of your suggestions worked.
I tried it a couple of times and a couple of different ways based on both
your thought processes and the result is still the same. I can't thank you
enough for all your help!!!

 

[Guest]

I found out why the problem was happening. I had included a "Link" to
another file in the title bar which precluded the sort from defaulting to
"Header Bar".