how to make excel header print on every page

How to Ensure Excel Header Prints on Every Page

By Joseph Lopez
AD

Ever found yourself with a multi-page Excel spreadsheet, only to realize that the header isn't repeating on each page? It's a common issue, but fortunately, it's easily fixed. Let's dive into how to make Excel header print on every page.

Before we start, ensure you're using a version of Excel that supports this feature. This guide will focus on Excel 2013, 2016, 2019, and Microsoft 365, but the steps should be similar in other versions as well.

Understanding the Problem and the Solution

By default, Excel doesn't repeat headers on every page. This is to conserve ink and paper. However, if you need your headers to print on every page, you can do so by freezing the top row or using the Page Layout view with print settings.

AD
How to print excel header row on every page
How to print excel header row on every page
Print Excel Headers on Every Page
Print Excel Headers on Every Page
How to repeat row headers on each page in Excel when printing
How to repeat row headers on each page in Excel when printing

Both methods have their advantages and disadvantages. We'll cover both to help you decide which one works best for your needs.

Freezing the Top Row

Freezing the top row is great for keeping your headers visible as you scroll down your document. However, it doesn't ensure that the headers print on every page. Here's how to do it:

How to Print Excel Sheet with Header on Every Page in Excel (3 Methods) - ExcelDemy
How to Print Excel Sheet with Header on Every Page in Excel (3 Methods) - ExcelDemy
How to Print Excel Sheet with Header on Every Page in Excel (3 Methods) - ExcelDemy
How to Print Excel Sheet with Header on Every Page in Excel (3 Methods) - ExcelDemy

Select the first row of your data. Click on the 'View' tab in the ribbon, then click on 'Freeze Panes'. Select 'Freeze Top Row'. Now, scroll down your document - your headers should remain at the top.

using Page Layout View with Print Settings

This method guarantees that your headers print on every page. Here's how to do it:

AD

First, select the range of your header data. Then, on the 'Home' tab, click on 'Format as Table'. This isn't strictly necessary, but it can make managing your headers easier. Next, click on the 'Page Layout' tab. In the 'Page Setup' group, click on 'Print Area'. Select 'Print Area' from the dropdown menu. Now, whenever you print, your headers should print on every page.

Need More Control? Use Section Breaks

Sometimes, you might want to control exactly where a page break occurs. This can be especially useful for large documents with complex headers. That's where section breaks come in.

Inserting a section break is as easy as clicking on 'Layout' in the 'Page Layout' tab, then 'Breaks', and selecting 'Next Page'. This breaks your document into sections, allowing you to control where each section starts and ends.

AD

Creating a Header for Each Section

Each section of your document can have its own header. To do this, click in the cell where you want your header to start. Then, click on 'Insert' in the 'Home' tab, then 'Header'. Choose the header layout you want. Now, customize your header with the data you need.

Retry the Next Page section breaks where you want a new header to start. Excel will remember that you want a header for each section.

That's it! Now you know how to make Excel header print on every page. Whether you're using freezing panes, Page Layout view, or section breaks, you should have no trouble ensuring your headers print exactly where you need them to. Happy Excel-ing!

AD
AD