printing without zeros showing in a cell with formulas
 

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?

printing without zeros showing in a cell with formulas
 

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?

printing without zeros showing in a cell with formulas
 

Trap for no data or zero in source cell(s).

=IF(Sheet1!A1=0,"",Sheet1!A1)

=IF(Sheet1!A1="","",Sheet1!A1)

=IF(SUM(Sheet1:Sheet5!A1:A10)=0,"",SUM(Sheet1:Shee t5!A1:A10))


Gord Dibben MS Excel MVP

On Sat, 27 Oct 2007 15:00:01 -0700, John wrote:

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?

printing without zeros showing in a cell with formulas
 

Another way is to apply conditional formatting to the cells in the
summary sheet, such that if the cell content is zero, change the
foreground colour to the background colour (usually white).

Hope this helps.

Pete

On Oct 27, 10:00 pm, John wrote:
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?