Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pictures not showing or printing | Excel Discussion (Misc queries) | |||
Leading zeros not showing | Excel Discussion (Misc queries) | |||
Printing with the Headers showing on every page | Excel Discussion (Misc queries) | |||
leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
Printing but not showing | Excel Discussion (Misc queries) |