Suppress Printing with Character in Excel File

  • Thread starter Thread starter Shannoni
  • Start date Start date
S

Shannoni

Is there a way to suppress printing a line by using a character in a cell?
For example,

IF($B2="","Suppress Print", $B2)

Is there a "Suppress Print" character?

Thanks!
 
I understand that some (all?) versions of Lotus 123 support this kind of thing
(using a pipe | character???).

It's not supported in excel (like Gord wrote), but you may be able to mimic it.

Maybe you could apply a filter to hide the rows with that character in it, then
print.

Or you could even run a macro that examines the cell, maybe hides the row,
prints and then unhides the rows.
 
Back
Top