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

[Aussie]

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

 

[ANdras]

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)

 

[David Biddulph]

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