How to repeat the header row on each printed page in Excel?
When working with large data tables in Excel that span multiple printed pages, ensuring clarity and context is crucial. By default, Excel only prints the header row—the row containing the column names or titles—on the first page. As a result, data printed on subsequent pages can become difficult to interpret, as the headers are absent and readers might lose track of the data context. This can lead to confusion, misinterpretation, and extra manual effort when reviewing or sharing printed worksheets. How can you repeatedly print the header row in every page in Excel? In this article, you may find the answer.
Repeat header row print in each page with Page Setup
Repeat header row print in each page with Kutools for Excel
Repeat header row print in each page with Page Setup
To ensure your column headers are printed at the top of every printed page, you can use the Page Setup feature in Excel. This is a standard method suitable for most cases where you want the same row or rows to repeat at the top of each printout. Although simple, it is effective for nearly all typical header row requirements in Excel and maintains your existing worksheet formatting.
Please note: This method works for repeating rows at the top of each page. If you also need to repeat columns on each page (such as row labels for printouts with many columns), you can use a similar approach by configuring the "Columns to repeat at left" in the same dialog.
1. Activate the worksheet where you want the header row to repeat, then click Page Layout > Page Setup. Refer to the screenshot below:
2. In the Page Setup dialog, go to the Sheet tab and locate the Rows to repeat at top field. Click the collapse dialog button to select the header row or rows you wish to repeat at the top of each page. Once selected, the reference (e.g., $1:$1) will appear in the field. Click OK to confirm.
After setting this up, your header row(s) will appear at the top of every printed page. To check your settings, use File > Print to preview the result before printing.
Repeat header row print in each page with Kutools for Excel
If your printing requirements are a bit more advanced—for example, you need the header row to appear every specific number of rows (not just at each page break), or your data has a non-standard structure—the built-in Excel method may not suffice. In such cases, Kutools for Excel provides enhanced flexibility. With the Insert Titles Rows feature, you can insert header rows at regular intervals throughout your worksheet. This is especially valuable when you need to guarantee header visibility not just at page breaks but at specified row intervals, such as every 20 rows for ease of review.
Advantages: This approach gives you greater control over where header rows appear, which is useful for preparing handouts, data audits, or when creating custom formatted prints for presentations or distribution. However, it physically inserts header rows into your data, so be cautious if your data will later be used for further analysis.
After installing Kutools for Excel, please do the following to repeat header rows at custom intervals: (Free Download Kutools for Excel Now!)
1. On the Kutools tab, click Insert > Insert Titles Rows. In the dialog that appears, select the header row you wish to repeat, specify the range where titles should be inserted, and set the interval (e.g., every 20 rows). The selected header will be inserted at each interval you define. See the screenshots below:
2. Click OK. The header row will now appear at your defined interval throughout the worksheet.
3. To print each section on a new page, use Kutools Plus > Printing > Insert Page Break Every Row. This feature will automatically insert page breaks at the intervals you set, aligning the repeated headers with new pages.
4. In the dialog, enter the interval (e.g.,21) in the textbox and click OK > OK. This will insert page breaks at every specified interval.
As a result, your worksheet will print with header rows at every interval you set (for example, every 20 rows) and start each section on a new page, achieving highly customizable printing layouts.
Practical reminder: This method physically alters your worksheet by inserting new rows and page breaks. It is recommended to apply these actions on a copy of your dataset if you need to retain the original data structure for other purposes.
Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy permanently free AI features! Get It Now
Demo: Repeat header row print in each page with Kutools for Excel
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in