Excel Column Headings on Each Page: How to Repeat Them

To print a worksheet’s header row on every page in Excel for Microsoft 365 on Windows, choose Page Layout > Print Titles, enter the row in Rows to repeat at top, and select OK. If by column headings you mean Excel’s A, B, C labels, turn on Headings under Page Layout > Sheet Options instead; that prints those labels but does not repeat a row of your own headings.

Two meanings of column headings in Excel

The phrase column headings can mean two different things. A worksheet may have a first row containing labels such as Product, Date, and Quantity. Those labels describe the data and are usually what readers want repeated when a long worksheet spans multiple printed pages. Excel calls this feature Print Titles; the row containing the labels is set as a row to repeat at the top.

Column headings can also mean the worksheet’s built-in letters A, B, and C, which appear above the grid. These are row and column headings, sometimes called row and column labels. Excel has a separate print setting for them. Turning it on prints the letters across the top and the row numbers down the side of each printed page. It does not repeat a custom header row such as Product, Date, and Quantity.

It helps to decide which meaning you intend before changing settings. If someone needs to understand the fields in a report, repeat the row containing the field names. If they need to see where worksheet columns A, B, or C are, print the built-in headings. You can enable both settings if both are useful.

Repeat a header row on every printed page

Use Print Titles when a worksheet’s column labels are in a row at the top and the data takes up more than one printed page. The selected row will appear at the top of each page, including later pages, so readers do not have to guess what each column contains.

Open the worksheet you intend to print. Print-title settings apply to a worksheet, so select the correct sheet tab first.
Go to Page Layout > Print Titles. Excel opens the Page Setup dialog on its Sheet tab.
Click in the Rows to repeat at top box. You can type a row reference, such as $1:$1 to repeat row 1, or use the range selector and select the row directly in the sheet.
Select OK, then open File > Print to inspect the preview. Check a later page as well as the first page to confirm the labels repeat.

For example, if row 1 contains the labels Order ID, Customer, and Total, and the records continue through many printed pages, set row 1 to repeat. If the labels occupy rows 1 through 2—for instance, a title in row 1 and field names in row 2—set both rows, using $1:$2. The repeated area must be a range of whole rows at the top of the worksheet; it is not a way to repeat an arbitrary row in the middle of the data.

Print the built-in A, B, C headings

To print Excel’s own column letters and row numbers, select the worksheet and go to Page Layout. In the Sheet Options group, find Headings and select its Print checkbox. The View checkbox controls whether the headings show on screen; it does not by itself determine whether they print. Use File > Print to check the result.

Another route is Page Layout > the small Page Setup dialog launcher, then the Sheet tab, where you can select Row and column headings. The wording or arrangement can vary slightly with the ribbon layout, but the setting belongs to the sheet’s print options. This is distinct from Rows to repeat at top, even though both options affect what appears near the top of a printed page.

Built-in letters and numbers can be useful on a working copy of a spreadsheet, especially when a reader needs to refer to cell locations. They are usually less helpful in a polished report: column letters do not explain what the data means, and row numbers may be mistaken for part of the dataset. For a report, repeated descriptive labels are typically the more useful choice.

What happens when a worksheet spans pages

Print Titles controls what Excel repeats when it divides a worksheet into multiple printed pages. It does not add the header row to the worksheet again, duplicate records, or change the data. It changes the printed layout. A row set to repeat appears at the top of each page produced from that worksheet, while the data beneath it continues through the pages.

If a worksheet is wide as well as long, Excel may split it into pages across the paper and pages down the paper. In that situation, the repeated top row helps identify the columns on pages farther down the worksheet. If the columns are split across pages from left to right, you may also want to repeat identifying columns at the left. In Page Layout > Print Titles, set Columns to repeat at left, for example to $A:$A to repeat column A. This is useful when column A contains a customer name or other identifier needed to interpret each horizontal section.

Print scaling and page orientation also affect the result. A landscape page may fit more columns across than a portrait page, while scaling a worksheet to fit on one page can make text too small to read. Use File > Print to review the actual page breaks, and consider whether legibility is more important than reducing the page count. Print titles repeat labels; they do not automatically make a crowded report readable.

