Printing Problems

Repeat Excel Table Headers and Columns on Printed Pages

Huda QurayshiHuda Qurayshi Nov 20, 2026 868 views

Question details

The user wants to repeat a table's headers and selected columns on printed Excel pages.

Repeat Excel Table Headers and Columns on Printed Pages
Product
Microsoft Excel
Device & OS
not provided
Scenario
A table spans multiple printed pages, and its headers or identifying columns need to remain visible.
Observed behavior
Excel Print Titles repeats entire worksheet rows or columns, but cannot directly repeat only an arbitrary range such as A8:C100.
Before you start

Identify the table's header row, the columns to repeat, and the intended print area. Check File > Print to see how the table currently spans pages.

Solution 1Recommended

Use Print Titles to repeat header rows and worksheet columns

Use this method when repeating entire worksheet rows or columns meets your needs.

1
Open Print Titles

On the worksheet, select Page Layout > Print Titles.

2
Select the header row

In Rows to repeat at top, select the table's header row, such as $8:$8.

3
Select repeat columns

In Columns to repeat at left, select the worksheet columns you want repeated, such as $A:$C, and click OK.

4
Check the printout

Open File > Print and review the pages. If needed, select the table and use Page Layout > Print Area > Set Print Area to limit what is printed.

Use Print Titles to repeat header rows and worksheet columns
How repetition works: Header rows repeat on vertical page breaks, while columns repeat on horizontal page breaks. Print Titles selects full worksheet rows or columns, not just cells within a range.
Free Microsoft Office alternative

Work with printable spreadsheets in WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files and move your spreadsheet work to WPS with minimal disruption; it does not change Excel's Print Titles limitation.

Review and print spreadsheet layouts in WPS SpreadsheetsCompatible with Microsoft Excel formats, including XLS and XLSXFamiliar spreadsheet interface for an easier transitionFree and lightweight for everyday office work
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't my header appear on every printed page?

Check Page Layout > Print Titles and make sure the correct row is selected in Rows to repeat at top. Then use File > Print to review the pages.

Can I repeat only A8:C100 using Excel Print Titles?

No. Print Titles selects complete worksheet rows or columns. To repeat selected table content, arrange linked cells on a separate print-layout sheet and repeat its columns.

Why aren't my repeat columns visible on every page?

Columns selected under Page Layout > Print Titles repeat at the left of pages created by horizontal page breaks. Check File > Print to see how the table is split.

Will changes to the source table appear on a linked layout sheet?

Linked cell references update when their source values change. Check the references on the layout sheet if you move or restructure the source table.