Value shows but should not print

Hi all! I was wondering if there's any way to format a cell such that its value shows normally but when the worksheet is printed, that cell's value is not printed out. Any help on this would be greatly appreciated!

If an entry is literally in a cell, and visible, I think it will print. You
might consider using a Drawing toolbar Text Box. Via its right-click Format
menu you can set it not to print and you can set it to No Border so that
what is in it looks just like a cell entry.

--
Jim
"uberathlete" <[email protected]>
wrote in message
news:[email protected]...
|
| Hi all! I was wondering if there's any way to format a cell such that
| its value shows normally but when the worksheet is printed, that cell's
| value is not printed out. Any help on this would be greatly appreciated!
|
|
| --
| uberathlete
| ------------------------------------------------------------------------
| uberathlete's Profile:
http://www.excelforum.com/member.php...o&userid=28388
| View this thread: http://www.excelforum.com/showthread...hreadid=480622
|

Another option...

Pick a cell out of the print range (maybe on another sheet???)

Then put Hide or Show in that cell.

Then use a formula in the cells to hide:

=if(sheet2!$a$1="hide","","your constant value here")
or
=if(sheet2!$a$1="hide","",yourformulahere")

Then just toggle that cell's value before you print.

uberathlete wrote:
>
> Hi all! I was wondering if there's any way to format a cell such that
> its value shows normally but when the worksheet is printed, that cell's
> value is not printed out. Any help on this would be greatly appreciated!
>
> --
> uberathlete
> ------------------------------------------------------------------------
> uberathlete's Profile: http://www.excelforum.com/member.php...o&userid=28388
> View this thread: http://www.excelforum.com/showthread...hreadid=480622

--

Dave Peterson