Delete all zero values

[Guest]

Is there a way to quickly find and delete all zero value cells?

 

[Guest]

If you want to clear the cells then use edit replace put 0 in the find space
and nothing in the replace space.
if you want to delete the entire cell, sort the column then delete the cells

 

[Roger Govier]

Hi Dennis

If you don't really need to delete them, but just want to suppress them,
you could use
Tools>options>View>uncheck Zero values

 

[Guest]

Sorting by column did the trick... THANKS.

If you want to clear the cells then use edit replace put 0 in the find space
and nothing in the replace space.
if you want to delete the entire cell, sort the column then delete the cells