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