User Profile
CDJay
Copper Contributor
Joined Mar 05, 2021
User Widgets
Recent Discussions
Re: How to prevent selected cells from printing, but have them visible?
BobsYourUncle54 Another idea is by using filters. Have a column with an If/Then Statement with either 0 or 1 as the choices. In your application, it might be "=If(SellingPrice > 0, 1, 0)". So if no units are input for a product, the entry in this outer column remains 0, but it changes to 1 when the proposal shows any quantity of units. Then apply a filter on that column. When you uncheck 0 as an option, it will hide those rows. Make sure to set your print range to not include the outer column. Sometimes, you can hard code a 0 into a cell when the If/Then isn't quite applicable.84KViews0likes0Comments
Recent Blog Articles
No content to show