Hide row if dollar amount is zero

[Karl Irvin]

How do you hide a row if an amount on the row is zero?

Can this be done for some rows and not others?

Thanks

 

[Bob Phillips]

Simplest way - put a filter (Data>Filter>Autofilter) on the column and
filter a zero value.

Some and not others? What determines?

 

[Karl Irvin]

Its for a financial statement

Current Assets
Cash 1
A/R 2
Inv
Total 3

Fixed Assets
Cars 4

I need to drop just the Inv row.

 

[Bob Phillips]

So does the filter work?

--
HTH

Bob Phillips

Its for a financial statement

Current Assets
Cash 1
A/R 2
Inv
Total 3

Fixed Assets
Cars 4

I need to drop just the Inv row.

 

[Karl Irvin]

The autofilter doesn't work. I tried the advanced filter and it doesn't work
either.

 

[Dave Peterson]

How about using a helper column of cells.

Then put something like:

=a2&b2
and drag down your range.
(column A contains the description (INV) and column B contains the value (blank
or 0).

Then custom filter on that column:
does not equal: inv
and
does not equal: inv0

(not sure what to do with blanks next to INV.)