EXCEL: First 2 Rows Needed as Header on Every Printed Page

[TheBramble]

Is this possible?

I know you can opt for row & col to be printed and you can set up a custom heading, but I have Rows 1&2 with a complex set of heading which I'd like replicated on each printed page.

TIA

 

[FetteredChinos]

go to page setup

then click the "sheet" tab.

et voila, there is a box saying "rows to repeat" at top of page..

that'll be £50 , Tone.

FC

 

[Trader333]

Tony,

Go to "File" and select "Page Setup" then select the tab that says "Sheet" and you have the option to select "Rows to Repeat at Top" and then select the rows you want as shown is the attached image.


Paul

 

[FetteredChinos]

now now Paul, using images is just showing off...

 

[TheBramble]

Thank you both - especially Paul for the extra trouble he took.....