software

when I print (hidden on the paper print only) without erasing or deleting
the word or formula in the cell?
Thanks in advance.
zOne way is to change the font color to the same as the background color of
the cell(s)

Vaya con Dios,
Chuck, CABGx3
quot;Octavioquot; wrote:

gt; when I print (hidden on the paper print only) without erasing or deleting
gt; the word or formula in the cell?
gt; Thanks in advance.
gt;
gt;
gt;

Or format as custom ;;; if this is feasible.Gord Dibben MS Excel MVP

On Wed, 18 Jan 2006 05:01:02 -0800, CLR gt; wrote:

gt;zOne way is to change the font color to the same as the background color of
gt;the cell(s)
gt;
gt;Vaya con Dios,
gt;Chuck, CABGx3
gt;
gt;
gt;
gt;quot;Octavioquot; wrote:
gt;
gt;gt; when I print (hidden on the paper print only) without erasing or deleting
gt;gt; the word or formula in the cell?
gt;gt; Thanks in advance.
gt;gt;
gt;gt;
gt;gt;Hi Octavio,
Please stick to this thread where you originally posted. How can one
trust a
document that looks one way to one person and another way to someone
else,
where is your audit trail. Especially if such a number is used in a
calculation
-- and I don't know if it is or not.

You might be able to accomplish something along your lines of being
able to
see something on the display, but not in print using a cell
comment.(if not
used in a calculation).
www.mvps.org/dmcritchie/excel/ccomment.htm

HTH, David McRitchie, Microsoft MVP, ExcelThanks, David, for your advise.
I think that I read sometime ago somewhere how to hide the words when
printing, however, I think it was in the Word program (is that correct?). I
was hoping that you could do the same with Excell, but it seems from all of
your responses that that is not possible with that program.
gt; wrote in message ps.com...
gt; Hi Octavio,
gt; Please stick to this thread where you originally posted. How can one
gt; trust a
gt; document that looks one way to one person and another way to someone
gt; else,
gt; where is your audit trail. Especially if such a number is used in a
gt; calculation
gt; -- and I don't know if it is or not.
gt;
gt; You might be able to accomplish something along your lines of being
gt; able to
gt; see something on the display, but not in print using a cell
gt; comment.(if not
gt; used in a calculation).
gt; www.mvps.org/dmcritchie/excel/ccomment.htm
gt;
gt; HTH, David McRitchie, Microsoft MVP, Excel
gt;
You can also set a specific PrintArea in Excel, that will not include some
data you do not wish to print.....

Vaya con Dios,
Chuck, CABGx3quot;Octavioquot; gt; wrote in message
...
gt; Thanks, David, for your advise.
gt; I think that I read sometime ago somewhere how to hide the words when
gt; printing, however, I think it was in the Word program (is that correct?).
I
gt; was hoping that you could do the same with Excell, but it seems from all
of
gt; your responses that that is not possible with that program.
gt;
gt;
gt;
gt; gt; wrote in message
gt; ps.com...
gt; gt; Hi Octavio,
gt; gt; Please stick to this thread where you originally posted. How can one
gt; gt; trust a
gt; gt; document that looks one way to one person and another way to someone
gt; gt; else,
gt; gt; where is your audit trail. Especially if such a number is used in a
gt; gt; calculation
gt; gt; -- and I don't know if it is or not.
gt; gt;
gt; gt; You might be able to accomplish something along your lines of being
gt; gt; able to
gt; gt; see something on the display, but not in print using a cell
gt; gt; comment.(if not
gt; gt; used in a calculation).
gt; gt; www.mvps.org/dmcritchie/excel/ccomment.htm
gt; gt;
gt; gt; HTH, David McRitchie, Microsoft MVP, Excel
gt; gt;
gt;
gt;
How do you do that Chuck? I changed the font color to white to match the
color of the paper (like you suggested in your first answer) and it did not
show in the computer, I could not see it in the computer, but it printed.
The color of the background that I work with (and most of us work with) in
the computer is white and also the color of the paper. What else can I do?
Please advise.quot;CLRquot; gt; wrote in message
...
gt; You can also set a specific PrintArea in Excel, that will not include some
gt; data you do not wish to print.....
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt; quot;Octavioquot; gt; wrote in message
gt; ...
gt;gt; Thanks, David, for your advise.
gt;gt; I think that I read sometime ago somewhere how to hide the words when
gt;gt; printing, however, I think it was in the Word program (is that correct?).
gt; I
gt;gt; was hoping that you could do the same with Excell, but it seems from all
gt; of
gt;gt; your responses that that is not possible with that program.
gt;gt;
gt;gt;
gt;gt;
gt;gt; gt; wrote in message
gt;gt; ps.com...
gt;gt; gt; Hi Octavio,
gt;gt; gt; Please stick to this thread where you originally posted. How can one
gt;gt; gt; trust a
gt;gt; gt; document that looks one way to one person and another way to someone
gt;gt; gt; else,
gt;gt; gt; where is your audit trail. Especially if such a number is used in a
gt;gt; gt; calculation
gt;gt; gt; -- and I don't know if it is or not.
gt;gt; gt;
gt;gt; gt; You might be able to accomplish something along your lines of being
gt;gt; gt; able to
gt;gt; gt; see something on the display, but not in print using a cell
gt;gt; gt; comment.(if not
gt;gt; gt; used in a calculation).
gt;gt; gt; www.mvps.org/dmcritchie/excel/ccomment.htm
gt;gt; gt;
gt;gt; gt; HTH, David McRitchie, Microsoft MVP, Excel
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;
I'd check out the File gt; Print gt; Properties.......

