View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pawlingJohn pawlingJohn is offline
external usenet poster
 
Posts: 19
Default How to not print some cells

Thanks Michael, Ron and Spiky. It was so simple that I overlooked the obvious.
Have a great holiday.

"Spiky" wrote:

On Dec 19, 10:25 am, pawlingJohn
wrote:
the problem is that the cell contains a drop-down list.


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.