Maybe add some condition formatting, where if a cell contains the text
"holding for ser #", then make the text white. Enable this conditional
formatting before printing and disable it after printing.

Or alternately, remove the red ink tank from your printer:)


Eagle1 wrote:
I want to be able to omit specified data from printing while still allowing
it to be seen on the spreadsheet when looking at it on the screen....i.e:

a cell value contains the value: "holding for ser #"
when it prints, I want that information to be omitted so we can write the
ser # into the cell space. It's impossible to write in the cell when the
sentence is sitting in it....

help??