on a selected area in the worksheet.
T Teethless mama Dec 25, 2006 #2 Select your range then go to menu Data > Filter > AutoFilter > Blanks > enter all 0
G Gord Dibben Dec 25, 2006 #3 Another method.......... Select the range. F5>Special>Blanks>OK Type 0 in active cell then hit CTRL + ENTER Gord Dibben MS Excel MVP
Another method.......... Select the range. F5>Special>Blanks>OK Type 0 in active cell then hit CTRL + ENTER Gord Dibben MS Excel MVP
