Hiding Rows when a cell = 0

M

mday

hello,

I would like to hide a row when the first cell in that row = 0.

basically somthing along the lines of =IF(A1=0,hiderow,unhiderow)

I can hide rows but the file must be unprotected to change which rows are
hidden. With numerous people working with the file i would rather not risk
people deleting formulas on accident.
 
G

Gary''s Student

Use Autofilter:

Put a header or label cell on top of column A. Then pull-down Data > Filter
Autofilter and specify Show rows where the header cell does not equal zero.
Click to expand...


This will hide all the rows for which the A-cell is zero.
 
Top