View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Michael Michael is offline
external usenet poster
 
Posts: 791
Default 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?