Printing Problems

Insert an Excel Page Break Every 39 Rows

Muhammad TalhaMuhammad Talha Nov 18, 2026 870 views

Question details

Set up an Excel worksheet with a horizontal page break after every 39 rows.

How to Insert an Excel Page Break 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.
Before you start

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.

Solution 1Recommended

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.

1
Select the first break row

Click cell A40. Excel inserts a horizontal page break above the selected cell.

2
Insert the break

Select Page Layout > Breaks > Insert Page Break to place a break after row 39.

3
Repeat at each interval

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.

4
Check the pages

Open View > Page Break Preview or File > Print to inspect the page boundaries. If needed, adjust Page Layout > Margins, Orientation, or Scale to Fit.

Insert page breaks manually after every 39 rows
Check scaling: Fit-to-page scaling can override manual page breaks. Use an Adjust to percentage scaling setting if you need Excel to honor them, and make sure each 39-row block fits on a page.
WPS Spreadsheet

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. 1. Open the worksheet: Open WPS Spreadsheet and use Open to select your Excel workbook.
  2. 2. Select the break row: Click cell A40 to position the first horizontal break above row 40.
  3. 3. Insert and repeat: Choose Page Layout > Breaks > Insert Page Break. Repeat at A79, A118, and each subsequent 39-row interval.
  4. 4. Preview the printout: Open Print Preview and check the page boundaries. Adjust the print area, margins, or scaling in Page Layout if needed.
Insert page breaks at 39-row intervals for a consistent print layout.Open and edit Microsoft Excel XLSX and XLS files.Preview the printed worksheet and adjust its page settings.Use a familiar spreadsheet interface for everyday editing.
microsoft office alternative - wps office

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.