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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Excel likes to see something different that distinguishes the header row. One
easy fix is to bold that header row.
 
Try changing the format of the header row: make it bold or italic, add a
border, etc.
 
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!!!
 
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".
 
Back
Top