Selecting test to not print

[jwm5566]

Can I select a text box or a group of cells so that whatever I type is seen
on my screen but is not visible on the print out?

 

[Dave Peterson]

Rightclick on the textbox (on the edge)
choose "Format Text Box" or "format control"
(depends on where you got the textbox--from the Drawing toolbar or the control
toolbox toolbar)

Then choose the properties tab and uncheck Print Object.

If you want to hide text in a cell, you can format it with a custom number
format of:
;;;
(3 semicolons)

or even give them a font color to match the fill color.
(manually, via a macro or via format|Conditional formatting)

Ron de Bruin shares a macro method:
http://www.rondebruin.nl/print.htm#Hide

 

[jwm5566]

Thanks Dave!
--
Joe

Rightclick on the textbox (on the edge)
choose "Format Text Box" or "format control"
(depends on where you got the textbox--from the Drawing toolbar or the control
toolbox toolbar)

Then choose the properties tab and uncheck Print Object.

If you want to hide text in a cell, you can format it with a custom number
format of:
;;;
(3 semicolons)

or even give them a font color to match the fill color.
(manually, via a macro or via format|Conditional formatting)

Ron de Bruin shares a macro method:
http://www.rondebruin.nl/print.htm#Hide