Printing more then one row at top of each page

G

Guest

when a document is more than one page and I have more then one row of
discriptions at the top, how do I get them to print on each page? I know if
I have only one row the comand is exp: a1..a7 but what is it is a1..a7 and
a2..a7? How do I do this. Thank you.
 
G

Guest

Unless you need to accomplish with code, I'd just use the File...Page Setup
(Sheet tab)...then use "Rows to Repeat at Top". Just click the little icon
at the right and highlight the rows you want repeated in each page.

And even if you do need to use code, you can easily record a macro to do this.
 

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

Top