MrExcel.com - Your One Stop for Excel Tips & Solutions

Print a Letter at the Top of Page 1 and Repeat Headings at the Top of Each Subsequent Page

October 13, 2021 - by

Print a Letter at the Top of Page 1 and Repeat Headings at the Top of Each Subsequent Page

Problem: I am sending out a worksheet that contains a letter followed by a lengthy report. I would like the headings to appear at the top of each page after the first page. I don’t want the headings to appear at the top of the letter on the first page.

This report has a welcome letter in rows 1:18. You want to print that one page 1 of the report, and then repeat the headings on Row 19 at the top of each subsequent page.
Figure 118. You want row 19 to appear at the top of page 2 & beyond.

Strategy: Follow the steps in the previous topic. Specify $19:$19 as the Rows To Repeat At Top. If you specify that a row in the middle of the print range should be repeated at the top of the pages, it will not begin repeating until the next page.

Results: The headings do not print at the top of page 1, but they do print at the top of pages 2 and beyond.

This article is an excerpt from Power Excel With MrExcel

Title photo by Scott Graham on Unsplash