Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Word
application.errors
conversions
docmanagement
drawing.graphics
formatting.longdocs
international
internet.assistant
mail
mailmerge.fields
menustoolbars
newusers
numbering
oleinterop
pagelayout
printingfonts
setup.networking
spelling.grammar
tables
vba.addins
vba.beginners
vba.customization
vba.general
vba.userforms
web.authoring
word6-7macros
word97vba
  
 
date: Tue, 11 Sep 2007 01:24:14 +0800,    group: microsoft.public.word.oleinterop        back       


Pasting single Excel cell to Word   
Hi all,

I want to paste-link a cell in Excel 2003 into Word 2003 as an in-line text.

The steps:
1. Copy the cell in Excel.
2. Switch to Word, then click Paste.
3. Select "Match Destination Formatting and Link to Excel" in the Paste 
Option smart tag.

It works, but a paragraph mark would be inserted before the cell content in 
Word and it is not possible to just delete it. Any ways of work-around this? 
Thanks.

Frederick Chow
Hong Kong.
date: Tue, 11 Sep 2007 01:24:14 +0800   author:   Fred Chow

RE: Pasting single Excel cell to Word   
My suggestion is:

The steps:
> 1. Copy the cell in Excel.
> 2. Switch to Word, Go to tool bar "EDIT"- > Paste Special" - > select "Paste Link" Tab - > Select "Formatted Text (RTF)". Thats All.

Regards
Sarma


"Fred Chow" wrote:

> Hi all,
> 
> I want to paste-link a cell in Excel 2003 into Word 2003 as an in-line text.
> 
> The steps:
> 1. Copy the cell in Excel.
> 2. Switch to Word, then click Paste.
> 3. Select "Match Destination Formatting and Link to Excel" in the Paste 
> Option smart tag.
> 
> It works, but a paragraph mark would be inserted before the cell content in 
> Word and it is not possible to just delete it. Any ways of work-around this? 
> Thanks.
> 
> Frederick Chow
> Hong Kong. 
> 
> 
>
date: Mon, 24 Sep 2007 06:54:01 -0700   author:   Sarma

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us