Excel Print Title Every Page: How to Repeat Rows

Yes, Excel lets you print the same row or column titles on every page of a printout. You set this up in the Page Setup dialog box under the Sheet tab, using the “Rows to repeat at top” and “Columns to repeat at left” boxes. This article explains exactly how to do it, why it works, and how to fix common problems.

What Does “Print Titles” Mean in Excel?

When you print a worksheet that spans multiple pages, Excel only prints the content you selected. By default, the row numbers and column letters (the header area) appear only on the first page. If you have a table with headers in row 1, those headers will appear on page 1 but not on pages 2, 3, and so on. That makes it hard to know what each column represents when you flip through the printed pages.

The “Print Titles” feature lets you designate specific rows (or columns) that Excel repeats at the top (or left) of every printed page. It’s like freezing panes, but for print only—it doesn’t affect how the worksheet looks on screen.

How to Set Up Print Titles (Step-by-Step)

1. Open the worksheet you want to print.
2. Go to the Page Layout tab on the ribbon.
3. In the Page Setup group, click Print Titles. (In some versions, it may be labeled “Print Titles” or “Print Area.”)
4. In the Page Setup dialog box, on the Sheet tab, you’ll see two boxes: Rows to repeat at top and Columns to repeat at left.
5. Click inside the “Rows to repeat at top” box, then click on the row number(s) in the worksheet that you want to repeat. For example, if your headers are in row 1, click on the row 1 header. You can also type the range directly, like $1:$1.
6. Click inside the “Columns to repeat at left” box if you want to repeat columns (e.g., for wide tables that print across multiple pages). Click on the column letter(s), or type $A:$A.
7. Click OK.

Now when you print, those rows/columns will appear on every page. You can verify by going to File > Print and looking at the preview—you’ll see the repeated titles on page 2 and beyond.

Why Use Print Titles? (Real-World Examples)

Print titles are essential for any multi-page report where the reader needs context. For instance:

• A sales report with columns for Product, Region, Quarter, and Revenue. Without repeating row 1, page 2 shows only numbers—meaningless without headers.
• A project timeline with dates in the first column. If the project spans many columns, repeating column A keeps the task names visible on every horizontal page.
• A financial statement with line items in column A and monthly columns. Repeating column A makes it clear which line item each number belongs to.

Without this feature, you’d have to manually copy headers to each page or print with gridlines and hope the reader can figure it out. It’s a simple but powerful way to make printed data usable.

Common Mistakes and How to Avoid Them

Several errors can trip up users:

• Selecting a cell instead of a row/column: When you click in the “Rows to repeat” box, you must click on the row number (the gray box with the number), not a cell. Clicking a cell enters a cell reference like $A$1, which is invalid for print titles. Excel will show an error message if you try to use a cell reference.
• Using the wrong dialog box: Some users go to Page Setup > Header/Footer and try to put titles there. That’s for headers/footers (text at the top/bottom of each page), not for repeating worksheet rows. Print titles are under the Sheet tab.
• Not clearing old titles: If you previously set a title and now want to change it, you must clear the old reference first. If you leave the old range and add a new one, Excel may combine them or show an error.
• Print titles don’t work with “Fit to Page”: If you use the “Fit to” scaling option (e.g., Fit to 1 page wide by 1 tall), Excel may shrink the printout so much that the repeated titles become too small or are omitted. In that case, try adjusting the scale manually or using “Fit to” only for the width or height, not both.

Print Titles vs. Freeze Panes vs. Headers

These three features sound similar but serve different purposes:

• Print Titles – Affects only printing. Repeats rows/columns on each printed page.
• Freeze Panes – Affects only on-screen viewing. Keeps rows/columns visible as you scroll. It does not affect printing.
• Headers/Footers – Text that appears in the top/bottom margin of every printed page (e.g., page numbers, file name). They are not part of the worksheet grid.

You can use all three together. For example, freeze row 1 for on-screen scrolling, set row 1 as print title for printing, and add a footer with page numbers.

How to Print Titles on Every Page in Google Sheets

If you’re using Google Sheets, the feature is called “Repeat row headers” and works slightly differently:

1. Go to File > Print (or press Ctrl+P).
2. In the print setup panel on the right, scroll down to Headers & Footers.
3. Under “Row & column headers,” check the box for Repeat row headers.
4. You can also set a custom range by clicking “Set custom row range” and selecting the rows.
5. Click Next and then Print.

Note that Google Sheets doesn’t allow repeating columns on the left in the same way; you can only repeat rows at the top. For columns, you’d need to manually insert a copy of the first column on each page or use a workaround.

Frequently Asked Questions

Why is my print title not showing on every page?

Check that you’ve selected the correct row/column range and that the range is valid (e.g., $1:$1). Also, ensure you haven’t set a print area that excludes the title rows. If you have a print area set, the titles must be within that area or Excel may ignore them. Additionally, if you’re using “Fit to” scaling, try setting it to a specific percentage (e.g., 100%) to see if titles appear.

Can I repeat both rows and columns at the same time?

Yes, you can set both “Rows to repeat at top” and “Columns to repeat at left” simultaneously. They will both appear on every page. However, note that if your worksheet is very wide and tall, repeating both can take up a lot of space on each page, reducing the area for data.

Does print titles work in Excel Online (web version)?

Yes, Excel Online supports print titles, but the interface is slightly different. Go to File > Print, then under “Settings,” click “Page Setup” (or the gear icon). In the dialog, go to the “Sheet” tab and set the rows/columns to repeat. The feature is available, but some advanced options like multiple print areas may be limited.

How do I remove print titles?

Go to Page Layout > Print Titles. In the Page Setup dialog, clear the contents of the “Rows to repeat at top” and “Columns to repeat at left” boxes, then click OK. The titles will no longer repeat.

Can I print titles only on certain pages?

No, Excel’s print titles feature applies to all pages in the printout. If you need titles on some pages but not others, you’d have to split the data into multiple print areas or use a different approach, such as manually inserting headers on specific pages.

Why does my print title show as a column letter like “A” instead of the content?

This happens when you select a cell instead of a row/column. For example, if you type A1 in the “Rows to repeat” box, Excel will treat it as a column reference (column A) and repeat that column, not the row. Always select the entire row (click the row number) or type the row range like $1:$1.

Related

• Best PS5 Settings for Aim, Audio & Visibility
• How Much RAM Does a Local LLM Need?
• Page Break in Google Docs: Add, Move, Remove