K konijay New Member Dec 3, 2012 #1 Hello masters... I need to do 1. Find cells with value = 0 on column B 2. hide the rows with those cells thank you
Hello masters... I need to do 1. Find cells with value = 0 on column B 2. hide the rows with those cells thank you
Luke M Excel Ninja Staff member Dec 3, 2012 #2 Greetings konijay! This is actually a some-what common question here. If you use the custom Google search in top right for "hide rows based on value" you'll find several other threads that might help. For now, I'd recommend starting here: http://chandoo.org/forums/topic/hide-row-based-on-cell-value?message=spammed User wanted to use 1 as the value, but you could easily adjust to make it look for 0.
Greetings konijay! This is actually a some-what common question here. If you use the custom Google search in top right for "hide rows based on value" you'll find several other threads that might help. For now, I'd recommend starting here: http://chandoo.org/forums/topic/hide-row-based-on-cell-value?message=spammed User wanted to use 1 as the value, but you could easily adjust to make it look for 0.