Problem with 'Rows to repeat at top'

[Dorre]

I am printing an Excel Worksheet table using the 'Rows to repeat at top'
feature found in 'Page setup...'. The table is usually 30 to 60 pages long,
and this gives me the same column headings on each page.

Here's my problem. Below this table is another one, but I no longer want
the 'Rows to repeat at top' feature. Can I turn it off part way through the
printing of a document? I'd rather not use another worksheet for the second
table.

Thanks in advance for any assistance
Bri

 

[R. Choate]

No, you cannot turn the setting off mid-print. You could seperate it into 2
print jobs, one with and one without the header rows, but once you hit
print, the job is all or nothing.
--
RMC,CPA


I am printing an Excel Worksheet table using the 'Rows to repeat at top'
feature found in 'Page setup...'. The table is usually 30 to 60 pages long,
and this gives me the same column headings on each page.

Here's my problem. Below this table is another one, but I no longer want
the 'Rows to repeat at top' feature. Can I turn it off part way through the
printing of a document? I'd rather not use another worksheet for the second
table.

Thanks in advance for any assistance
Bri