Printing more then one row at top of each page

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top