how to omit printing data highlighted in red

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:)
 
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:)
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Omit empty cells? 0
Omit some cells, when take print 2
Omitting a row during printing 1
Spurious Formula Omits Adjacent Cells 2
How do I paste in sorted area? 4
Omitting blank cells until filled in? 3
How to omit blank cells when calculating weighted averages 20
Omit the first word from a cell contain text 7

Back
Top