I would like to create a dynamic header which can controlled by a cell (or cells) in a spreadsheet. I realize I could forego headers completely and just create this in the worksheet itself, but I would rather use the headers as it would produce a more consistent layout.
If not, might this be a possible future feature?
I think there is no option to do it in the header, but you can use the option in Menu/Format/Print ranges/Edit.
Inner help:
Rows to repeat
Choose one or more rows to print on every page. In the right text box enter the row reference, for example, “1” or “$1” or “$2:$3”. The list box displays -user defined-. You can also select -none- to remove a defined repeating row.
You can also define repeating rows by dragging the mouse in the spreadsheet, if the cursor is in the Rows to repeat text field in the dialog.
thank you, I hadn’t thought of this at all.