Make sure you don't have wrap text turned on, too.

And if your header is a number, precede it with an apostrophe or preformat the
cell as text.



Rick wrote:

I have created a four cell header on a worksheet. I entered the title of the
header in the second cell expecting it to carryover into the third cell but
it didn't, nor can I figure out how do it. On other cells it carries over
fine. I tried formatting the cell to general but that didn't work.
Suggestions please. Thanks, Rick

--

Dave Peterson