Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel - if cells = 0, how to conditionally hide rows in chart
In a worksheet that summarizes other pages, I would like to hide rows that
have no balance (zero value), so that only rows with values show. Can this be done automatically? 'If cell range B2:C2 = zero, hide row)? |
#2
|
|||
|
|||
Hi
this would require VBA. But why not use a simple filter ('Data - filter')? -- Regards Frank Kabel Frankfurt, Germany "fineimage" schrieb im Newsbeitrag ... In a worksheet that summarizes other pages, I would like to hide rows that have no balance (zero value), so that only rows with values show. Can this be done automatically? 'If cell range B2:C2 = zero, hide row)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
hide column but show chart | Charts and Charting in Excel | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Chart disappears when source data cells are hidden | Excel Discussion (Misc queries) |