You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to insert automatic PageBreak in Excel Template?

Hello everyone,

We found various notes an treads about Excel template "PageBreak" to split outputs in multiple pages, but our need is to insert a page break in order to control printed excel outputs.

Instead of doing the formatting on the output, we do need to embed it into the template.

In this example, we've this excel template for MinMax Report and where data is displayed for each item (between the 2 red dots).

As you can see there are different parts that display multiple rows (2 blue dots). Then this block might/might not fit in one page before fetching for another item.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!