headers

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

headers in worksheet 4
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Access Sorting and grouping using multiple tables 0
Data Filter drop down 3
VLookup for multiple values!! 3
Macro to Compile Data from Different Sheets 2
del certain rows based on word search 2
access 2002 report header 5

Top