User Profile
Ewing89
Copper Contributor
Joined Sep 17, 2023
User Widgets
Recent Discussions
Re: Create a cell style that clears its display formatting prior to printing
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.1.1KViews0likes0CommentsRe: Create a cell style that clears its display formatting prior to printing
mathetes Hi, It will be others doing the printing so I'd like it as automated as possible. Ideally they'd just fill in the required info and hit print. Then the input cells show up on the pdf as normal cells. Cheers1.4KViews0likes2CommentsCreate 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 template to be used by others and would like to highlight the cells that require manual input but when these sheets are printed for clients etc. those input cells appear as a regular cell as opposed to the input cell style. Essentially would like to set a "display" cell style and a "print" cell style. Is there a setting within Excel that achieves this without needing macros?1.7KViews0likes4Comments
Recent Blog Articles
No content to show