How do I hide Excel rows with zero values-no print
 

My excel spreadsheet needs to hide rows that have no values, so space is saved on the printout. Cells in each row currently contain formulas referencing info from other tabs.

I would like A16:J81 to start out hidden and show up as needed when info is typed into the other tabs. If no info, then row should remain hidden.



Thanks!
LMG