zeros on linked sheets in 2007

  • Thread starter Thread starter Martin ©¿©¬
  • Start date Start date
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zeros in cells 2
Excel links 1
Excel 2007 2
Macro to hide rows with zero in specifc column range 2
zeros on linked sheets 2
Macro to hide rows with zero values in columns 2
Unlink cells- how? 0
Errors in Excel 2007 Calculation 3

Back
Top