Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Values from referenced cells
I have a worksheet that references cells in another worksheet. Empty cells
in the referenced sheet are showing up in the second sheet as "0", rather as an empty cell. I would like them to show up empty. Is there any way to do this? Thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Values from referenced cells
Instead of: =Sheet2!A1
use this: =IF(Sheet2!A1="","",Sheet2!A1) -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Wavequation" wrote: I have a worksheet that references cells in another worksheet. Empty cells in the referenced sheet are showing up in the second sheet as "0", rather as an empty cell. I would like them to show up empty. Is there any way to do this? Thanks for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Values from referenced cells
Instead of:
=Sheet2!E29 use: =IF(Sheet2!E29="","",Sheet2!E29) -- Gary''s Student - gsnu200855 "Wavequation" wrote: I have a worksheet that references cells in another worksheet. Empty cells in the referenced sheet are showing up in the second sheet as "0", rather as an empty cell. I would like them to show up empty. Is there any way to do this? Thanks for your help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Values from referenced cells
Another way:
Menu Tools Options In the View tab uncheck the 'Zero values' checkbox. This will suppress all zero values. This option can be set for each worksheet individually, but not for a specific range within a worksheet. Joerg "Wavequation" wrote in message ... I have a worksheet that references cells in another worksheet. Empty cells in the referenced sheet are showing up in the second sheet as "0", rather as an empty cell. I would like them to show up empty. Is there any way to do this? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display formula with values referenced | Excel Worksheet Functions | |||
referenced cells | Excel Discussion (Misc queries) | |||
Referenced Cell Values | Excel Worksheet Functions | |||
flagging cells that have been referenced | Links and Linking in Excel | |||
Indexing Referenced Cells | Excel Discussion (Misc queries) |