Auto hide row

[Redcurrant]

Hi all,

I'm looking for a way to automatically hide an entire row if a cell contains 0.

I've tried conditional formatting, using ;;;, but all that does is hide the content of the row. I'm looking to make the whole row physically hide.

Any ideas?

 

[Marc L]

Hi, without an elaboration at the level any Excel forum expects for​

so just activating the Macro Recorder and operating manually in order to get your own base code …​

​

 

[Redcurrant]

I know I could record a macro, but is there any way to get a row to automatically hide itself if a cell in that row contains a 0?

 

[Marc L]

Maybe via a VBA worksheet event procedure with the necessary coded …​

​

 

[Redcurrant]

I guess that makes sense

To explain better, I'm entering info into sheet one, that is then populated in part into sheet 2, formatting some cells in sheet 1 into a single cell in sheet 2; but if a row in sheet 1 has no data inputted, I don't even want to see the row in sheet 2, so I'm not looking at loads of 0s.

Some trial and error awaits I reckon.

 

[Marc L]

As you can desactivate the display of zero values within the worsheet advanced options so nothing to code ! …​

​

 

[Redcurrant]

Nah, all that does is remove the contents of the cells. What I want is for the entire row to be automatically filtered so you cannot even see the row. Eg, if row 10 has a 0 in A1, then the whole row becomes hidden