Make a cell content not printable

B

basilio

I want some cell contents of my worksheet not to be printed.
I have resolved my problem by running a small macro before printing but I
think it would be much better to have a function within excel, similar to the
one for the other objects where you can select or not the "Print object" from
properties.
Can anybody help??
 
G

Gary''s Student

Use Conditional Formatting with the FormulaIs option. Pick a cell like Z100.
Set the condtional format of the cell you wish to avoid printing to say that
if Z100 is not empty, then make the font color the same as the background
color.

Repeat for each cell you wish to avoid printing.
 

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

Top