| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i hide cells using formula if the cell has no value?
Can anyone help me to "hide" a cell using a formula if it has "no value" and
unhide if it has a value.... Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i hide cells using formula if the cell has no value?
On May 21, 11:33*am, Sara wrote:
Can anyone help me to "hide" a cell using a formula if it has "no value" and unhide if it has a value.... Thanks Do you mean hide the column or row if the value is zero? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i hide cells using formula if the cell has no value?
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. "Steve" wrote: On May 21, 11:33 am, Sara wrote: Can anyone help me to "hide" a cell using a formula if it has "no value" and unhide if it has a value.... Thanks Do you mean hide the column or row if the value is zero? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i hide cells using formula if the cell has no value?
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 On Thu, 22 May 2008 10:38:02 -0700, Sara wrote: 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. "Steve" wrote: On May 21, 11:33 am, Sara wrote: Can anyone help me to "hide" a cell using a formula if it has "no value" and unhide if it has a value.... Thanks Do you mean hide the column or row if the value is zero? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i hide cells using formula if the cell has no value?
You can make them look blank.
=IF(A1="","",A1) entered in B1 Gord Dibben MS Excel MVP On Wed, 21 May 2008 08:33:00 -0700, Sara wrote: Can anyone help me to "hide" a cell using a formula if it has "no value" and unhide if it has a value.... Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect individual cell and hide formula in formula bar | Excel Worksheet Functions | |||
| Can we have cells pop up with a formula & hide if not want | Excel Worksheet Functions | |||
| HOW DO I HIDE FORMULA IN A CELL | Excel Discussion (Misc queries) | |||
| How can I hide the words of a cell (or a group of cells)... | New Users to Excel | |||
| How do I hide the zero in the "sum" cell until numbers are put in the cells that are being added? | Excel Worksheet Functions | |||
Hybrid Mode
