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.
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.
- Go to Page Layout tab > Select Print Tiles in the Ribbon to open the Page Setup window.
- Make sure the Sheet tab is selected.
- Click on the Rows to repeat at top box and select the rows you want repeating on every page.
- Click OK to apply the setting.
- 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.
- Go to Page Layout tab > Select Print Tiles in the Ribbon to open Page Setup window.
- Make sure the Sheet tab is selected.
- Click on Columns to repeat at left box and select the row or rows you want repeating on every page.
- 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.