Tools Options View tab

Uncheck the zero values box.

Ian

"John" wrote in message
...
I've created a workbook that totals 5 worksheets (for Monday thru Friday)
on
a 6th worksheet that is printed and posted weekly. However, because there
is
a formula in each cell on the weekly sheet, a zero appears in all of the
cells which makes the sheet being posted look too too busy... Is there a
way
to have the weekly worksheet leave all cells blank unless there is actual
data pulled?