I am creating a spreadsheet for my higher-up. It is large and they want me
to reduce the rows that are not populated. I've done this by filtering out
anything equal to zero for a total and hiding numbers within the headers and
blank lines I wish to keep so they don't get filtered. As the sheet reduces
the PageBreaks split the tables in half, and it is too much for the
higher-ups to move them to where they go. So I am asking if there is a way
to keep PageBreaks from not being placed within the table or that PageBreaks
should just appear in the blank rows that I was saving?