Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Link
When i paste link i get zeros in all empty cells. Can i prevent this?
Anybody? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Link
I have tried using the skip blanks option but this then disables the paste
link option. Confused! "Khartoum" wrote: When i paste link i get zeros in all empty cells. Can i prevent this? Anybody? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Link
You can go to ToolsOptionsView and uncheck "zero values"
Or write a formula rather than use the "paste link" =IF(Sheet1!A1="","",Sheet1!A1) Gord Dibben MS Excel MVP On Thu, 28 Sep 2006 05:38:02 -0700, Khartoum wrote: I have tried using the skip blanks option but this then disables the paste link option. Confused! "Khartoum" wrote: When i paste link i get zeros in all empty cells. Can i prevent this? Anybody? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Link
Thanks Mate!
"Gord Dibben" wrote: You can go to ToolsOptionsView and uncheck "zero values" Or write a formula rather than use the "paste link" =IF(Sheet1!A1="","",Sheet1!A1) Gord Dibben MS Excel MVP On Thu, 28 Sep 2006 05:38:02 -0700, Khartoum wrote: I have tried using the skip blanks option but this then disables the paste link option. Confused! "Khartoum" wrote: When i paste link i get zeros in all empty cells. Can i prevent this? Anybody? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the paste link function in Excel 2003 | Excel Worksheet Functions | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
"paste special" "paste link" | Excel Discussion (Misc queries) | |||
excel - numbers as text | New Users to Excel | |||
Paste a chart as a link? | Charts and Charting in Excel |