Printing Problems

How to Print Repeating Header and Footer Rows in Excel

Ayan MasoodAyan Masood Nov 20, 2026 869 views

Question details

Print invoice data across multiple Excel pages with the first five rows and last five rows appearing on every page.

How to Print Repeating Header and Footer Rows in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Create the template

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.

2
Set the print area

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.

3
Fill the first page

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.

4
Preview and print

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.

5
Print the remaining blocks

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.

Print invoice pages from a reusable Excel template
Automating multiple pages: A VBA macro can copy successive data blocks into the template and print each page. The manual method is useful when there are only a few pages or macros are unavailable.
Free Microsoft Office alternative

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.

Create and print invoice spreadsheets with a familiar interfaceOpen and save Microsoft Excel XLS and XLSX filesUse a free, lightweight office suite for everyday spreadsheet workBring existing office files into WPS Office for a smooth transition
microsoft office alternative - wps office

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.