Delete all zero values
 

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

Delete all zero values
 

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?

Delete all zero values
 

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?

Delete all zero values
 

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?