I have a number of tables which show all possible categories, but in
each month not all these categories will be used. In order to avoid
printing them I put a simple formula in a helper column (to the right
of the print area) which basically takes the count on that row - in
your case this would be =ytd total, copied down.

You can then apply a filter to these numbers - custom, not equal to,
zero, to hide the rows temporarily while you print. Then select All
from the filter to reveal them again.

Hope this helps.

Pete

On Oct 24, 1:22 am, ejt1234 wrote:
I am converting from Lotus to Excel. I use the "||" characters in the first
column of my spreadsheets print range to suppress the print of the row
without having to hide it. This is essential for my updates, so I don't
spend time displaying rows now have data pulling into them.

What is the Excel equivalent? Custom views does work, but it is extremely
inefficient to unhide/hide the rows from month to month over 83 different
departments. In Lotus, I write a formula that essentially is = if the ytd
total = zero then "||", otherwise put a zero. I turn the zero hide on, and
set the print range and all rows in which the ytd = zero don't print. Lotus
will even adjust the print range to account for the rows not printed.
HELP!!!!!