You can freeze rows or columns to make it easier working on large data tables. However, freezing has no effect on printed documents and you will get the original document with or without the rows and columns. In this guide, we’re going to show you how to print header row and column in Excel.

Download Workbook

Printing header row on every page

Let's take a worksheet with rows of data over multiple pages.

Follow the steps to print a header row on every page.

  1. Go to Page Layout tab > Select Print Tiles in the Ribbon to open the Page Setup window.
    How to print header row and column in Excel 02
  2. Make sure the Sheet tab is selected.
  3. Click on the Rows to repeat at top box and select the rows you want repeating on every page.
  4. Click OK to apply the setting.
    How to print header row and column in Excel 03
  5. You can check the process in Print Press Ctrl + P or use File > Print. You can see that the top row remains through pages.

Printing header column on every page

You can freeze columns in printed pages as well. This feature can be useful for aligning the data on a growing table.

Follow the steps to print a header column on every page.

  1. Go to Page Layout tab > Select Print Tiles in the Ribbon to open Page Setup window.
    How to print header row and column in Excel 02
  2. Make sure the Sheet tab is selected.
  3. Click on Columns to repeat at left box and select the row or rows you want repeating on every page.
  4. Click OK to apply the setting.

You can check the process in Print mode. Press Ctrl + P or use File >  Print. You can see that the top row remains still through pages.

Printing both row and column in Excel

You can also select both rows and columns to print header row and column in Excel.

How to print header row and column in Excel