Forum Discussion
Create a cell style that clears its display formatting prior to printing
Hi, I would like to create a cell style that displays a certain way when working on the spreadsheet but clears that formatting when printed or saved to PDF. For example, I'm creating a templa...
Well, I'm not sure that can be done -- "Hit print" in the normal fashion, and have that action in-and-of-itself cause the cells to change format. But I am not a VBA/macro person at all..so I'll defer to those who are.
In the meantime, assuming these people are able to follow simple instructions (which must be true if they're filling in an Excel spreadsheet in the first place), the method I was suggesting would work.
Come to think of it, to print to PDF requires its own separate step beyond "Hit print" doesn't it? Again, maybe there's a VBA/macro routine that could incorporate all of it, but if I were in your spot, I'd worry that we might be making a simple task more complicated and, potentially, error prone.
What I was hoping for is something similar to AutoCAD where you have a printing style set in the document so you can draft in one way but have it print in a way that is easier to read for clients etc. This would be useful in Excel for people making a lot of templates or forms so it is user friendly for the people filling out the form but then prints in an organized and clear fashion.
Thanks for your suggestions though. I will take them on board for now.
Thanks for your suggestions though. I will take them on board for now.