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

[Steven]

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?

[Myrna Larson]

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

On Fri, 8 Apr 2005 15:19:04 -0700, Steven <[email protected]>
wrote:

>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.


Steven wrote:
>
> 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

[Steven]

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!!!

"Dave Peterson" wrote:

> Excel likes to see something different that distinguishes the header row. One
> easy fix is to bold that header row.
>
>
> Steven wrote:
> >
> > 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
>

[Steven]

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".

"Steven" wrote:

> 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?