Dont print zero's

N

Niels Danstrup

I wish to print a spreadsheet with 500 cells

I wish to print those cells, which have a value=0 (zero) as blanks.

Is it possible?
 
N

Niek Otten

Tools>Options>View tab, uncheck Show zero values

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I wish to print a spreadsheet with 500 cells
|
| I wish to print those cells, which have a value=0 (zero) as blanks.
|
| Is it possible?
|
|
 
Top