How do I suppress printing a row without hiding it?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!!
 
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
 
Excel doesn't have an equivalent.

I sometimes add a column to the data (insert a new column A and make sure that
the print range doesn't include column A).

Then I'll put a formula in that cell that determines if that row should be
hidden. Then I apply Data|Filter|autofilter to filter by that column.
 
ejt1234 said:
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!!!!!
Click to expand...
Pete, I think that will work! I won't know until I try it on Monday but you
are my hero!
ejt1234
 
Well, thank you ! But Dave has suggested more-or-less the same thing
(he's my hero !! <bg>).

Pete
 
You are the wind beneath my wings!

<gd&r>

Pete_UK said:
Well, thank you ! But Dave has suggested more-or-less the same thing
(he's my hero !! <bg>).

Pete
Click to expand...
 
Back
Top