How can i hide cells using formula if the cell has no value?

S

Sara

Can anyone help me to "hide" a cell using a formula if it has "no value" and
unhide if it has a value....

Thanks
 
S

Steve

Can anyone help me to "hide" a cell using a formula if it has "no value" and
unhide if it has a value....

Thanks
Click to expand...

Do you mean hide the column or row if the value is zero?
 
G

Gord Dibben

You can make them look blank.

=IF(A1="","",A1) entered in B1


Gord Dibben MS Excel MVP
 
S

Sara

Hi,

Thanks for your effort to help me....

I want to write a formula/macro by which the entire workbook should hide if
all the cells have no value and display the cells in the workbook which has
only values.
 
G

Gord Dibben

You cannot hide cells.

You can hide rows and columns using VBA code or make the cells look blank by
using formulas or custom format of :::

But no "hiding" of individual cells.

Which do you want to do.


Gord Dibben MS Excel MVP
 
Top