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

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

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

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

"Aussie" wrote in message
...
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