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