Multi Page Header Row For Reports

[Guest]

i have a report for jobs that have been onsite for more than 2 days without
an estimate, this report can often be several pages long, while onscreen i
use freeze panes to keep the headers visible all the time when scrolling it
doesnt help me when i have to print the document for my colleagues, when i
print for my colleagues i want it to print this header row on every page of
the spreadsheet without me having to manually paste it in each time, i
beleive theres a way to do this in excel but dont know how, can someone tell
me how you do this please?

 

[Guest]

Hi Stuart,

You need to go into the page setup and select the 'sheet' tab.

Under the print titles section you will see an option called 'Rows to repeat
at top'.
Add in the row you wish to repeat and presto.

Regards,

Rikki

 

[David Biddulph]

File/Page Setup/ Page:
Rows to repeat at top.

 

[Guest]

I have Excel 2007 and am unable to change anything in the field 'Rows to
repeat at top.' Any suggestions?

 

[Gord Dibben]

If 2007 works same as earlier versions you cannot make changes to this feature
while in PrintPreview mode.

Is that the case?

Go in from File>Page Setup


Gord Dibben MS Excel MVP

 

[Guest]

You're right, I tried it in Page Setup and it worked. Thanks for the help!

 

[Gord Dibben]

Good to hear.

Thanks for the feedback.

You're right, I tried it in Page Setup and it worked. Thanks for the help!