Repeat Header and Footer Rows on Every Printed Excel Page
Question details
The user wants selected top and bottom worksheet rows to appear on every printed page.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Printing a multi-page worksheet with repeating header rows and footer-like content.
- Observed behavior
- Excel can repeat rows at the top through Print Titles, but it does not automatically repeat arbitrary worksheet rows at the bottom of every page.
Identify the rows to repeat at the top and decide whether the bottom content can be entered as a static footer. Check the intended print range and page layout before adjusting page breaks.
Repeat top rows and add a static page footer
Use this approach when the bottom content can be entered as the same footer on every page.
Excel's Print Titles feature repeats worksheet rows at the top, not at the bottom. A custom footer appears in the page footer area rather than as worksheet cells and does not automatically stay synchronized with the bottom rows.
Select the worksheet, then go to Page Layout > Print Titles.
On the Sheet tab, click Rows to repeat at top and select the worksheet rows to repeat, such as $1:$3.
In Page Setup, open the Header/Footer tab and click Custom Footer. Enter the required text in the left, center, or right section, then click OK.
Click OK to close Page Setup, then open File > Print and review the print preview to confirm the top rows and footer appear as intended.

Manually repeat bottom sections for each printed page
Use repeated worksheet sections when the bottom content needs to remain in cells or differ from page to page.
Work with printable spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and review their print layouts while moving between Office applications. It does not fix Excel's limitation on repeating arbitrary bottom rows.

Frequently Asked Questions
Can Excel repeat worksheet rows at the bottom of every printed page?
No. Page Layout > Print Titles provides rows to repeat at the top, but it does not provide an equivalent setting for arbitrary bottom rows. Use a static footer or manually repeated worksheet sections instead.
How do I repeat column headings on every printed page?
Go to Page Layout > Print Titles. On the Sheet tab, select the heading rows in Rows to repeat at top, then click OK and check File > Print.
Can a custom footer automatically show the contents of worksheet cells?
A custom footer entered through Page Setup > Header/Footer does not automatically synchronize with a worksheet range. Update the footer manually when its source content changes.
How can I make the bottom content different on each page?
Create separate report sections with the appropriate bottom rows, then use View > Page Break Preview to adjust page boundaries. For recurring reports, VBA can generate sections and page breaks.




