Printing Problems

How to Hide a Repeating Excel Header on One Printed Page

Khadija Khan Oct 12, 2026 869 views

Question details

The user needs to print a multi-page Excel spreadsheet and wants to hide the repeating table header on one specific page while displaying it on all other pages.

How to Hide a Repeating Excel Header on a Specific Printed Page

Product: Excel
Device & OS: not provided
Scenario: Printing a large dataset where a specific page should not include the repeating header row for formatting or presentation purposes.
Observed behavior: Excel's 'Rows to repeat at top' setting forces the header row to appear on every single printed page, lacking a built-in option to exclude individual pages.

Before you start

Before proceeding, switch your spreadsheet to Page Layout view (View > Page Layout) to see exactly where your data breaks across different printed pages. This will help you identify exactly where headers are needed.

Solution 1Recommended

Disable Repeating Headers and Insert Them Manually

Since Excel does not natively support excluding repeating rows on specific pages, the most effective method is to disable the feature and manually insert headers where needed.

Excel's 'Rows to repeat at top' setting applies the selected rows to every printed page globally. To customize which pages display the header, you must turn off this automatic feature and manually copy your header row to the top of the desired pages.

Turn off automatic repeating rows

Navigate to the 'Page Layout' tab on the ribbon, click 'Print Titles', and clear any cell references in the 'Rows to repeat at top' field. Click 'OK' to save.

Switch to Page Layout view

Go to the 'View' tab and select 'Page Layout'. This view shows you exactly how your document will look when printed, including where each page begins.

Insert blank rows on target pages

Scroll to the top of a page where you want the header to appear. Right-click the row number at the very top of that page and select 'Insert' to create a blank row.

Paste the header manually

Copy your original header row and paste it into the newly created blank row. Repeat this process for all pages that require the header, skipping the page where you want it hidden.

Disable Repeating Headers and Insert Them Manually

Pagination Changes: Keep in mind that if you add, delete, or resize data later, your page breaks may shift. You will need to manually adjust the placement of your copied headers to ensure they stay at the top of the printed pages.

Solution 2

Print the Document in Separate Batches

If you do not want to alter your spreadsheet's structure by inserting manual rows, you can manipulate the print settings and print the document in separate jobs.

Print Formatting Made Easy

Easily Manage Print Layouts with WPS Spreadsheet

WPS Spreadsheet offers an intuitive Page Layout view and easy-to-use Print Titles settings, making it simple to format multi-page documents, manage repeating headers, and set manual page breaks for precise printing.

1. Open your file in WPS Office: Launch WPS Spreadsheet and open your existing workbook.
2. Access Print settings: Navigate to the 'Page Layout' tab on the top ribbon and select 'Print Titles'.
3. Adjust Print Titles and Layout: Clear or set the 'Rows to repeat at top' as needed, then use the Page Break Preview to manually organize your headers across specific pages.

Fully compatible with Microsoft Excel (.xlsx and .xls) filesIntuitive Page Layout and Page Break Preview for precise printing controlFree, lightweight, and user-friendly alternative for everyday office tasks

microsoft office alternative - wps office

Frequently Asked Questions

Can I hide the repeating header on just the first printed page?

If your header is placed within the actual Header/Footer section (not the spreadsheet grid), you can check 'Different First Page' in the Header & Footer settings. However, if you are using 'Rows to repeat at top' for a table header, this feature cannot automatically skip the first page. You must clear the print titles setting and manually paste the header on page two and beyond.

Does Microsoft Word have a feature to hide repeating headers on specific pages?

Word handles tables differently. In Word, you can set a table row to 'Repeat as header row at the top of each page', but similar to Excel, it applies to all pages the table spans across. To stop the header from appearing on a specific page in Word, you have to split the table at that page.

Why does my manually copied header move to the middle of the next page?

This happens when row heights or data above the header change, which pushes your manually inserted header down the sheet. To prevent this, select the row containing your manual header, go to the 'Page Layout' tab, click 'Breaks', and choose 'Insert Page Break'. This ensures the header stays exactly at the top of a new printed page.

Document & File Issues