Pinterest Pixel

Print Excel header row and column on Every Page

If you have a large data file with headers on the top, you can freeze the columns... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Print Excel header row and column on Every Page | MyExcelOnline 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 workbookPrint-Row-and-Column-Headers.xlsx

 

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

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

See also  Highlight Cells with Comments Using Macros In Excel

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

Print Excel header row and column on Every Page

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

Print Excel header row and column on Every Page

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

Print Excel header row and column on Every Page

STEP 4: Click OK.

Print Excel header row and column on Every Page

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!

Print Excel header row and column on Every Page

 

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

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

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

Print Excel header row and column on Every Page

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

Print Excel header row and column on Every Page

STEP 4: Click OK

Print Excel header row and column on Every Page

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

See also  Get Started with Google Sheets: The Ultimate Step-by-Step Guide for Beginners

Print Excel header row and column on Every Page

 

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

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

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

Print Excel header row and column on Every Page

STEP 3: Check Row and column headings

Print Excel header row and column on Every Page

STEP 4: Click OK.

Print Excel header row and column on Every Page

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

 

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!

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

If you like this Excel tip, please share it
Print Excel header row and column on Every Page | MyExcelOnline Print Excel header row and column on Every Page | MyExcelOnline
See also  Add a Degree Symbol to Selection Using Macros In Excel
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...