Maybe the Printer properties are set to print in greyscale or
monochrome......

Vaya con Dios,
Chuck, CABGx3quot;Octavioquot; gt; wrote in message
...
gt; How do you do that Chuck? I changed the font color to white to match the
gt; color of the paper (like you suggested in your first answer) and it did
not
gt; show in the computer, I could not see it in the computer, but it printed.
gt; The color of the background that I work with (and most of us work with) in
gt; the computer is white and also the color of the paper. What else can I
do?
gt; Please advise.
gt;
gt;
gt; quot;CLRquot; gt; wrote in message
gt; ...
gt; gt; You can also set a specific PrintArea in Excel, that will not include
some
gt; gt; data you do not wish to print.....
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt; quot;Octavioquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; Thanks, David, for your advise.
gt; gt;gt; I think that I read sometime ago somewhere how to hide the words when
gt; gt;gt; printing, however, I think it was in the Word program (is that
correct?).
gt; gt; I
gt; gt;gt; was hoping that you could do the same with Excell, but it seems from
all
gt; gt; of
gt; gt;gt; your responses that that is not possible with that program.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; gt; wrote in message
gt; gt;gt; ps.com...
gt; gt;gt; gt; Hi Octavio,
gt; gt;gt; gt; Please stick to this thread where you originally posted. How can
one
gt; gt;gt; gt; trust a
gt; gt;gt; gt; document that looks one way to one person and another way to someone
gt; gt;gt; gt; else,
gt; gt;gt; gt; where is your audit trail. Especially if such a number is used in
a
gt; gt;gt; gt; calculation
gt; gt;gt; gt; -- and I don't know if it is or not.
gt; gt;gt; gt;
gt; gt;gt; gt; You might be able to accomplish something along your lines of being
gt; gt;gt; gt; able to
gt; gt;gt; gt; see something on the display, but not in print using a cell
gt; gt;gt; gt; comment.(if not
gt; gt;gt; gt; used in a calculation).
gt; gt;gt; gt; www.mvps.org/dmcritchie/excel/ccomment.htm
gt; gt;gt; gt;
gt; gt;gt; gt; HTH, David McRitchie, Microsoft MVP, Excel
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;
And what you got was the opposites of what you wanted --
wasn't it?

As far as the print area goes that is under File, Print Area
where you choose the contiguous area that you want to print.
I don't think that is what you want as it sounded like it was
one cell that you did not want to print.

