My problem is that I have a one row that serves as a "main heading" for the spreadsheet. It is easy to repeat that row on the top of the page, but then I also have "sub headings" that change as you move down the spreadsheet.
For Example: The fist "sub heading" is "states". I want this row to repeat at the top of each page until the second "sub heading", "cities", then I want the row repeating to switch to "cities".
Can this be done? Thanks.
For Example: The fist "sub heading" is "states". I want this row to repeat at the top of each page until the second "sub heading", "cities", then I want the row repeating to switch to "cities".
Can this be done? Thanks.