See but does not print

T

Turnipboy

Is there a way to get text to be visible in various scattered cells o
screen, but not appear in a print
 
D

Dave Peterson

You could change the font color to match the fill color (white on white) or even
change the numberformat to a custom format of ;;; (3 semicolons)--then change
back after you print.

Ron de Bruin has some tips at:
http://www.rondebruin.nl/print.htm#Hide
Look for "Make the Font white of a range"
 
T

Turnipboy

That is something I considered, I was wondering if there was a simpler
way that also allowed you to see the 'hidden' cells' contents
 
Top