How to Repeat Grouping Rows on Horizontal Overflow Pages in Excel
Question details
The user wants to know how to repeat specific grouping rows only on the horizontal overflow pages corresponding to each section when printing in Excel.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Printing wide Excel reports containing different grouped sections that spill over horizontally onto multiple printed pages.
- Observed behavior
- Excel's native Print Titles feature repeats the selected rows or columns globally on every printed page, but it does not support dynamically changing the repeating rows to match different groupings on their specific horizontal overflow pages.
Before printing wide reports, ensure you have set your paper orientation to Landscape and minimized your margins in the Page Setup menu to fit as much data on a single page as possible.
Use Separate Print Areas for Different Groupings
Since Excel cannot dynamically change repeating rows per page during a single print job, you can define separate print areas for each section and print them individually with their own settings.
This workaround requires printing your report in batches. By isolating each group, you can assign specific rows to repeat at the top for that particular print job, ensuring the horizontal overflow pages have the correct headers.
Highlight the range of cells belonging to your first grouping section that you want to print.
Navigate to the Page Layout tab on the ribbon, click on Print Area, and select Set Print Area.
Click on Print Titles in the Page Layout tab. In the Page Setup dialog box, select the specific grouping rows for this section in the 'Rows to repeat at top' field, then click OK.
Press Ctrl + P to print this specific section. Once finished, repeat these steps for the next grouping section in your report.

Use Global Print Titles for the Entire Worksheet
If having a single, universal header across all overflow pages is acceptable, use the native Print Titles feature to apply the same repeating rows to every printed page.
Restructure the Report Layout
Modify your dataset layout to grow vertically rather than horizontally, preventing the need for complex horizontal overflow management.
Experience Seamless Page Layout and Printing with WPS Spreadsheets
While managing complex horizontal overflow in Excel can be challenging due to native software limitations, WPS Office offers a highly compatible and free alternative. Enjoy a familiar interface with robust page setup tools to streamline your spreadsheet printing tasks.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open your Excel file: Launch WPS Spreadsheets and seamlessly open your existing .xlsx workbooks without losing formatting.
- 3. Manage Print Settings: Navigate to the Page Layout tab to easily configure Print Areas, Margins, and Print Titles for your reports.

Frequently Asked Questions
Why do my Excel columns spill over to another page when printing?
This occurs when the total width of your columns exceeds the physical paper width and margin settings. You can fix this by changing the paper orientation to Landscape, adjusting margins to Narrow, or selecting 'Fit All Columns on One Page' in the Print scaling settings.
Can I set different Print Titles for different sheets in the same workbook?
Yes, Print Titles are configured on a per-sheet basis. You can click on each sheet tab individually, navigate to Page Layout > Print Titles, and set specific repeating rows or columns for that particular worksheet.
Is there a way to force a page break before a new group starts?
Yes. Select the entire row where you want the new printed page to begin, go to the Page Layout tab, click on Breaks, and select Insert Page Break. This ensures the new group starts cleanly at the top of a printed page.




