Make a cell content not printable

  • Thread starter Thread starter basilio
  • Start date Start date
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??
 
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.
 
Back
Top