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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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).
Click to expand...

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