hidden rows & printing issues

Question

I have a spreadsheet with 4 pages.  I have set the page breaks so that each section of the sheet has its own page.  My problem is that when I hide 2 sections that comprise pages 2 & 3 excel still prints all the pages but 2 & 3 are blank.  Is there a way that I can have it print only the unhidden content thus printing pages 1 & 4 only? 

Essentially I only want to unhide and print pages 2&3 when the user actually needs the entire spreadsheet otherwise the sections on those pages should by default be hidden from view and printing. 

I know I could simply move the hidden rows on pages 2&3 to the end and set the print area to cover only the 2 unhidden pages.  It is just each section is calculated based on the data in last section so when the all sections are unhidden it flows better.

Answer 1

Hidden Rows shouldn't print. Are they filtered?

Answer 2

I have the same problem. No answers yet?

Answer 3

No, I have never tried filters in excel so it was not something I thought of.  The issue isn't that the hidden rows are printing it is that the pages on which the hidden rows appear are still printing blankly.

At any rate I decided to simply move the hidden data to the end of the spreadsheet and reset the print are to exlude those pages.