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