Printing Problems

Repeat Header and Footer Rows on Every Printed Excel Page

Maira MehtabMaira Mehtab Nov 18, 2026 870 views

Question details

The user wants selected top and bottom worksheet rows to appear on every printed page.

Repeat Header and Footer Rows on Every Printed Excel 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.
Before you start

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.

Solution 1Recommended

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.

1
Open Print Titles

Select the worksheet, then go to Page Layout > Print Titles.

2
Select the top rows

On the Sheet tab, click Rows to repeat at top and select the worksheet rows to repeat, such as $1:$3.

3
Create the footer

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.

4
Check the printed pages

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.

Repeat top rows and add a static page footer
Footer content is separate from cells: If the source worksheet rows change, update the custom footer manually. A footer is not a substitute for repeating a formatted range of cells.
Free Microsoft Office alternative

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.

Review spreadsheet page layouts before printingCompatible with Microsoft Excel XLS and XLSX filesFamiliar interface for everyday spreadsheet workFree, lightweight option for working with Office documents
microsoft office alternative - wps office

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.