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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920