Excel Guides

How to Use Conditional Page Breaks in Excel

Conditional page breaks can be a great way to control the flow of your data in an Excel worksheet. By using a simple formula, you can tell Excel where to start and end a new page. In this article, we'll show you how to use conditional page breaks in Excel.

The first thing you'll need to do is select the cell where you want the page break to appear. Then, go to the Insert tab and click on the Page Break button. This will insert a page break above the selected cell.

Now that you have a page break inserted, you'll need to add a formula to tell Excel when to start a new page. The formula should look like this:

=IF(ROW()-INT(ROW()/10)*10=1,TRUE,FALSE)

This formula will check the row number of the cell it's in and see if it's divisible by 10. If it is, it will return TRUE and Excel will start a new page. Otherwise, it will return FALSE and Excel will keep everything on the same page.

You can also use this same technique to insert page breaks at specific intervals. For example, if you want there to be a new page every 5 rows, you would use this formula:

=IF(MOD(ROW(),5)=1,TRUE,FALSE)

This formula will check the row number of the cell it's in and see if it's evenly divisible by 5. If it is, it will return TRUE and Excel will start a new page. Otherwise, it will return FALSE and Excel will keep everything on the same page.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.