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?

--
Stuart

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

"Stuart" wrote:

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?

--
Stuart

File/Page Setup/ Page:
Rows to repeat at top.
--
David Biddulph

"Stuart" wrote in message
...
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?

--
Stuart

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

"Chiccada" wrote:

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

"Stuart" wrote:

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?

--
Stuart

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 FilePage Setup


Gord Dibben MS Excel MVP

On Thu, 1 Nov 2007 14:52:02 -0700, Melissa
wrote:

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

"Chiccada" wrote:

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

"Stuart" wrote:

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?

--
Stuart

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

"Gord Dibben" wrote:

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 FilePage Setup


Gord Dibben MS Excel MVP

On Thu, 1 Nov 2007 14:52:02 -0700, Melissa
wrote:

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

"Chiccada" wrote:

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

"Stuart" wrote:

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?

--
Stuart

Good to hear.

Thanks for the feedback.

On Sun, 4 Nov 2007 19:58:01 -0800, Melissa
wrote:

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

"Gord Dibben" wrote:

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 FilePage Setup


Gord Dibben MS Excel MVP

On Thu, 1 Nov 2007 14:52:02 -0700, Melissa
wrote:

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

"Chiccada" wrote:

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

"Stuart" wrote:

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?

--
Stuart