How to Print Titles at the Top of Each Page

October 12, 2021 - by Bill Jelen

How to Print Titles at the Top of Each Page

Problem: I have a report that has 90 rows of data. I want to have the title rows print at the top of each printed page.

A report has titles in Rows 1-3, a blank row 4, headings in row 5, and the actual data starts in Row 6. You want to make sure the headings for rows 1:5 print at the top of each printed page.
Figure 116. Repeat titles at the top of each printed page.

Strategy: Printing options are controlled on the fourth tab of the legacy Page Setup dialog box. In this case, you want rows 1 through 5 to print at the top of each page. Follow these steps:

  • 1. Select Print Titles. The Sheet tab of the Page Setup dialog will be displayed.

  • 2. Click the mouse in the Rows to Repeat at Top box.

Go to the Sheet tab in the Page Setup dialog. There is a Print Titles setting called Rows to Repeat at Top. Enter 1:5 there.
Figure 117. Select Rows to Repeat at Top
  • 3. Look behind the dialog box. If you can see the row numbers that you want to repeat, click on the first row and drag down to the last row. Excel should fill in $1:$5 for you. Alternatively, you could type this text or use the RefEdit button at the right edge of the box.

  • 4. There is a Print Preview button at the bottom of the dialog. Check page 2 of the Print Preview to see if the rows are appearing correctly.

See Also: "How to Print Page Numbers at the Bottom of Each Page" on page 56.

This article is an excerpt from Power Excel With MrExcel

Title photo by Kelly Sikkema on Unsplash

Bill Jelen is the author / co-author of:
MrExcel 2021 – Unmasking Excel

This is a 5th edition of MrExcel XL. Updates for 2021 include: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.