Repeating Rows during Print (2000)

Topic

New Reply

I have a user who has a 10 page excel spreadsheet. She wants the first row to print on every page EXCEPT the last page. Is there any way to “suppress” the “Rows to repeat at top” on the last page?

Reply | Quote

Replies

Well, here’s a kind of klutzy but effective way to do it. Have your user create two print areas and store each of them as Views. The first print area can be stored with the repeating rows and the second print area can be stored without the rows. Then use Report Manager to create a print report that will print both print areas in a single report (even with consecutive page numbers, if the user wishes). The thing to remember about using Views is that when you store a print area you also store the page setup settings, so it is necessary to make sure the user first defines the print area correctly, then correctly sets the page setup settings, before saving as a View.

Hope this helps.

Reply | Quote