Hide Row in Excel Sheet

R

Rupesh

I have a excel sheet with following data
data1 data2 total
Day1 5 4 9
Day2 5 6 11
Day3 0 0 0
Day4 4 5 9
Day5 3 5 8
Day6 0 0 0
Day7 0 0 0
Day8 6 5 11
Day9 0 0 0
Day10 8 8 16

now i want to hide the row whose total is equal to 0. as an above dat
day3,day6,day7,day9 shoud be hide. pls suggest what could be the meho
for this
 
M

Mbt6

Rupesh said:
I have a excel sheet with following data
data1 data2 total
Day1 5 4 9
Day2 5 6 11
Day3 0 0 0
Day4 4 5 9
Day5 3 5 8
Day6 0 0 0
Day7 0 0 0
Day8 6 5 11
Day9 0 0 0
Day10 8 8 16

now i want to hide the row whose total is equal to 0. as an above data
day3,day6,day7,day9 shoud be hide. pls suggest what could be the mehod
for this.
Click to expand...

What about turning on AutoFilter, and then filtering on the column to hide
and create a custom rule such as Does Not Equal 0
 
Top