Pinterest Pixel

Print Excel header row and column on Every Page

John Michaloudis
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.

Let's try to understand each of these methods one by one!

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. Let’s try to understand each of these methods one by one!

Key Takeaways

  • Repeat Rows and Columns for Clarity – Ensure key headers are visible on every printed page for easy reading.

  • Access Through Page Layout Tab – Use the Page Layout tab and click Print Titles to set repeating headers.

  • Set Rows to Repeat at Top – Choose one or more rows to repeat at the top of each printed page.

  • Set Columns to Repeat at Left – Choose one or more columns to repeat on the left side of every page.

  • Improves Multi-Page Reports – Keeps context consistent when printing large tables or reports across pages.

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:

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.

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

Frequently Asked Questions

Where do I find the option to repeat headers when printing?
Go to the Page Layout tab and click on Print Titles in the Page Setup group.

Can I repeat both rows and columns?
Yes, you can set rows to repeat at the top and columns to repeat on the left simultaneously.

Why don’t my headers show on every page when printed?
You may have forgotten to set the rows/columns under Print Titles before printing.

Can I preview how it will look before printing?
Yes, use Print Preview under File > Print to confirm your settings.

Does this work in all versions of Excel?
The feature is available in most modern versions of Excel, including Excel 2010 and later.

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!

If you like this Excel tip, please share it


Founder & Chief Inspirational Officer

at

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 MyExcelOnline Academy Online Course.

See also  Learn How to Forward Meeting Invites in Outlook

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

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...