| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked cells - why '0' when blank?
I have a summary sheet & 2 detail sheets in the same workbook. I want the
header info from the summary sheet to copy to the 2 detail sheets. I've linked the cells, but the problem is - when the summary sheet cell is blank, the cells on the detail sheets show a '0'. Hwo can I get them to stay blank? -- -Lynn F. PMP |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked cells - why '0' when blank?
Hi,
click in the Microsoft button, Excel options, advance,Display options for this workbook, uncheck Show a Zero in cell that have zero value if this helps please click yes, thanks "Lynn" wrote: I have a summary sheet & 2 detail sheets in the same workbook. I want the header info from the summary sheet to copy to the 2 detail sheets. I've linked the cells, but the problem is - when the summary sheet cell is blank, the cells on the detail sheets show a '0'. Hwo can I get them to stay blank? -- -Lynn F. PMP |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked cells - why '0' when blank?
Use something like this:
=IF(Sheet1!A1="","",Sheet1!A1) Hope this helps. Pete On Aug 17, 3:46*pm, Lynn wrote: I have a summary sheet & 2 detail sheets in the same workbook. *I want the header info from the summary sheet to copy to the 2 detail sheets. *I've linked the cells, but the problem is - when the summary sheet cell is blank, the cells on the detail sheets show a '0'. *Hwo can I get them to stay blank? -- -Lynn F. PMP |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked cells - why '0' when blank?
=if(summary!a1="","",summary!a1)
is a way to avoid this. Lynn wrote: I have a summary sheet & 2 detail sheets in the same workbook. I want the header info from the summary sheet to copy to the 2 detail sheets. I've linked the cells, but the problem is - when the summary sheet cell is blank, the cells on the detail sheets show a '0'. Hwo can I get them to stay blank? -- -Lynn F. PMP -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Results from blank linked cells | New Users to Excel | |||
| do not chart cells linked from worksheets that are blank | Charts and Charting in Excel | |||
| Excel inserted 0's in cells linked to blank cells | Excel Discussion (Misc queries) | |||
| Why does linked data from blank cells become a zero? | Excel Discussion (Misc queries) | |||
| How to keep linked cells blank until information is entered? | Excel Worksheet Functions | |||
Hybrid Mode
