Excel print rows at bottom

Is there a way to print rows at bottom for every page in Excel, and at the same time have this dictate where the page breaks show up.

A little shy on information that is.

Hi. There is not more information I can give. With Excel there is the option to select which rows are printed on every page (Page Layout, Page Setup, under Sheet tab, Rows to repeat at top). But there is no option for rows at bottom. I would say it may be possible to do this using VBA. But there is the added complexity that page breaks (blue dashed lines) should take this into account so that you know where one pages finishes and the next starts. Repeat: so that you know where one page finishes and the next one starts, this is the difficult bit I think.

Attachment 625875

Can't open your attachment. Use the "Go Advanced" button, select "Manage Attachments", "Choose File" and click on "Upload". Close that Window.

Please Login or Register  to view this content.

Maximum amount of Characters for all three Footers (Left, Center and Right) combined is 255.
One other way is to insert the needed Rows every n Rows and set the Pagebreak below the inserted Rows.

Hi. Thanks for responding, I'll give the latter a try.

I have not tried that but if you do find a solution, would you be so kind and post it here please.
If I have some time, I'll see if I can get something workable going.

Hi. I think it will be very difficult to achieve to be honest. I have pretty much given up on this one.

I have been playing with it a little.
Attached is the raw, very raw, workbook so far.
Maybe it is a start for you.

@jolivanes. Thanks for the workbook.

This might be more like it. That is if you're still looking at data from a different sheet as footer data.

@jolivanes. Thanks for spending time on this again.
Don't want to be rude but what I'm trying to achieve looks to be too difficult, which is to have the page breaks automatically show as you are working. Then you know where each page starts. I think I tried to convey this in post #1 and #3.
I think others will find your work useful though.