Values from referenced cells

  • Thread starter Thread starter Wavequation
  • Start date Start date
W

Wavequation

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.
 
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
 
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
 
Back
Top