Block deleting all zeros at once.

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

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
 
Use Find and Replace, replacing "0" with nothing. Be sure to select the
"Match entire cell contents" option.
 
Oh, be sure to select the range before you do this or the entire sheet will
be searched.
 
Back
Top