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

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

"Dennis1188" wrote:

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

Hi Dennis

If you don't really need to delete them, but just want to suppress them,
you could use
ToolsoptionsViewuncheck Zero values

--
Regards

Roger Govier


"Dennis1188" wrote in message
...
Is there a way to quickly find and delete all zero value cells?

Sorting by column did the trick... THANKS.

"Michael" wrote:

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

"Dennis1188" wrote:

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