Hello,

I'm trying to hide rows that have a zero value in them, but everytime i put a code in the whole silly sheet hides!!

YEAR FLOORS STATUS INITIATOR (If Planned)
2012 All Planned Landlord
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0


Thats what I get with my IF formula - now I just want to hide the 0 rows until they are populated with valid criteria. so Hide rows if value = 0 .... Please help!

I remember another way to do this about 4 years ago ... with a filter option maybe but I just can't remember.