April 9, 2024
Contribute to the Microsoft 365 and Office forum!
Click here to learn more 💡
May 10, 2024
Excel Forum Top Contributors:
Don't want certain cells to print (but I want them visible on screen).
Report abuse
Thank you.
Reported content has been submitted
Ron de Bruin shares a couple of macros that hide rows/columns or changes the
font color to match the fill color, then prints, then resets things.
Another option if you don't want to use macros is to use conditional formatting
to hide the values in the cells using the same font color as fill.
For example, you could use a conditional formatting formula like:
=$x$1="Print"
And apply it to the range you want.
Then change that value in X1 to Print, print the worksheet, then clear that
cell.
cynergy wrote:
Is there any way to format cells so they don't print but they are visible on-screen?
--
Dave Peterson
Report abuse
Thank you.
Reported content has been submitted
20 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Nice ideas, Dave.
I was thinking of something like redefining a Style but the conditional formatting idea is better.
cynergy: the Ron de Bruin examples are at http://www.rondebruin.nl/print.htm
Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk
Report abuse
Thank you.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Question Info
Last updated December 4, 2023 Views 29,199 Applies to: