Non printing cels

[wbco]

Hi Guys!

Is there a way to have a certain cell that is inside a print range to not print? For example... my print range is A1 thru F10. But I have data in cell C5 and that should never be shown on the printout. Is there any way to make that one cell always be non printable?

Thanks in advance for any help!

-j

 

[Rick Rothstein]

Is there a way to have a certain cell that is inside a print range to not print? For example... my print range is A1 thru F10. But I have data in cell C5 and that should never be shown on the printout. Is there any way to make that one cell always be non printable?

I haven't test this, but I think it should work. Select the cell (or cells) you want to hide from the printout and Custom Format it with this Type pattern...

;;;

That will make the cell's content disappear on the worksheet... I think it should do the same for the print out.

 

[wbco]

Hi Rick,

Thank you for the reply. That does hide the data, but I forgot to mention I need the data to display on screen... just not printable... so that doesn't work for me

I haven't test this, but I think it should work. Select the cell (or cells) you want to hide from the printout and Custom Format it with this Type pattern...

;;;

That will make the cell's content disappear on the worksheet... I think it should do the same for the print out.

 

[Rick Rothstein]

Thank you for the reply. That does hide the data, but I forgot to mention I need the data to display on screen... just not printable... so that doesn't work for me

Then let's make it conditional then. Find a cell on the worksheet that will never be used and will never be in the print range for that sheet, for this example, let us say that cell is K1... if that cell is empty, then we will show the contents of cell C5 and if the cell is not empty, we will hide the contents of cell C5. Select cell C5 and click the Conditional Formatting button (Home tab, Styles panel)... select "New Rules..." on the popup menu that appears... select "Use a formula to determine which cells to format" on the dialog box that appears... put this formula in the "Format values where this formula is true:" field...

=LEN($K$1)>0

then click the "Format..." button, select the Number tab, click Custom in the Category list and put ;;; in the Type field and OK your way back to the work sheet. Now, when you want to print the sheet, type any text (one or more characters) into cell K1. After you have finished printing, simply delete the contents of cell K1.

 

[wbco]

Ahh ok thank you again Rick. This will do the trick. I hope someone day it will be as easy as a right-click "do not print contents of this cell".