Thread: Can anyone tell me how to hide rows that have 0 values and text.

I am trying to hide rows in an Excel Spreadsheet that my boss wants me to do.
I have rows with text and numbers in them and I have rows with text and 0
values in them. I want to only hide those rows - found out how to hide the 0
values but not how to hide the whole row with out going through each of them
one by one (very time consuming).

Thanks for any suggestions.
Tracey

Hi Tracey,

you might want to consider:
xls database (rows = records, columns = fields), you add 1 more column, as a
filter, named e.g. 'zero_row?': type in the cells =if(A1=0;0;1) , copy this
function to all rows' cell (or autofill to the database), then in a) the
autofilter or b) PivotTable you can filter to 1 value, to show only those
rows where the value is <> 0.

i hope this helps, (at least, i use it this way :-) ),
have fun,
ANrdas
(Hungary)

"Aussie" wrote:

> I am trying to hide rows in an Excel Spreadsheet that my boss wants me to do.
> I have rows with text and numbers in them and I have rows with text and 0
> values in them. I want to only hide those rows - found out how to hide the 0
> values but not how to hide the whole row with out going through each of them
> one by one (very time consuming).
>
> Thanks for any suggestions.
> Tracey

"Aussie" <Aussie@discussions.microsoft.com> wrote in message
news:29C77399-BD3D-4D00-B820-002EC3E662A9@microsoft.com...
>I am trying to hide rows in an Excel Spreadsheet that my boss wants me to
>do.
> I have rows with text and numbers in them and I have rows with text and 0
> values in them. I want to only hide those rows - found out how to hide the
> 0
> values but not how to hide the whole row with out going through each of
> them
> one by one (very time consuming).

Have you tried Data/ Filter/ Autofilter?
Select column with zero and non-zero numbers. Custom/ does not equal/ 0
--
David Biddulph