| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Value shows but should not print
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A cell in an excel spreadsheet that does not print but shows in pr | Excel Discussion (Misc queries) | |||
| How can I print current row in same place on paper but not print surrounding cells??? | New Users to Excel | |||
| How do I get rid of a black box that shows up when I print excel? | Excel Discussion (Misc queries) | |||
| One spreadsheet cell won't print but shows up in print preview? | Excel Discussion (Misc queries) | |||
| Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Threaded Mode
