zeros on linked sheets in 2007

M

Martin ©¿©¬

Hi
using office 2007
When I paste a row link from another sheet it puts "0" in all the
empty cells is there a way to stop this
In 2003 it was Tools Options Zero Values, but I can't find the tools
menu in 2007
 
B

Bernard Liengme

Office button | Excel Options | Advanced tab in left panel
Locate 6th item down: Display Options for This Worksheet
Uncheck: "Show a zero in a cell that has zero values"
best wishes
 
M

Martin ©¿©¬

Office button | Excel Options | Advanced tab in left panel
Locate 6th item down: Display Options for This Worksheet
Uncheck: "Show a zero in a cell that has zero values"
best wishes
Click to expand...

Thank you Bernard
I would never have found that
easy when one knows how
 
Top