excel printing

[hyewiz]

Hello

I need your expertise about printing long pages
I have prepared an template with basic formula what i like to have is when I print long pages which will automatically prints in multiple pages to keep the style like the borders the logo and the sections, bellow is a small preview what the style looks like please help me out.

 

[Andrew Poulsom]

In Page Setup, Sheet tab you can set the 'Rows to repeat at top', if that's what you mean.

 

[hyewiz]

Thanks for fast reply, I tried that it works great but i need the whole style to show
for example the last row has thick border as finish, bellow is a full page

 

[Andrew Poulsom]

You would have to add a thick border at each page break.

 

[hyewiz]

I tried that and its not the same sorry

 

[Andrew Poulsom]

In what way isn't it the same?

 

[hyewiz]

I have managed to bring as close as what i wanted but now i have realized
the formula is not moving along to the second page, I have to copy down couple of pages, but then, by doing that when I come to print lets say 2 pages i need to specify page numbers otherwise it thinks all the data that I copied down they are pages