Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidding zero values
Hi all,
I know how to hide all zero values in 2003, but the problem is only want to hide zero values of selected rows. Is there anyway to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidding zero values
You would probably be best using formula =IF(A1=0,"",A1) A simplistic view of the formula but thats it, or you can create a custom view if they are always the same cells at the same time. Steve J;579642 Wrote: Hi all, I know how to hide all zero values in 2003, but the problem is only want to hide zero values of selected rows. Is there anyway to do this? -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160285 Microsoft Office Help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidding zero values
On 7 dec, 15:45, Steve J wrote:
Hi all, I know how to hide all zero values in 2003, but the problem is *only want to hide zero values of selected rows. Is there anyway to do this? Hi Steve, Try your luck with conditional format. As conditoon use value= zero As format make the font color the same as the interiour color. HTH, Radareye. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidding zero values
I don't think you can directly hide zero values only in selected rows.
You can change formulas to result in "" if the result =0, but this can cause other problems. The easiest way would be to use an accounting number format, 0 shows as -. While is is not totally hidden, it is better than a bunch of 0's. If you dont like the "-", customize the number format to use " " instead _(* #,##0.00_);_(* (#,##0.00);_(* " "??_);_(@_) is the accounting format with - removed. The (* " "??_) section used to be (* "-"??_) -- If this helps, please remember to click yes. "Steve J" wrote: Hi all, I know how to hide all zero values in 2003, but the problem is only want to hide zero values of selected rows. Is there anyway to do this? . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidding zero values
RadarEye wrote in news:573e1ff3-2559-4ceb-88c1-
: On 7 dec, 15:45, Steve J wrote: Hi all, I know how to hide all zero values in 2003, but the problem is *only wa nt to hide zero values of selected rows. Is there anyway to do this? Hi Steve, Try your luck with conditional format. As conditoon use value= zero As format make the font color the same as the interiour color. HTH, Radareye. Tried both and work great! thx guys |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidding zero values
You might also try conditional formatting - set the font color to the cell
background color if that cell's value is zero. HTH, Eric "Steve J" wrote: Hi all, I know how to hide all zero values in 2003, but the problem is only want to hide zero values of selected rows. Is there anyway to do this? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hidding #DIV/0! In Cell | Excel Worksheet Functions | |||
Hidding #DIV/0! In Cell | Excel Worksheet Functions | |||
Hidding #DIV/0! In Cell | Excel Worksheet Functions | |||
Hidding #DIV/0! In Cell | Excel Worksheet Functions | |||
Hidding Tabs | Excel Discussion (Misc queries) |