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


October 13, 2021 - by Bill Jelen

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



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.