Printing Problems

How to Automatically Create a Second Printed Page with Headers in Excel

Steven ParkerSteven Parker Nov 11, 2026 870 views

Question details

The user needs a material order form to automatically continue onto a second printed page with the same headers once the first page reaches its capacity.

How to Automatically Create a Second Printed Page with Headers in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Printing a long order form or dataset that spans multiple pages and requires consistent header context on every printed sheet.
Observed behavior
Excel prints continuous data on subsequent pages but does not automatically repeat headers or move overflow data to separate worksheets without specific layout configurations or advanced automation.
Before you start

Before adjusting your print settings, ensure your dataset is finalized and decide whether you simply want to print multiple pages with repeated headers, or if you actually need to physically move overflow data to a new worksheet tab.

Solution 1Recommended

Repeat Headers on Multiple Pages Using Print Titles and Page Breaks

The most effective way to ensure your order form headers appear on every printed page is to use Excel's Print Titles feature combined with manual page breaks.

While Excel does not automatically transfer overflow data to a new sheet, it can seamlessly print continuous data across multiple pages while keeping the top header rows visible.

1
Set Rows to Repeat

Navigate to the 'Page Layout' tab on the Excel ribbon and click on 'Print Titles'. In the Page Setup dialog box, click into the 'Rows to repeat at top' field, then select the row or rows containing your material order form headers.

2
Insert a Page Break

Scroll down to the row where you want your first printed page to end. Select the entire row immediately below your desired cut-off point, go to 'Page Layout' > 'Breaks', and select 'Insert Page Break'.

3
Define the Print Area

Highlight the entire data range you wish to print across all pages. Go to 'Page Layout' > 'Print Area' and click 'Set Print Area'.

4
Preview the Document

Press 'Ctrl + P' to open the Print Preview screen. Scroll through the pages to verify that your headers are automatically generated at the top of the second page and beyond.

Repeat Headers on Multiple Pages Using Print Titles and Page Breaks
Header Visibility: Using Print Titles ensures the headers are physically printed on every page, which is different from 'Freeze Panes' (which only affects your on-screen view).
Print Spreadsheets Easily

Easily Manage Page Layouts and Printing in WPS Office

WPS Spreadsheet provides an incredibly intuitive Page Layout interface, allowing you to easily set print areas, insert page breaks, and automatically repeat headers across multiple printed pages.

  1. 1. Open Your Workbook: Launch WPS Spreadsheet and open your material order form document.
  2. 2. Access Print Titles: Navigate to the 'Page Layout' tab and click the 'Print Titles' button.
  3. 3. Select Header Rows: In the 'Rows to repeat at top' field, highlight your header rows and click 'OK'.
  4. 4. Insert Page Breaks: Select the row where the page should end, click 'Breaks' under the Page Layout tab, and choose 'Insert Page Break'.
  5. 5. Preview and Print: Click the Print Preview icon to verify your headers are repeating on the second page seamlessly.
Fully compatible with Microsoft Excel (.xlsx, .xls) formatsIntuitive Print Preview and Page Layout controlsEasily configure rows and columns to repeat on printed pagesFree, lightweight, and fast office suite
QA img-9

Frequently Asked Questions

Why are my frozen panes not printing on every page?

The 'Freeze Panes' feature is designed solely for on-screen navigation, keeping rows visible as you scroll. To make headers appear on printed pages, you must use the 'Print Titles' feature located in the Page Layout tab.

Does Excel automatically move overflow data to a new worksheet?

No, Excel will print overflow data onto a new printed page, but it will not physically move the cell data to a separate worksheet tab. Transferring data to a new sheet requires manual copying, complex formulas, or a VBA macro.

Can I set a maximum number of rows per printed page?

Yes. You can control exactly how many rows print per page by manually inserting Page Breaks below your desired maximum row limit via the 'Page Layout' > 'Breaks' menu.

How do I remove a manual page break I added by mistake?

Go to the 'Page Layout' tab, click on 'Breaks', and select 'Reset All Page Breaks'. Alternatively, select the row immediately below the page break and click 'Remove Page Break'.