forgotten

[Beeel]

Hi
I haven't been working for a while and have forgotten how to hide zeros in a
part of a spreadsheet

Barry

 

[Max]

Try:

Tools > Options > View tab > Uncheck "Zero values" > OK

 

[Ron de Bruin]

Hi Beeel

You can change it here

Tools>Options>View

 

[Dave Peterson]

If it's just part of a worksheet, you can use a custom format like:

General;-General;;@


if the values are the results of a formula, you could do something like:

=if(yourformula=0,"",yourformula)

 

[Beeel]

Thanks those who sent replies. I only need zeros suppressed in one range not
the whole sheet.
I have formatted cells "0;-;;@" which works but someone once showed me
simple keystroke method
which I believe was CTRL and something

Barry