How do I prevent spicific visable cells from printing

G

Gazboe

I have a cell that is setup as a hyperlink and has text in it to show its
function. However I would like to prevent this cell form appearing on any
printed form. Can any one explain how to acheive this.
 
G

Gord Dibben

Format>Custom ;;; (three semi-colons)

The text won't show in the cell or on a print-out.

The hyperlink will still work.

You can always clear the formatting after printing.


Gord Dibben Excel MVP
 
Top