Selecting test to not print

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Thanks Dave!
--
Joe


Dave Peterson said:
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
Click to expand...
 
Back
Top