ExcelBanter - Is there a way to conditionally hide a row?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Is there a way to conditionally hide a row? (https://www.excelbanter.com/excel-discussion-misc-queries/28579-there-way-conditionally-hide-row.html)

Maxwell Sprinkler

Is there a way to conditionally hide a row?

I'd like for Excel to automaticalliy hide a row if the value in a given cell
is equal to zero.

Dave Peterson

Can you apply Data|Filter|Autofilter
and do a custom filter of not equal to 0?

(Not quite automatic, but pretty darn effective.)

Maxwell Sprinkler wrote:

I'd like for Excel to automaticalliy hide a row if the value in a given cell
is equal to zero.

--

Dave Peterson

All times are GMT +1. The time now is 03:52 AM.