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

  • Thread starter Thread starter Sara
  • Start date Start date
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
 
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?
 
You can make them look blank.

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


Gord Dibben MS Excel MVP
 
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.
 
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
 
You must log in or register to reply here.

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

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Macro to hide sheets based upon cell value 3
Run a macro based on a cell value 1
Hide Underlying Cell Formulas 1
#Value! error in cell 4
hide, unhide column or row after protect worksheet 4
formula to hide a row in excel 2007 7
Data Validation List Macro 18

Back
Top