Highlighting Cells without Printing

  • Thread starter Thread starter Alison Ernst
  • Start date Start date
A

Alison Ernst

Is there any way to format cells so that they appear highlighted on the
screen, but do not show the highlighting when the worksheet is printed?
Thanks,

Alison
 
You can't highlight cells per se (you can apply shading, but that won't do
what you want). You can highlight text in the cells, and the highlighting
will print only if it's displayed. If you disable "Highlight" on the View
tab of Tools | Options, the highlighting will still be present but will not
be displayed and will not print.
 

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

Excel Highlighting duplicates 0
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
Excel Staff Grade and Shift 0
Excel Typed text appears in wrong cell 0
Highlighting shows on screen-not on printed copy 1
Excel Excel Conditional Format 2
highlighting words or lines 2

Back
Top