Repeating headers of subsections

[Excel_dan]

I have an excel sheet with sub sections as shown and I am looking for just the most recent section heading to be printed at the top of the next page if the subsection carries onto the next page. It would be ideal to be dynamic so items can be added into the subsection and the header can still repeat at the correct location. In the image the row in blue "List of Acronyms:" would be repeated on the next page. Any help would be appreciated.

Repeat header question.xlsx
	A	B	C	D	E	F	G
1
2		Title header
3		Title Subject
4		Date modified: 02/13/2023
5
6		Purpose:
7		The purpose of this document is to ….......
8		Table of Contents:
9		To access documents associated with this document, click on the hyperlinks provided below to navigate directly to the documents. Alternatively, each document is housed in its own tab at the bottom of this sheet.
10		1. Construction
11		Provides direction on construction …
12		2. Environmental
13		Provides specific items that should be …
14		3. Stream Restoration
15		Provides specific items that should be…
16		4. Risk
17		Template for use in …
18		List of Acronyms:
19		AAA	AAA …
20		AAB	AAB …
21		AAC	AAC …
22		AAD	AAD …
23		AAE	AAE …
24		AAF	AAF …
25		AAG	AAG …
26		AAH	AAH …
27		AAI	AAI …
28		AAJ	AAJ …
29		AAK	AAK …
30		AAL	AAL …
31		AAM	AAM …
32		AAN	AAN …
33		AAO	AAO …
34		AAP	AAP …
35		AAQ	AAQ …
36		AAR	AAR …
37		AAS	AAS …
38		AAT	AAT …
39		AAU	AAU …
40		AAV	AAV …
41		AAW	AAW …
42		AAX	AAX …
43		AAY	AAY …
44		AAZ	AAZ …
45		ABA	ABA …
46		ABB	ABB …
47		ABC	ABC …
48		ABD	ABD …
49		ABE	ABE …
50		ABF	ABF …
51		ABG	ABG …
52		ABH	ABH …
53		Reference Materials:
54		The following hyperlinks are for quick reference to
55		Reference 1
56		Reference 2
57		Reference 3
58		Reference 4
59		Reference 5
60		Reference 6
Table of Contents

Cell Formulas
Range	Formula
C19:C52	C19	=B19&" …"

 

[Jeffrey Mahoney]

The only way I know how to do that is to put each section you want repeating rows on a new sheet. Set the repeating rows accordingly, set the print area for each sheet, select all sheets you want to print, and print them all at once.