Choose the right setting for your report

Repeat a descriptive header row when readers need to identify fields such as Region, Month, and Revenue on every page.
Print row and column headings when page references to worksheet cells matter, such as during review or troubleshooting.
Use both when readers need the field labels and the worksheet coordinates, and the extra printed labels will not clutter the page.
Repeat columns at the left when a wide report spans multiple pages across and a key identifier would otherwise disappear from pages to the right.

Also consider whether the first row really contains the labels you want. A large report title, blank spacer rows, or notes above the table may mean the field names are not in row 1. Repeat the row that contains the useful labels, or a small group of top rows if the report needs both a title and labels. Avoid repeating a large block of rows, because it leaves less room for new data on every page.

Common problems and how to fix them

The heading appears only on the first page. Confirm that you used Page Layout > Print Titles and set Rows to repeat at top. Merely selecting a row, freezing it, or turning on the worksheet’s Headings view does not set a repeated print title. Reopen Print Titles and inspect the range shown in the box.

The wrong row repeats. Check the row numbers in the reference and look at the print preview. If labels are on row 3, setting $1:$1 repeats row 1 instead. Select the actual label row, or enter the appropriate row range. If the worksheet has several introductory rows, decide whether they are all needed on every page before including them.

The print-title controls are unavailable or cannot be edited. Check whether you are editing a cell or using a mode that limits worksheet changes, and make sure the correct sheet is active. If multiple worksheets are grouped, ungroup them before configuring an individual sheet: right-click a selected sheet tab and choose Ungroup Sheets. A protected worksheet or workbook state may also prevent changes. Excel for the web has more limited page setup controls than the desktop app; open the workbook in Excel for Windows or Mac to set or adjust print titles if the option is unavailable in the browser.

The repeated labels are cut off or the pages look crowded. Use the print preview to check margins, orientation, paper size, scaling, and page breaks. Reduce unnecessary repeated rows, widen columns where appropriate, or use landscape orientation for a wide table. Avoid shrinking the entire worksheet so much that the body text becomes unreadable. The print-title setting cannot fix columns that are too narrow or page scaling that is too aggressive.

Frozen headings do not print on every page. Freeze Panes is a screen-navigation feature. It keeps rows or columns visible while scrolling in the worksheet, but it does not tell Excel to repeat them in printouts. Set Print Titles separately if you want repeated print labels.

Print titles compared with headers and footers

Print titles are worksheet cells repeated as part of the grid. Headers and footers are separate print areas that can contain items such as a report name, date, or page number. They are managed through page setup options and do not repeat the table’s actual column labels. A footer with Page 1 of 4 can help readers navigate a document, but it cannot replace a repeated row containing fields such as Product and Units.

Similarly, freezing the top row is not the same as repeating it in print. Freeze Panes affects what remains visible while scrolling on screen. Print Titles affects the printed pages. A workbook can use either feature, both, or neither, depending on whether the need is screen navigation or printing.

Frequently Asked Questions

How do I print the top row on every page in Excel?
Go to Page Layout > Print Titles, enter or select the row in Rows to repeat at top, and select OK. Check File > Print to verify that the row appears on later pages.

How do I repeat row 1 and row 2 when printing?
In the Rows to repeat at top box, enter $1:$2. This repeats both whole rows at the top of each printed page.

Can Excel print column letters on every page?
Yes. On the Page Layout tab, select the Print checkbox under Headings in Sheet Options, or enable Row and column headings on the Sheet tab of Page Setup. This prints worksheet letters and numbers, not custom field names.

Why do frozen panes not repeat when I print?
Frozen panes are for keeping rows or columns visible on screen as you scroll. To repeat rows or columns on printed pages, configure Print Titles in Page Layout.

Can I repeat a column on the left of every printed page?
Yes. Open Page Layout > Print Titles and set Columns to repeat at left, such as $A:$A to repeat column A. Preview the pages to confirm the identifier remains visible.

Can I set this up in Excel for the web?
Print and page setup options in Excel for the web are more limited than in the desktop app. If you cannot find or edit Print Titles in the browser, open the workbook in the desktop version of Excel and set the repeated rows or columns there.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.