How to Print Repeating Header and Footer Rows in Excel
Question details
Print invoice data across multiple Excel pages with the first five rows and last five rows appearing on every page.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An invoice has changing data in cells B13:H100 or beyond, with a five-row header and a five-row footer needed on each printed page.
- Observed behavior
- Excel can repeat header rows through Print Titles, but it does not directly repeat worksheet rows at the bottom of every printed page.
Identify the five header rows, five footer rows, and the source data range. Check the paper size and margins in Page Layout so you can determine how many data rows fit between the header and footer.
Print invoice pages from a reusable Excel template
Use a one-page template when both the header and footer must contain worksheet rows on every printed page.
Excel has no Print Titles setting for repeating worksheet rows at the bottom of each page. A template places the footer inside each separately printed page instead.
This example allows up to 45 data rows per page. Reduce that number if the content becomes too small or does not fit on the selected paper.
Add a worksheet and place the five header rows in rows 1–5 and the five footer rows in rows 51–55. Leave rows 6–50 for invoice data, and format the columns and row heights as needed.
Select the full template, such as A1:H55, then choose Page Layout > Print Area > Set Print Area. Use Page Layout settings to choose the paper size and margins.
Copy the first data block, such as B13:H57, from the source sheet. Select B6 on the template and use Paste Special > Values to fill the data area without replacing its formatting.
Open File > Print and check that the template fits on one page and the footer is visible. Adjust margins, row heights, or scaling if needed, then print the page.
Clear the contents of B6:H50 on the template, paste the next source block, such as B58:H100, into B6, and print again. Repeat for any additional data blocks.

Repeat header rows and use a standard Excel footer
Use Print Titles when the top five worksheet rows must repeat and the bottom of each page only needs text, page numbers, or other standard footer content.
Work with invoice spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open existing Excel files, work with invoice templates, and move between office suites with compatible formats.

Frequently Asked Questions
Can Excel repeat the last five worksheet rows at the bottom of every page?
No. Page Layout > Print Titles repeats rows at the top, not worksheet rows at the bottom. Use a one-page template with the five footer rows included, then print each data block separately.
How do I repeat the first five rows on every Excel printout?
Go to Page Layout > Print Titles and enter $1:$5 in Rows to repeat at top. Select OK and check the result under File > Print.
Can I put a page number in the footer instead of repeating footer rows?
Yes. Open Page Layout > Page Setup, select the Header/Footer tab, and use Custom Footer to insert a page number. This creates footer content outside the worksheet grid.
What if 45 invoice data rows do not fit on one printed page?
Check File > Print preview and adjust the paper size, margins, row heights, or scaling under Page Layout. If the content is too small or still spills onto another page, use fewer data rows per template page.




