| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
zeros on linked sheets in 2007
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 -- Martin ©¿©¬ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
zeros on linked sheets 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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email <Martin ©¿©¬ @nohere.net wrote in message ... 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 -- Martin ©¿©¬ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
zeros on linked sheets in 2007
On Sat, 11 Oct 2008 12:59:06 -0300, "Bernard Liengme"
wrote: 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 Thank you Bernard I would never have found that easy when one knows how -- Regards Martin ©¿©¬ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove zeros from a linked blank cell? | Excel Discussion (Misc queries) | |||
| adding row in two sheets which are linked | Excel Discussion (Misc queries) | |||
| Displaying linked data in excel 2007 when linked file is not avail | Excel Discussion (Misc queries) | |||
| Linked sheets | Excel Discussion (Misc queries) | |||
| linked sheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
