View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lee Harris
 
Posts: n/a
Default 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