How to Set Excel Print Titles and Print Headings (2024)

As long as you’re working in Excel, you can freeze the top row and column to scroll to any part of the sheet with them still visible on the sheet 🧐

But very regretfully, the freezing option doesn’t work like that when you print Excel sheets. This means, even if you have frozen panes in Excel, you’ll be able to view the row/column headers on the first print only.

And the rest of the prints will be headerless. If you get to face the same situation, the guide below will teach you how to help it 👇

So download the free sample workbook for this article here and continue reading.

Set row 1 to print on every page (or any other row)

Here’s some data in Excel that extends across many rows.

Rows-long data in Excel

Let me quickly press the Control key + P to preview how it’ll look when printed. The first page looks fine 😎

A print preview of 1st page

But the second page (and all the pages here onwards) lack the headers on top.

A print preview of 2nd page

So the data makes only little sense from the second printed page onwards 🙈

Can we not set the print settings such that the headers in the first row (or as many rows) consistently appear on each page when printed?

Sure we can.

  1. Go to the Page Layout tab > Print Titles.
Option to print row titles

You’ll be navigated to the Page Setup dialog box as follows 🚴‍♂️

Page Setup dialog box
  1. Under the Page Setup dialog box, go to the Sheet tab.
  2. Lookout for the option Rows to repeat at the top.
  3. Click on the collapse button next to it.
Header row to repeat at top

With this, Excel will take you to the worksheet.

  1. With the black cursor, select the row headers for the rows that you want to see on each sheet.

We are selecting Row 1 for now 1️⃣

Selection of rows

To select multiple rows, hold down the mouse button and stretch the rows selection across the rows to be selected.

Kasper Langmann, Microsoft Office Specialist
  1. Release the cursor once you’re done selecting.
  2. Again click on the collapse button.
 The collapse button

Excel will take you back to the page setup window dialog box as follows;

Page Setup group

Reference to the relevant rows is created 🔁

  1. Click Okay, and that’s it.

Let me now show you the print preview for the second page.

Print preview for the second page

This remains the same for as many pages as are printed 🖨

Pro Tip!

Just like rows, if you want to freeze the first (or any other) column to the left of your prints:

  1. Go to the Page Setup dialog box > Sheet tab > Columns to repeat at left.
  2. Click on the collapse button next to it.
  3. Select the columns that you want to lock on the left.
  4. Again click on the collapse button.
  5. Click Okay.

How to print headings on each page in Excel

We have seen how you can freeze a particular row or column at the top or left of your sheet in Excel.

However, sometimes, you might want the row headers (1,2,3,..) and the column headers (A, B, C,…) to appear in your prints too 🎧

By default, row and column headers do not appear when Excel sheets are printed. If you want these headers to appear in your prints, this can be done easily.

Repeat Excel header columns and header rows

To see the column and row headers in your prints, follow these steps.

  1. Go to the Page Layout tab > Sheet options.
Page layout tab
  1. Under Headings > check the option for Print 📝
Print option for headings
  1. Alternatively, you may go to the Page Layout tab > Click Print Titles.
  2. Under the Page Setup dialog box > Print > Select Row and Column headings.
Repeat excel header rows

And that’s it – you’re all sorted.

  1. Hit the Control key + P to preview the print 🔎
Printed page preview

See those headers on the top and the left? It was easy to have them there, wasn’t it?

That’s it – Now what?

Hope you enjoyed learning easy tips on how you can make printing Excel sheets all the more efficient.

However, this is only about printing sheets in Excel. There’s just so much more to Excel that you’re yet to explore 🚀

So let’s get started already? To begin with, I suggest you go with the VLOOKUP, SUMIF, and IF functions of Excel. You’ll be amazed at how useful these functions can be.

Click here and register yourself in my 30-minute free email course right now. It will teach you these functions (and so much more amazing about Excel) in no time.

Other resources

Printing Excel spreadsheets (the way you want them to be printed) is somewhat of a science. But some useful tips can help you master it.

Hop on here to read our blog on how to print labels and gridlines in Excel.