Header/Wrap Text

[Pat]

I wondered if you could help me with a few things in
Excel:

Is it possible to put a header on the first two pages of
a 3-page spreadsheet?
Also I have "wrap text" setting in all my cells, but in
one cell -- it only prints two-thirds of the text no
matter how big an area I make for it. I have retyped
the remaining text several times and the Wrap Text box is
checked. Do you know why that would happen? Is there
some sort of limit as to how many characters you can have
in a field?

Thanks so much for your help.
Pat

 

[Frank Kabel]

Hi
1. For a header change within one change you'll need VBA. See:
http://www.rondebruin.nl/print.htm#Header

2. The limit is 1024 characters. You can extend this by manually
inserting line breaks with ALT+ENTER