dear sirs

i have some columns with formula.


by default these columns show 0 values.
but i want to hide the columns/cells if the
value is 0.

how can i do it?

please help.

m s narayanan

Your subject asks how to unhide. Your message says you want to hide. Have you decided which?

Do you want to hide the actual columns or the zero values?

Dear sir

I want to hide o values

M s Narayanan

Haven't got XL here.
Somewhere in the options you can uncheck "show zero values"

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

File > Options > Advanced > Display options for this worksheet > Show a zero value in cells that have zero value