F5 function for zeroes?

L

Lee Harris

Can you do a similar trick to F5->Special-> etc to select all 0 values in a
range and then delete them, like you can with #n/a and errors
 
R

Ron Coderre

See if this helps:

I'm not sure which versin of Excel first featured this....

Edit>Find
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
 
L

Lee Harris

Ron Coderre said:
See if this helps:

I'm not sure which versin of Excel first featured this....

Edit>Find
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
Click to expand...


magic - that works just fine, many thanks Ron
 
D

Dave Peterson

Another option would be to edit|replace 0 with #n/a

Then you could use the F5 stuff to clear the errors.
 
Top