Block deleting all zeros at once.

Ben · Dec 11, 2003

In Excel2003 Is there a way of block deleting all zero
values from 3 columns of data. If not could anyone
suggest a function to do this.
Thank you

Jim Rech · Dec 11, 2003

Use Find and Replace, replacing "0" with nothing. Be sure to select the
"Match entire cell contents" option.

Jim Rech · Dec 11, 2003

Oh, be sure to select the range before you do this or the entire sheet will
be searched.