How to Automatically Create a Second Printed Page with Headers in Excel
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.

- 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 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.
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.
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.
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'.
Highlight the entire data range you wish to print across all pages. Go to 'Page Layout' > 'Print Area' and click 'Set Print Area'.
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.

Move Overflow Data to a New Sheet Using Formulas or VBA
If your goal is to physically move data to a separate worksheet after a certain number of rows rather than just adjusting the printed output, you must use formulas or macros.
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. Open Your Workbook: Launch WPS Spreadsheet and open your material order form document.
- 2. Access Print Titles: Navigate to the 'Page Layout' tab and click the 'Print Titles' button.
- 3. Select Header Rows: In the 'Rows to repeat at top' field, highlight your header rows and click 'OK'.
- 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. Preview and Print: Click the Print Preview icon to verify your headers are repeating on the second page seamlessly.

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'.




