Conditional page break position

Occasional Visitor



Is it possible to set page breaks in Excel to automatically adjust to a specific row/column depending on which rows/columns are visible (so not hidden) at the time? I cannot seem to make this work. 


I have a spreadsheet with over 300 rows of data, and VBA code that hides none relevant rows each time data is entered. However I then need to manually adjust the page breaks if I need to save as a PDF or print, and I'm just trying to automate that process if possible. 


I'd rather not write more VBA code if I don;t have to, so just reaching out to the community for any expertise / tips please. 



1 Reply

@DHR1982, I am struggling with a similar same problem. I have tables with about 1000 lines and I want to introduce a page break between groups with up to 40 lines each. Everything should be dynamic. I would love to see page breaks in conditional formatting. For now I can share my work around:

Lets say Table1 is the Table that I want to split over multiple pages. In a new sheet I insert the following formula:


 The idea is that each page will have the same number of rows (49). So it does not work if there are cells with line breaks.


Is there a better way to do this?