View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Aussie
 
Posts: n/a
Default 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