Excel - if cells = 0, how to conditionally hide rows in chart

fineimage · Nov 11, 2004

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)?

Frank Kabel · Nov 11, 2004

Hi
this would require VBA. But why not use a simple filter ('Data -
filter')?

Excel - if cells = 0, how to conditionally hide rows in chart

fineimage

Frank Kabel