F5 function for zeroes?
"Ron Coderre" wrote in message
...
See if this helps:
I'm not sure which versin of Excel first featured this....
EditFind
Find what: 0 <-zero
Click the [Find All] button
(That will select the first zero, but all other "hits" will be listed in
the
lower section of the Find window)
NEXT...while still in the window...
Press [Ctrl]+A (to select all items)
(All cells with zero should now be selected)
Click the [Close] button to close the window.
Press the [Delete] key to clear the contents of the seleted cells
Does that help?
***********
Regards,
Ron
magic - that works just fine, many thanks Ron
|