Repeat column titles on each page of a printout

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

Why?

It is easier to read a list that spans many pages when the column titles are included on each page.

How?

  1. On the Layout tab, under Print, click Repeat Titles.

    Layout tab, Print group

  2. Click the Rows to repeat at top box.

    Click Rows to repeat at top box

  3. Without closing the Page Setup dialog box, click the row number of the row that you want to repeat, and then click OK.

    Click row number, then click OK

    Tip: Don't close the Page Setup dialog box until after you select the row. Drag the dialog box out of the way if it covers the row number that you want to click.

  4. Click Print.

    Click Print button

Hints

  • To repeat more than one row on each page of a printout, drag across the row numbers.

  • You can repeat columns on the left side of each printed page by using the Columns to repeat at left box.

See also

Print headings or titles on every page

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×