If you have a large data file with headers on the top, you can freeze the columns to easily view the entire table without losing sight of the headers.
But the freeze feature will not be applied when you try to print the file.
To print Excel header row on every page, you can try one of the following methods as per your requirement:
Let’s try to understand each of these methods one by one!
Don’t forget to download this Excel Workbook on how to print Excel header row on every page to follow along:
Repeat row on every page
If you have a large worksheet that spans over multiple pages, you can easily print the first row of the data as headers in Excel on every page.
Follow the steps below to print a row of every page:
STEP 1: Go to Page Layout tab > Select Print Tiles
STEP 2: In the Page Setup dialog box, select Sheet.
STEP 3: Select the collapse dialog box and pick the row you wish to repeat.
STEP 4: Click OK.
STEP 5: Press Ctrl + P to open Print Preview.
As you can see we are on page 5 but the 1st row is still visible!
Repeat column on every page
When your Excel worksheet has multiple columns and is spread across several pages, you can fix the first column.
Follow the steps below to fix the first column when printing:
STEP 1: Go to Page Layout > Select Print Tiles
STEP 2: In the Page Setup dialog box, select Sheet.
STEP 3: Select the collapse dialog box and pick the column you wish to repeat.
STEP 4: Click OK
And it’s done! Column A is still visible when you go to page 2.
Print row numbers and column letters
Excel denotes the worksheet’s columns as letters (A, B, C, etc) and rows as numbers (1, 2, 3, etc). But when you try to print your worksheet, it is not visible at all.
You can easily print numbers and column letters by following the steps below:
STEP 1: Go to Page Layout > Select Print Tiles
STEP 2: In the Page Setup dialog box, select Sheet.
STEP 3: Check Row and column headings
STEP 4: Click OK.
STEP 5: Press Ctrl + P to view Print Preview.
The row numbers and column letters will be displayed in the print preview section!
Conclusion
Now you can easily add Excel header row, Excel column headers, and row-column headings on every page when you print your worksheet.
Click here to learn what customization you can do before you print your document!
HELPFUL RESOURCE:
Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:
You can learn more about how to use Excel by viewing our FREE Excel webinar training on Formulas, Pivot Tables, Power Query, and Macros & VBA!
