User Profile
Ewing89
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
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 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.2KViews0likes4Comments
Groups
Recent Blog Articles
No content to show