Repeating Rows @ bottom when printing

Not that I know of, but you can fake it by using a custom left footer. You are limited to 255 characters.

Thanx anyway Barry, I didn't think there was.
I've got too many characters to fake it.
Oh well back to the drawing board!

Hello Moonie:

You might try creating gif or jpg (or any picture file) with the text or info you want, adjusting the height of the gif file with the gif editor to suit your needs. Then inserting the picture file in the footer or header of your file (on Excel 2002 anyway). Then adjusting the position of the footer (distance from the bottom of the page) in the print set up section. I have not tried it but its work a try.


plettieri

Just to maintain the never-say-die spirit I offer a tedious solution:

1. Define the Print_Area, select and paste values to a new sheet.
2. Set Headers, Footers etc for the new sheet.
3. Add a macro to insert the required repeating rows after every n rows.

Thanks guys, some good ideas there!

...or, just set rows at the top to print your text at the top of each sheet, and hand them out upside down.

I have one more suggestion:

Assume that your data to be printed is in Sheet1, beginning with A1

Assume that your repeating text for the bottom of each page is named `Footer1'

Assume that you want 20 rows of data in Sheet1 to be printed on every page.

In Sheet2, this formula can be entered in cell A1

=IF(MOD(ROW(Sheet1!A1),21)=0,Footer1,INDIRECT(ADDRESS(ROW()-INT(ROW()/20),1,,,"Sheet1")))

and copied down.

Note:
replace Footer1 and 21/20 with actual requirement.

formula can be copied across columns, with Footer1 replaced with something appropriate like - "", or other named range

formula to be modified, if there is more than one repeating row.

page breaks to be inserted every 21st(actual) row. This can be done by a simple macro.