Print an Excel Column on Every Page: Step-by-Step

How-to basics · Updated November 20, 2026

To print the same Excel column on every printed page, open the worksheet and choose Page Layout > Print Titles. In the Page Setup window, use the Sheet tab to set Columns to repeat at left, then check the result in Print Preview. This is useful when a wide table spans multiple pages and readers need an identifying column, such as a product name or employee, beside the values on each page.

What You’ll Need

  • A workbook opened in the Microsoft Excel desktop app for Microsoft 365 on Windows. Excel for the web does not let you set or edit print titles; choose Open in Desktop App to configure them.
  • A worksheet that will print on more than one page, or a print layout you expect to extend across multiple pages.
  • The column or consecutive columns you want repeated, plus access to a printer or the option to print to PDF if you want to check the finished output.

You do not need to change the worksheet data. Print titles affect the printed layout; they do not add copies of the column to your cells or change what appears on screen. The setting belongs to the worksheet you configure, so repeat the setup separately on other sheets that need the same treatment.

Step-by-Step

  1. Open the worksheet you intend to print. Click a cell on the relevant sheet and check that the data is arranged as expected. Identify the column that will help readers recognize each row on later pages. For example, a sales report might repeat the column containing product names, while an attendance list might repeat employee names. If readers need two identifying fields, plan to repeat both if they are next to each other.
  2. Check that the sheet will use multiple pages. Select File > Print to open the print screen and inspect the preview, or return to the worksheet and continue to the print-title settings first. The repeated column is most noticeable when the sheet spans pages from left to right. If the entire sheet fits on one page wide, there is no second horizontal page on which a duplicate can appear. A sheet can also have multiple pages down the page because it has many rows; the title column is intended to appear on the printed pages as well.
  3. Open Print Titles. Return to the worksheet, select the Page Layout tab on the ribbon, and click Print Titles in the Page Setup group. Excel opens the Page Setup dialog box. If the ribbon is minimized, expand it or use the tab and command search to locate Print Titles. Do not confuse this command with Print Area: Print Area controls which cells are included, while Print Titles controls which chosen rows or columns are repeated.
  4. Go to the Sheet tab. In the Page Setup dialog box, select Sheet. Find the field labeled Columns to repeat at left. The nearby Rows to repeat at top field is for repeating heading rows, not columns. Leave that row field alone unless you also want a heading row, such as the table’s column labels, to appear on every page.
  5. Set the column to repeat. Click inside Columns to repeat at left and enter the column reference. To repeat column A, enter $A:$A. To repeat the adjacent columns A and B, enter $A:$B. You can select the range instead: click the small range-selection button beside the field, select the column letter or consecutive column letters on the worksheet, then click the button again to return to the dialog. Check that the reference appears in the field before continuing.
  6. Confirm the setting. Click OK to save the Page Setup change for the active worksheet. If Excel warns that the reference is invalid, check that you selected whole columns or a valid continuous range and that the field does not contain extra text. You can reopen Page Layout > Print Titles at any time to review or change the selection.
  7. Review the print preview. Choose File > Print and look through the preview pages, especially pages to the right of the first page. The repeated column should appear at the left edge of each printed page, alongside that page’s portion of the other columns. If the workbook has several print pages vertically, check a page farther down too. Preview is the best way to catch an unexpected page break or a column that is too wide.
  8. Print or save the result. If the preview looks right, choose the printer and settings you want, then select Print. To check a copy without using paper, choose Microsoft Print to PDF in the printer list, if available, and print to a PDF file. Open the PDF and confirm that the repeated column is visible on each relevant page.

On Excel for Mac, the command is also available from the Page Layout tab through Print Titles; the Page Setup dialog contains the Sheet settings for repeated columns. The exact dialog appearance can differ slightly by Excel version. In Excel for the web, open the workbook in the desktop app to create or edit this setting, then print from the desktop app or return to the web app to print if appropriate.

Common Mistakes

Using Rows to repeat at top instead. The two fields are close together, but they do different jobs. If you put a column reference in the row field, Excel will not repeat the column down the left side of each page. Use Columns to repeat at left for vertical columns. Use Rows to repeat at top for heading rows that should appear across the top.

Expecting a repeated column when the sheet is one page wide. If scaling has squeezed all columns onto one printed page, there are no additional horizontal pages that need a repeated column. The preview may therefore show just one copy. Change the scaling or paper orientation if you need the sheet to span several pages across, then check the preview again.

