Print Excel header row and column on Every Page | MyExcelOnline

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:

DOWNLOAD EXCEL WORKBOOK

 

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.

Print Excel header row and column on Every Page | MyExcelOnline

Follow the steps below to print a row of every page:

STEP 1: Go to Page Layout tab > Select Print Tiles

Print Excel header row and column on Every Page | MyExcelOnline

STEP 2: In the Page Setup dialog box, select Sheet.

Print Excel header row and column on Every Page | MyExcelOnline

STEP 3: Select the collapse dialog box and pick the row you wish to repeat.

Print Excel header row and column on Every Page | MyExcelOnline

STEP 4: Click OK.

Print Excel header row and column on Every Page | MyExcelOnline

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!

excel header row

 

Repeat column on every page

When your Excel worksheet has multiple columns and is spread across several pages, you can fix the first column.

Print Excel header row and column on Every Page | MyExcelOnline

Follow the steps below to fix the first column when printing:

STEP 1: Go to Page Layout > Select Print Tiles

Print Excel header row and column on Every Page | MyExcelOnline

STEP 2: In the Page Setup dialog box, select Sheet.

Print Excel header row and column on Every Page | MyExcelOnline

STEP 3: Select the collapse dialog box and pick the column you wish to repeat.

Print Excel header row and column on Every Page | MyExcelOnline

STEP 4: Click OK

Print Excel header row and column on Every Page | MyExcelOnline

And it’s done! Column A is still visible when you go to page 2.

Print Excel header row and column on Every Page | MyExcelOnline

 

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.

Print Excel header row and column on Every Page | MyExcelOnline

You can easily print numbers and column letters by following the steps below:

STEP 1: Go to Page Layout > Select Print Tiles

Print Excel header row and column on Every Page | MyExcelOnline

STEP 2: In the Page Setup dialog box, select Sheet.

Print Excel header row and column on Every Page | MyExcelOnline

STEP 3: Check Row and column headings

Print Excel header row and column on Every Page | MyExcelOnline

STEP 4: Click OK.

Print Excel header row and column on Every Page | MyExcelOnline

STEP 5: Press Ctrl + P to view Print Preview.

The row numbers and column letters will be displayed in the print preview section!

Print Excel header row and column on Every Page | MyExcelOnline

 

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:

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Print Excel header row and column on Every Page | MyExcelOnline