Repeat Excel Table Headers and Columns on Printed Pages
Question details
The user wants to repeat a table's headers and selected columns on printed Excel 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.
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.
Use Print Titles to repeat header rows and worksheet columns
Use this method when repeating entire worksheet rows or columns meets your needs.
On the worksheet, select Page Layout > Print Titles.
In Rows to repeat at top, select the table's header row, such as $8:$8.
In Columns to repeat at left, select the worksheet columns you want repeated, such as $A:$C, and click OK.
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.

Create a linked print-layout sheet for selected table columns
Use a separate layout when the source worksheet columns contain other content you do not want to repeat.
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.

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.




