excel how to print header on each page

Excel: Print Headers on Every Page - Step-by-Step Guide

By Ashley Jackson
AD

Ever found yourself printing a lengthy Excel sheet only to realize that the header is missing from subsequent pages? It's a frustrating experience, but fear not! Excel offers an easy solution to print headers on every page. Let's explore how to do this.

Printing headers on each page is crucial for readability and organization, especially when dealing with multi-page documents. In this guide, we'll walk you through the steps to achieve this in Microsoft Excel.

Understanding Page Headers in Excel

Before we dive into the steps, let's understand what we're dealing with. Page headers in Excel are the top-most rows that contain important information like titles, date, and page numbers. They're frozen at the top of each page when you print.

AD
How to print excel header row on every page
How to print excel header row 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
Print Excel Headers on Every Page
Print Excel Headers on Every Page

To print headers on every page, you'll need to set up your page headers correctly and tell Excel to print them. Let's see how to do this.

Setting Up Your Page Headers

First, place your headers in the top rows of your data. These could be titles, instructions, or any information you want to repeat at the top of each page.

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
Print options in Excel
Print options in Excel

Next, freeze these headers so they stay at the top even when you scroll down. To do this, select the cell below your headers, then click on the 'View' tab in the ribbon, then 'Freeze Panes'. In the dropdown menu, choose 'Freeze Panes'.

Printing Your Excel Sheet with Headers on Each Page

Now that your headers are set up, it's time to print your Excel sheet. Click on the 'File' tab in the ribbon, then 'Print'. In the Print page, under 'Settings', you can choose to print your headers on every page.

AD

Here's how to do it: in the 'Page Setup' section, click on 'Print what' and select 'Selection' if your headers are within the selection, or 'Active sheet' if they're not. Then, under 'Scaling', choose 'Fit to' and set the number of pages wide to print your headers on each page.

Printing Headers with Specific Page Breaks

Sometimes, Excel might not place your page breaks where you want them. In such cases, you can add or remove page breaks manually to ensure your headers are on every page.

Let's see how to do this:

AD

Adding Page Breaks

To add a page break, place your cursor where you want the page to break and click on the 'Page Layout' tab in the ribbon. Then, click on the 'Breaks' dropdown and select 'Insert Page Break'.

Removing Page Breaks

To remove a page break, click on the 'Page Layout' tab again. In the 'Breaks' dropdown, choose 'Reset All'. This will remove all page breaks and allow Excel to calculate them automatically.

There you have it! Now you know how to print your Excel sheets with headers on every page. Happy printing!

AD
AD