Choosing a range that includes too much. Repeating several columns can leave less room for the remaining data on each page and may increase the number of printed pages. Select only the identifier columns readers need. If you repeat a wide block, the actual data area can become narrow or difficult to read.

Assuming the setting changes every worksheet. Print titles are configured per sheet. A workbook with three report sheets may need the repeated-column range set on each one. Also, a print title does not change the normal worksheet view or copy the column into the workbook’s data.

Looking for a second copy in the worksheet itself. The repeated column appears in printed output and print preview, not as duplicated worksheet cells. That is expected and avoids altering the source table.

Tips

Choose an identifier that makes each row understandable on its own. A customer ID or item name is often more useful than a blank spacer or a value that repeats frequently. If the identifier needs context, repeat its adjacent label column too, provided both columns fit comfortably on the page.

Use Print Preview to assess the whole layout, not only whether the title column repeats. Page Layout > Orientation lets you switch between Portrait and Landscape, and Page Layout > Size lets you choose a paper size. A wider paper size or Landscape orientation can give the non-repeating data more room. These choices can change page breaks, so preview after changing them.

Use scaling carefully. In the print screen, Excel provides scaling options such as fitting all columns on one page. That can eliminate horizontal page breaks and make the repeat setting appear unnecessary. If the data becomes too small to read, consider printing across more pages instead of forcing every column onto one sheet-width page. You can adjust page breaks from the Page Layout tab using Page Break Preview, then return to Normal view when finished.

If you also need column headings repeated, set Rows to repeat at top separately. For example, a report might repeat its identifying column on the left and its header row at the top. Preview a page other than the first to verify both settings. If the table uses a print area, check that the intended data is included in the printed range and that the resulting layout remains readable.

For a workbook you print regularly, save it after setting the print titles. This preserves the worksheet’s page setup for the next time you open and print it. If you are preparing a one-time print for someone else, consider saving a PDF as well; the PDF lets you inspect how the repeated column and page breaks look without changing the workbook.

Troubleshooting

The column is missing from later pages. Reopen Page Layout > Print Titles, select the Sheet tab, and check Columns to repeat at left. Confirm the range is in that field and click OK. Then open File > Print again. If you configured a different worksheet, switch to the intended sheet and set the option there.

The preview shows only one printed page. The worksheet may be scaled to fit one page wide, or its columns may already fit on the selected paper. Check the scaling choice in the print screen and the preview’s page count. If you want multiple pages across, avoid a fit-all-columns-to-one-page setting; try Landscape or a larger paper size, then inspect readability and page breaks.

The repeated column takes up too much space. Return to the Sheet tab in Page Setup and reduce the range to the essential identifier column or columns. You can also adjust that column’s width on the worksheet, use a wider page orientation, or reduce margins through Page Layout > Margins. Avoid shrinking text so much that it becomes hard to read.

The range is rejected or does not look right. In Columns to repeat at left, use a whole-column reference such as $A:$A for column A or $A:$B for adjacent columns A and B. Remove extra spaces or stray characters, and use the range-selection button if typing is error-prone. Do not enter a cell value or a formula in this field.

The printed page breaks differ from the preview. Check that the same printer, paper size, orientation, and scaling are selected for the final print. Printer drivers can affect page layout. If the output still differs, print to PDF and inspect that file, then adjust the setup before printing on paper.

Frequently Asked Questions

Can I print two columns on every page?
Yes. In Columns to repeat at left, set a continuous range such as $A:$B to repeat columns A and B. Check that the extra width still leaves enough room for the other data.

Can I repeat a column and a heading row at the same time?
Yes. Set the column range in Columns to repeat at left and the heading-row range in Rows to repeat at top in the same Sheet tab. Preview a later page to check that both appear as intended.

Will the column repeat on every worksheet in my workbook?
No. The setting applies to the active worksheet. Configure Print Titles separately on each sheet that needs them, and review each sheet’s print preview.

Can I repeat a column in Excel for the web?
Excel for the web does not provide the desktop Print Titles setup for editing repeated columns. Open the workbook in the Excel desktop app, set the range using Page Layout > Print Titles, and then preview or print.

Does this change my worksheet data?
No. It changes the print layout only. The column is not duplicated in the grid, and formulas or cell values are not altered.

Why do I not see the repeated column on the first page?
The first page already contains the original column in its normal position, so it may look like there is no extra copy. Compare it with a later page in Print Preview; that is where the repeated column is easiest to recognize.

Related

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.