Is there a way to format individual cells so that the values are visible
normally but don't print? These cells are in the middle of the print area,
so they can't simple be excluded by setting a print area that doesn't cover
these cells.

I can't just hide rows or columns as there are other values that need to be
included in the printout and so can't be hidden. I need a print area with
holes in it.

The long way would be to write a macro that selects all the cells, formats
the cells so that the values don't display, prints worksheet, and then
selects same cells and restores formatting. But this would be a hassle to
update with additional cells.

I was wondering if there was a more elegant way - perhaps an attribute that
can be set in the format cell dialogue box, like the 'Hidden' attribute on
the protection tab for displaying formula?

Thanks in advance,

Glen