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

TheBramble

Legendary member
Messages
8,394
Likes
1,170
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
 
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
 
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
 

Attachments

  • Excel Header.gif
    Excel Header.gif
    23.1 KB · Views: 2,061
Top