Preventing cell contents from printing
 

I've got cells in my worksheet that I've changed the font color and
background color the same, so the contents are not visible when viewing the
sheet... I don't want the contents of these cells to be printed either... Is
there a way to prevent them from printing?

Depending on the specific printer and the color you chose to use, try:
<File <PageSetup <Sheet tab,
And *UNCHECK* "Black & White".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Blair Scanlan" <Blair wrote in message
...
I've got cells in my worksheet that I've changed the font color and
background color the same, so the contents are not visible when viewing
the
sheet... I don't want the contents of these cells to be printed either...
Is
there a way to prevent them from printing?

I've already tried that unsuccessfully...

"Ragdyer" wrote:

Depending on the specific printer and the color you chose to use, try:
<File <PageSetup <Sheet tab,
And *UNCHECK* "Black & White".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Blair Scanlan" <Blair wrote in message
...
I've got cells in my worksheet that I've changed the font color and
background color the same, so the contents are not visible when viewing
the
sheet... I don't want the contents of these cells to be printed either...
Is
there a way to prevent them from printing?

Can you hide the rows/columns?

--
Don Guillett
SalesAid Software

"Blair Scanlan" <Blair wrote in message
...
I've got cells in my worksheet that I've changed the font color and
background color the same, so the contents are not visible when viewing
the
sheet... I don't want the contents of these cells to be printed either...
Is
there a way to prevent them from printing?

If you use white on white, exactly what do you get?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Blair Scanlan" <Blair wrote in message
...
I've already tried that unsuccessfully...

"Ragdyer" wrote:

Depending on the specific printer and the color you chose to use, try:
<File <PageSetup <Sheet tab,
And *UNCHECK* "Black & White".
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Blair Scanlan" <Blair wrote in
message
...
I've got cells in my worksheet that I've changed the font color and
background color the same, so the contents are not visible when
viewing
the
sheet... I don't want the contents of these cells to be printed
either...
Is
there a way to prevent them from printing?

You could use conditional formatting to change the font to white, when
printing. There's an example he

http://www.contextures.com/xlCondFormat03.html#Print

Blair Scanlan wrote:
I've already tried that unsuccessfully...

"Ragdyer" wrote:


Depending on the specific printer and the color you chose to use, try:
<File <PageSetup <Sheet tab,
And *UNCHECK* "Black & White".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Blair Scanlan" <Blair wrote in message
...

I've got cells in my worksheet that I've changed the font color and
background color the same, so the contents are not visible when viewing

the

sheet... I don't want the contents of these cells to be printed either...

Is

there a way to prevent them from printing?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html