I think to get what you want, displaying everything on the monitor
and not printing certain cell(s), you would have to use a macro
to generate another page, obscuring the cell possibly by the
formatting already suggested. You have to be careful lest you
remove content from a cell if other cells are dependent on the value
as that would change the content and appearance,
then print and discard the created intermediary worksheet.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Octavioquot; gt; wrote in message ...
gt; How do you do that Chuck? I changed the font color to white to match the
gt; color of the paper (like you suggested in your first answer) and it did not
gt; show in the computer, I could not see it in the computer, but it printed.
gt; The color of the background that I work with (and most of us work with) in
gt; the computer is white and also the color of the paper. What else can I do?
gt; Please advise.
gt;
gt;
gt; quot;CLRquot; gt; wrote in message
gt; ...
gt; gt; You can also set a specific PrintArea in Excel, that will not include some
gt; gt; data you do not wish to print.....
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt; quot;Octavioquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; Thanks, David, for your advise.
gt; gt;gt; I think that I read sometime ago somewhere how to hide the words when
gt; gt;gt; printing, however, I think it was in the Word program (is that correct?).
gt; gt; I
gt; gt;gt; was hoping that you could do the same with Excell, but it seems from all
gt; gt; of
gt; gt;gt; your responses that that is not possible with that program.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; gt; wrote in message
gt; gt;gt; ps.com...
gt; gt;gt; gt; Hi Octavio,
gt; gt;gt; gt; Please stick to this thread where you originally posted. How can one
gt; gt;gt; gt; trust a
gt; gt;gt; gt; document that looks one way to one person and another way to someone
gt; gt;gt; gt; else,
gt; gt;gt; gt; where is your audit trail. Especially if such a number is used in a
gt; gt;gt; gt; calculation
gt; gt;gt; gt; -- and I don't know if it is or not.
gt; gt;gt; gt;
gt; gt;gt; gt; You might be able to accomplish something along your lines of being
gt; gt;gt; gt; able to
gt; gt;gt; gt; see something on the display, but not in print using a cell
gt; gt;gt; gt; comment.(if not
gt; gt;gt; gt; used in a calculation).
gt; gt;gt; gt; www.mvps.org/dmcritchie/excel/ccomment.htm
gt; gt;gt; gt;
gt; gt;gt; gt; HTH, David McRitchie, Microsoft MVP, Excel
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;
There is Print Bamp;W in File, Page setup, sheets
that is going to print text as black, and remove fill color.

There is the high contrast setting that would hide
material from being displayed but would print.
support.microsoft.com/?id=320531www.mvps.org/dmcritchie/excel/colors.htm
www.mvps.org/dmcritchie/excel/colors_print.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;CLRquot; gt; wrote in message ...
gt; I'd check out the File gt; Print gt; Properties.......
gt;
gt; Maybe the Printer properties are set to print in greyscale or
gt; monochrome......
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt; quot;Octavioquot; gt; wrote in message
gt; ...
gt; gt; How do you do that Chuck? I changed the font color to white to match the
gt; gt; color of the paper (like you suggested in your first answer) and it did
gt; not
gt; gt; show in the computer, I could not see it in the computer, but it printed.
gt; gt; The color of the background that I work with (and most of us work with) in
gt; gt; the computer is white and also the color of the paper. What else can I
gt; do?
gt; gt; Please advise.
gt; gt;
gt; gt;
gt; gt; quot;CLRquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; You can also set a specific PrintArea in Excel, that will not include
gt; some
gt; gt; gt; data you do not wish to print.....
gt; gt; gt;
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Octavioquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt;gt; Thanks, David, for your advise.
gt; gt; gt;gt; I think that I read sometime ago somewhere how to hide the words when
gt; gt; gt;gt; printing, however, I think it was in the Word program (is that
gt; correct?).
gt; gt; gt; I
gt; gt; gt;gt; was hoping that you could do the same with Excell, but it seems from
gt; all
gt; gt; gt; of
gt; gt; gt;gt; your responses that that is not possible with that program.
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt; gt; wrote in message
gt; gt; gt;gt; ps.com...
gt; gt; gt;gt; gt; Hi Octavio,
gt; gt; gt;gt; gt; Please stick to this thread where you originally posted. How can
gt; one
gt; gt; gt;gt; gt; trust a
gt; gt; gt;gt; gt; document that looks one way to one person and another way to someone
gt; gt; gt;gt; gt; else,
gt; gt; gt;gt; gt; where is your audit trail. Especially if such a number is used in
gt; a
gt; gt; gt;gt; gt; calculation
gt; gt; gt;gt; gt; -- and I don't know if it is or not.
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; You might be able to accomplish something along your lines of being
gt; gt; gt;gt; gt; able to
gt; gt; gt;gt; gt; see something on the display, but not in print using a cell
gt; gt; gt;gt; gt; comment.(if not
gt; gt; gt;gt; gt; used in a calculation).
gt; gt; gt;gt; gt; www.mvps.org/dmcritchie/excel/ccomment.htm
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; HTH, David McRitchie, Microsoft MVP, Excel
gt; gt; gt;gt; gt;
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt; gt;
gt;
gt;