D
Dennis1188
Is there a way to quickly find and delete all zero value cells?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Michael
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
and nothing in the replace space.
if you want to delete the entire cell, sort the column then delete the cells
R
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
If you don't really need to delete them, but just want to suppress them,
you could use
Tools>options>View>uncheck Zero values
D
Dennis1188
Sorting by column did the trick... THANKS.
Michael said: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