See but does not print

  • Thread starter Thread starter Turnipboy
  • Start date Start date
T

Turnipboy

Is there a way to get text to be visible in various scattered cells o
screen, but not appear in a print
 
You could change the font color to match the fill color (white on white) or even
change the numberformat to a custom format of ;;; (3 semicolons)--then change
back after you print.

Ron de Bruin has some tips at:
http://www.rondebruin.nl/print.htm#Hide
Look for "Make the Font white of a range"
 
That is something I considered, I was wondering if there was a simpler
way that also allowed you to see the 'hidden' cells' contents
 
Thanks, some of the ideas in the link you posted are very usefu
 
You must log in or register to reply here.

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

Scatter plot / Data from matrices? 1
Epson XP-3150 not printing 2
Excel Borders not printing in Excel 8
Ranking Only Visible Cells 5
Excel won't print 2
Epson Printer Problem 6
Problem printing underlines 1
See Text, Not Print Text 1

Back
Top