Printing Problems

How to Repeat Excel Column Headings on Every Printed Page

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to ensure that specific column headings automatically appear at the top of every printed page when printing a multi-page worksheet.

Product: Excel
Device & OS: not provided
Scenario: Printing a multi-page spreadsheet where header context is needed on every page for readability.
Observed behavior: By default, Excel only prints the column headings on the first page, leaving subsequent pages without data context.

Before you start

Ensure your printer is properly connected and your worksheet data is finalized before adjusting the print layout settings.

Solution 1Recommended

Use the Print Titles Feature to Repeat Rows

Configure the page setup to automatically print designated header rows at the top of every page.

Excel includes a dedicated page layout setting called Print Titles, which allows you to define specific rows and columns to repeat on every printed page. This prevents you from having to manually copy and paste headers throughout your document.

Navigate to Page Layout

Open your worksheet in Excel and click on the 'Page Layout' tab located in the top ribbon.

Select Print Titles

In the 'Page Setup' group, click on 'Print Titles'. If your Excel window is small and the option is difficult to find, maximize the window or use the ribbon search box to search for 'Print Titles'.

Define Rows to Repeat

In the Page Setup dialog box, click inside the 'Rows to repeat at top' field. Then, click on your worksheet to select the heading row or rows you want to repeat.

Confirm and Print

Click 'OK' to save the settings. You can now proceed to print your document, and the selected headers will appear on every page.

Use Print Preview: Always check the Print Preview (File > Print) before printing to verify that the headings are displaying correctly across all pages.

Seamless Spreadsheet Printing

Print and Manage Spreadsheets Easily with WPS Office

WPS Spreadsheet offers a highly intuitive Page Layout interface, making it incredibly simple to set print titles, adjust margins, and repeat column headings. It provides seamless compatibility with Microsoft Excel files, allowing you to format and print with zero hassle.

1. Open your worksheet: Launch WPS Spreadsheet and open your existing Excel file.
2. Go to Page Layout: Click on the 'Page Layout' tab located in the top menu ribbon.
3. Click Print Titles: Select the 'Print Titles' icon to open the Page Setup dialog box.
4. Select Heading Rows: Click in the 'Rows to repeat at top' box, select your header rows directly on the sheet, and click 'OK'.
5. Preview and Print: Go to Menu > Print and verify the repeating headers in the print preview before sending the document to your printer.

Easily set rows and columns to repeat on all printed pagesFully compatible with Microsoft Excel (.xlsx, .xls) formatsFree and lightweight alternative to heavy office suitesBuilt-in PDF conversion to easily share locked print layouts

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Print Titles button grayed out in Excel?

The Print Titles option will be disabled if you are currently editing a cell, if multiple worksheets are selected and grouped together, or if no printer is installed on your computer. Press Esc to exit cell editing and right-click the sheet tab to ungroup sheets to resolve this.

Can I repeat columns on the left side of every printed page instead?

Yes. In the same Page Setup dialog accessed via Print Titles, you can use the 'Columns to repeat at left' box to select specific columns that should be printed on the left side of every page.

Do repeated headings show up in the normal worksheet view?

No, the 'Rows to repeat at top' setting only applies to the printed output and the Print Preview. To keep headings visible while scrolling down in the normal digital view, you should use the 'Freeze Panes' feature located under the View tab.

Document & File Issues