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

Outlook 365 overriding formatting choices 0
Suppressing "Do you want to save" message when closing the slideshow 0
Mail Merge Help 1
Problem with printing a word document containing a table 0
Blank Suppression 3
Can I suppress printing a line if a value = 0? 3
Page numbering with Merged Document and IF statements 1
suppress printing on certain rows 7

Top