Insert an Excel Page Break Every 39 Rows
Question details
Set up an Excel worksheet with a horizontal page break after every 39 rows.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet needs to be printed in blocks of 39 rows, using manual page breaks or a repeatable macro.
- Observed behavior
- Printed pages should begin at rows 1, 40, 79, and subsequent 39-row intervals.
Identify the last row you want to print and check Page Layout > Print Area to make sure it includes those rows. Make sure 39 rows fit on a page with the selected paper size, margins, and scaling.
Insert page breaks manually after every 39 rows
Use this method for a short worksheet or when you only need to set the breaks once.
Click cell A40. Excel inserts a horizontal page break above the selected cell.
Select Page Layout > Breaks > Insert Page Break to place a break after row 39.
Select A79 and insert another break. Continue with A118, A157, and other rows spaced 39 apart until you reach the end of the print area.
Open View > Page Break Preview or File > Print to inspect the page boundaries. If needed, adjust Page Layout > Margins, Orientation, or Scale to Fit.

Add page breaks every 39 rows with a VBA macro
Use this method in desktop Excel when you need to repeat the layout across a long worksheet.
Set 39-row print breaks in WPS Spreadsheet
Open your worksheet in WPS Spreadsheet and insert horizontal page breaks above each row where a new printed page should begin.
- 1. Open the worksheet: Open WPS Spreadsheet and use Open to select your Excel workbook.
- 2. Select the break row: Click cell A40 to position the first horizontal break above row 40.
- 3. Insert and repeat: Choose Page Layout > Breaks > Insert Page Break. Repeat at A79, A118, and each subsequent 39-row interval.
- 4. Preview the printout: Open Print Preview and check the page boundaries. Adjust the print area, margins, or scaling in Page Layout if needed.

Frequently Asked Questions
Which row should I select to insert a break after row 39?
Select cell A40, then choose Page Layout > Breaks > Insert Page Break. The horizontal break is inserted above row 40.
Why is Excel printing fewer than 39 rows on a page?
An automatic break may be needed because the rows do not fit. Check paper size, margins, orientation, row heights, and scaling under Page Layout, then review File > Print.
How can I see where the page breaks are?
Choose View > Page Break Preview to see page boundaries, or open File > Print to review the printed pages.
How do I remove a manual page break?
Select a cell immediately below the horizontal break, then choose Page Layout > Breaks > Remove Page Break. To remove all manual breaks, choose Reset All Page Breaks from the same menu.
Can repeated print titles affect the 39-row layout?
Yes. Rows repeated at the top of each printed page use space. Check Page Layout > Print Titles and verify in Print Preview that each intended block fits.




