insert page breaks by condition

[szahner]

Have customer numbers in column A listed contiguously in a number of rows, need to insert page breaks after the last entry of each customer number automatically (as there are more than 100 customers)

5996
5996
5996
page break
5991
5991
5991
5991
page break
7895
7895

 

[Oaktree]

Welcome to the board.

Try selecting your column and going to data --> subtotals and checking "Page breaks between groups"

If you don't want the subtotals in there, you can going to outline view 2 (to the left of the A in the column headings), select your subtotals, press ALT + ; (to select visible cells), and press delete.

You'll technically have a blank line at the bottom of each page, but it should be cosmetically equivalent when you print.

 

[szahner]

Worked perfectly, thank you so much!