Suppress Printing with Character in Excel File

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!
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

suppress printing on certain rows 7
Can I suppress printing a line if a value = 0? 3
suppress printing a repeating value in a column 1
Blank Suppression 3
Is there a way to begin printing a footer on page two in Excel? 1
how do I suppress printing blank lines in a worksheet? 1
Save As CSV 1
Suppress Header/Footer 1

Top