Blank cells

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
 
M

Myrna Larson

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.
 
Top