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??

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??

that could help, but I was looking for some way to set it up in "page set
up" so that I could preselect either a value, or a font color, et. al, that
the program would recognize and then 'not' print.....something along the
lines of choosing what "print areas" not to print, only I would be selecting
what "font colors" not to print, such as red for example.....I'm relatively
sure that it can't be done now, but in my mind, I can see that such an option
'could' be made available by MS if they had enough demand for it.


"S Davis" wrote:

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??