Printing Problems

How to Print One Excel Row Per Page with Repeated Headers

Steve K Oct 15, 2026 869 views

Question details

The user needs to print a lengthy Excel worksheet so that each printed page contains exactly one row of data along with a repeated header row.

How to Print One Excel Row Per Page with Repeated Headers

Product: Excel
Device & OS: not provided
Scenario: Printing a large dataset where individual row data needs to be isolated on separate pages for readability or distribution, while ensuring the column headers remain visible on every page.
Observed behavior: The user wants to achieve a specific print layout where the header repeats on every page, and only a single data row follows it per printed page.

Before you start

Before adjusting your print settings, ensure your spreadsheet has clearly defined header rows and that your printer is connected and turned on.

Solution 1Recommended

Adjust Print Margins and Repeat Header Rows

Use the Page Setup settings to force one row per page by increasing the top and bottom margins, alongside repeating the header.

By manipulating the top and bottom page margins, you can restrict the available printable area on each page. This forces Excel to push subsequent rows onto the next page, naturally creating a one-row-per-page layout without altering your original dataset.

Set rows to repeat at top

Navigate to the Page Layout tab on the ribbon, click on 'Print Titles', and in the 'Rows to repeat at top' field, select your header row(s).

Open Page Setup margins

Still in the Page Layout tab, click on 'Margins' and select 'Custom Margins' at the bottom of the drop-down menu.

Increase top and bottom margins

In the Margins tab of the Page Setup dialog, significantly increase the Top and Bottom margins so that only the header and a single row of data can physically fit on one printed page.

Verify in Print Preview

Click the 'Print Preview' button in the dialog box to check your layout. Adjust the margin sizes slightly up or down until exactly one data row appears per page.

Adjust Print Margins and Repeat Header Rows

Check Before Printing: Always verify the layout using Print Preview before sending the document to the printer. This prevents wasting paper if the margin values need further tweaking.

Solution 2

Insert Page Breaks Using the Subtotal Feature

Utilize Excel's Subtotal tool to automatically insert page breaks between every single row in your dataset.

Efficient Spreadsheet Printing

Print Spreadsheets Easily with WPS Office

WPS Spreadsheet provides intuitive page layout tools, allowing you to easily set print areas, repeat headers, and manage page breaks for customized printing needs without complex workarounds.

1. Open your file in WPS: Launch WPS Spreadsheet and open your existing workbook.
2. Define repeated headers: Go to the Page Layout tab and click on 'Print Titles' to select your repeating header row.
3. Adjust margins: Use the 'Page Setup' dialog to increase the top and bottom margins, constraining the printable area to a single row.
4. Preview and print: Click 'Print Preview' to verify that exactly one data row and the header appear on each page, then click Print.

Free and lightweight office suiteFully compatible with Microsoft Excel (.xlsx) formatsIntuitive Print Preview and Page Layout controls

microsoft office alternative - wps office

Frequently Asked Questions

Can I manually insert page breaks instead of changing margins?

Yes, you can manually insert a page break below each row. Select the row below where you want the break, go to the Page Layout tab, click Breaks, and choose Insert Page Break. However, this can be time-consuming for lengthy worksheets.

Why is my header not repeating on every printed page?

Ensure you have selected the correct rows in the 'Rows to repeat at top' field within the Page Setup dialog. If you only freeze the top row in the normal view, it will not automatically apply to printed pages.

Will the Subtotal method alter my original dataset?

Yes, the Subtotal feature groups your data and adds summary rows between your original data rows. If you do not want these summary rows, it is safer to use the margin adjustment method.

Document & File Issues