Excel - Discover Better Solutions for Setting Page Breaks Every 35 Rows - Episode 360

3,570 views · Published 4 November 2009 · 3:38 · Indexed 8 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Discover Better Solutions for Setting Page Breaks Every 35 Rows.

Welcome to another episode of the MrExcel netcast, where we tackle Excel problems and find the best solutions. Today, we have a viewer who called in with a question about setting up page break intervals of 35 rows. This can be a tricky task, and I'm not sure I have the best solution, so I'm opening it up to all of you to see if anyone has a better approach.

The first method I tried was to simply adjust the bottom margin in the Page Setup menu until the page breaks were at the desired interval. However, this feels like cheating and doesn't really solve the problem in the way our viewer was hoping for.

Next, I tried using the NA function to create a column of #N/A values every 35 rows, and then using the Go To Special feature to select all the error cells and insert page breaks. But unfortunately, this only inserts a page break in the upper left-hand cell, not the entire row.

My next solution is a bit convoluted, but it gets the job done. I created a temporary column and used a formula to increment the number every 35 rows. Then, I used the Data Subtotals feature to add page breaks between each change in the temporary column. While this works, it's not the most efficient or elegant solution.

So, I'm turning to all of you for help. If you have a better way to put a page break every 35th row, please leave a voicemail at 866-581-0221. We'll feature your idea in an upcoming netcast and give you credit for the solution.

Thanks for tuning in and don't forget to subscribe to our channel for more Excel tips and tricks. Let's see if we can find a better way to solve this problem together!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Introduction
(00:18) Viewer call in for page break solution
(00:28) First attempt: changing margins
(00:45) Second attempt: using NA function
(01:10) Third attempt: using temporary column and formulas
(02:30) Final solution using Data Subtotals trick
(03:04) Call for better solutions from viewers
(03:14) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Alternative methods for setting page breaks every 35 rows
Contact information to leave a voicemail with ideas
Deleting columns in Excel
Editing formulas in Excel
Go To Special feature in Excel
How to insert temporary columns in Excel
Inserting page breaks in Excel
Joining a netcast next week to learn better solutions
Tips for changing page setup in Excel
Using subtotals in Excel
Using the NA function in Excel
YouTube video on setting up page break intervals


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152729/


Today on Episode 360, a viewer question stumps MrExcel. Well, there are two solutions in the podcast, but like you, I have to believe there is a better way. The question is how to add a page break every 35 rows. If you know a better way to do this, leave a message at 866-581-0221.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

A video with a faster way is published in 2021: https://youtu.be/5qCYfHflnKE

More from this channel