Blank cells

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

Please help,
I want to convert cells with zero or other values to
blank, so that they are not included in sorting.

Thanks

Rounak
 
Assuming the cells contain literal values (as opposed to the 0's being the result of formulas),
use Edit/Replace, Find What -- 0, Replace With -- leave blank. Do the same for other values.
 
Back
Top