how not print cell in printout?

A

`AMD tower

I'm printing a sheet that has a key in it linked to anoher page with an if
statement.
all that shows up is a zero or one depending on the condition, etc.

Is there a way for format the cell so that it doesn't print when the
page is printed?
 
G

Gary''s Student

The easiest way is to format the font to have the same color as the background.

It is also easy to un-do.
 
D

David McRitchie

I don't think that is quite what he was looking for, but that is about as close as you
can get without using a macro when printing. To see the values on the screen
he can select the column and as long as it is selected can read the values, at least
in Excel 2000 and up where the entire column gets shaded when selected..
 
A

`AMD tower

Thanks for the replies.
I'll do the color thing, and
insert a comment in the cell
so I can find it if I ever need it!
 
A

`AMD tower

duh... This is a dot matix printer so just not showing it on the screen
didn't do the trick. I just moved the cell into the area where the logo is
printed on the form, and it's barely noticable.

mike,
 
D

Dave Peterson

Depending on what your formula is, you may be able to just modify that formula.

If the formula looks something like:
='sheet 99'!a1
(It'll return a 0 when A1 on Sheet 99 is empty.)

It could be replaced with:
=if('sheet 99'!a1="","",'sheet 99'!a1)

So the cell looks empty.

If you don't like the "color thing", you could give the cell a custom format of
";;;" (w/o the quotes).
 
Top