I have multiple header rows in the same Excel worksheet (not different tabs). And I would like to format the worksheet so that when I scroll down to the second header row, the words in heading 2 replace the words in heading 1 temporarily (until I scroll back up to the top of the page). Does anyone know how to do this?

For example:

Row 1 to always show on every page I print (Title of report)
Row 2 to change values when it gets to a specific row further down the worksheet (section I am in, 'No flat fee detail' or 'Flat Fee Detail')
Row 3 to always show on every page I print (Titles of data below)

I can get this working with two headers by using a combination of the Header and print tiles, but I cannot figure out how to use a type of conditional formatting to change a header row based on some condition without a forced page break. Is this possible?



Thank you,
Erlo