Sorry - misinterpreted what you meant by header.

You can put it in the header using code such as Gordon provided (as
corrected).

Or you can try using rows to repeat at top in the last tab of the page setup
dialog.


--
Regards,
Tom Ogilvy


Sandy wrote in message
...
Dear Tom:

Thanks for your reply. I mean that I have text in Cell A1
and text in Cell A2. I would like that text to display in
the Header of each printed sheet.

Sandy

-----Original Message-----
If you mean in the gray labels, no. You can make them
(A1 and B1) look
similar to labels using formatting and hide the labels,
but I am not sure of
the utility of that.

Regards,
Tom Ogilvy

Sandy wrote in message
...
I would like to put the contents of A1 and B1 into the
header. A1 and B1 are not names of columns.

Is there a way to do this? I came up with zip when
searching Help.

Sandy


.