How to not print some cells

  • Thread starter Thread starter pawlingJohn
  • Start date Start date
P

pawlingJohn

I have a validated cell that populates other cells when a value is selected.
I do not however want that cell to print. What can I do?

Thanks in advance
 
Another suggestion:
Use conditional formatting on the cells that you do not want to print.
In a cell somewhere on your worksheet (for instance H1) type in No
Then your conditional formating will be if H1="No" then change the font to
white (and will not be printed) if you delte "No" from cell H1 you will then
be able to see and easily change the data you have entered!
 
the problem is that the cell contains a drop-down list.
Click to expand...

I guess I haven't tried, perhaps. But doesn't changing the font to
"white" work? I do this all the time with normal cells.

If necessary, move the drop-down to its own row/column. This may help
set it apart anyway for users to see it better. Then keep that row/
column out of the print area.
 
Thanks Michael, Ron and Spiky. It was so simple that I overlooked the obvious.
Have a great holiday.
 
Back
Top