Not printing cells

[qmdm]

I want to print a sheet, but I don't want to print some specific cell
that are in the middle of the sheet.
So far I’ve tried selecting the print an area and then deselecting th
specific cells that I don’t want to print. But that doesn’t work.

Greeting

Maarte

 

[Frank Kabel]

Hi
not possible as the printarea has to be a contigenous range. You may
use a macro for this and format the cells prior to printing within the
macro with a white font

Easies way: record a macro with the following steps:
- select your sheet
- select the cells and apply a format
- print the sheet
- reset the cell format

 

[Debra Dalgleish]

You can use conditional formatting to change the cells to a white font
when you're ready to print. There are instructions here:

http://www.contextures.com/xlCondFormat03.html#Print

 

[Guest]

Select the cells that you want to print
Select File
Select Print
Select Selection
Print.