software

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.

Use Autofilter:

Put a header or label cell on top of column A. Then pull-down Data gt; Filter
gt; Autofilter and specify Show rows where the header cell does not equal zero.This will hide all the rows for which the A-cell is zero.--
Gary's Studentquot;mdayquot; wrote:

gt; hello,
gt;
gt; I would like to hide a row when the first cell in that row = 0.
gt;
gt; basically somthing along the lines of =IF(A1=0,hiderow,unhiderow)
gt;
gt; I can hide rows but the file must be unprotected to change which rows are
gt; hidden. With numerous people working with the file i would rather not risk
gt; people deleting formulas on accident.