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?
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top