F5 function for zeroes?

[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

 

[Guest]

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

 

[Lee Harris]

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

magic - that works just fine, many thanks Ron

 

[Dave Peterson]

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

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