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
|