ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hiding text so it doesn't print (https://www.excelbanter.com/excel-worksheet-functions/42337-hiding-text-so-doesnt-print.html)

MrEMann

Hiding text so it doesn't print
 

This sounds so easy, why am I having trouble. I want to set some cells
so I can see them but so that they do not print out on the final
document.
Thanx.


--
MrEMann
------------------------------------------------------------------------
MrEMann's Profile: http://www.excelforum.com/member.php...o&userid=26625
View this thread: http://www.excelforum.com/showthread...hreadid=399030


Paul B

MrEMann, have a look here for ways to do it

http://www.rondebruin.nl/print.htm#Hide
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"MrEMann" wrote in
message ...

This sounds so easy, why am I having trouble. I want to set some cells
so I can see them but so that they do not print out on the final
document.
Thanx.


--
MrEMann
------------------------------------------------------------------------
MrEMann's Profile:
http://www.excelforum.com/member.php...o&userid=26625
View this thread: http://www.excelforum.com/showthread...hreadid=399030




Ron de Bruin

Try this

http://www.rondebruin.nl/print.htm#Hide

Make the font white is maybe a option for you
See the example

--
Regards Ron de Bruin
http://www.rondebruin.nl


"MrEMann" wrote in message
...

This sounds so easy, why am I having trouble. I want to set some cells
so I can see them but so that they do not print out on the final
document.
Thanx.


--
MrEMann
------------------------------------------------------------------------
MrEMann's Profile: http://www.excelforum.com/member.php...o&userid=26625
View this thread: http://www.excelforum.com/showthread...hreadid=399030





All times are GMT +1. The time now is 03:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com