Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Octavio
 
Posts: n/a
Default How can I hide the words of a cell (or a group of cells)...

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


  #2   Report Post  
Posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default How can I hide the words of a cell (or a group of cells)...

zOne way is to change the font color to the same as the background color of
the cell(s)

Vaya con Dios,
Chuck, CABGx3



"Octavio" wrote:

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



  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben
 
Posts: n/a
Default How can I hide the words of a cell (or a group of cells)...

Or format as custom ;;; if this is feasible.


Gord Dibben MS Excel MVP

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

zOne way is to change the font color to the same as the background color of
the cell(s)

Vaya con Dios,
Chuck, CABGx3



"Octavio" wrote:

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




  #4   Report Post  
Posted to microsoft.public.excel.newusers
 
Posts: n/a
Default How can I hide the words of a cell (or a group of cells)...

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).
http://www.mvps.org/dmcritchie/excel/ccomment.htm

HTH, David McRitchie, Microsoft MVP, Excel

  #5   Report Post  
Posted to microsoft.public.excel.newusers
Octavio
 
Posts: n/a
Default How can I hide the words of a cell (or a group of cells)...

Thanks, 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.



wrote in message
ps.com...
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).
http://www.mvps.org/dmcritchie/excel/ccomment.htm

HTH, David McRitchie, Microsoft MVP, Excel





  #6   Report Post  
Posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default How can I hide the words of a cell (or a group of cells)...

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, CABGx3


"Octavio" wrote in message
...
Thanks, 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.



wrote in message
ps.com...
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).
http://www.mvps.org/dmcritchie/excel/ccomment.htm

HTH, David McRitchie, Microsoft MVP, Excel





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfer Cell Formatting for linked cells Scott Excel Discussion (Misc queries) 2 November 23rd 05 11:04 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
How do I make a cell equal to another cells value and not it's fo. TroutKing Excel Worksheet Functions 2 January 17th 05 06:15 PM
How do I link many cells to one particular cell? fish@divi Excel Discussion (Misc queries) 2 January 4th 05 11:00 PM
copy group of cells to another group of cells using "IF" in third Chuckak Excel Worksheet Functions 2 November 10th 04 06:04 PM


All times are GMT +1. The time now is 06:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"