| 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 | |||
Hybrid Mode
