headers

A

aamir

I want to make the first say 8 rows of the first page of a larger sheet to
become the header. Presently they are a part of the main text or cell
information. Aftermaking the header with these, I do not want them any more
in the main body of the sheet. Can you help?

2.Then can I make this new header appear on all the pages?

In your response please give in easy steps?
Thank you
Aamir
 
G

Gord Dibben

The header will contain only 255 characters maximum so making a header(which
would have to done via VBA) from 8 rows seems excessive.

Check out File>Page Setup>Sheet>Rows to repeat at top.

As far as these rows not being in the main body, you cannot delete or hide them
and have them remain as rows to repeat.


Gord Dibben MS Excel MVP
 
Top