pasting linked cell from Exc and maintaining formatting no matter
in [Document Management]
|
Prev: How do I make Word 2007 spellcheck with new documents?
Next: Copied pdf file into Word doc/can print/can not view in doc...?
From: JEB on 6 Apr 2010 16:08 I am linking a data cell from Excel into Word. I am using the paste special, paste link: unformatted text I make adjustments to the font and font size in Word. I goto Excel, and I modify the text in the cell and go back to Word and it changes. How can I get the formatting to stay the same, no matter what?
From: Doug Robbins - Word MVP on 7 Apr 2010 22:19
In the WOrd document, press Alt+F9 to display the field codes and add the \* charformat switch inside the closing }, replacing \* mergeformat if it is there. Now apply the desired formatting to the L of Link then press Alt+F9 again to toggle off the display of the field codes. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "JEB" <JEB(a)discussions.microsoft.com> wrote in message news:15F2348C-04C5-46D2-8927-D700947DF1D2(a)microsoft.com... > I am linking a data cell from Excel into Word. > > I am using the paste special, paste link: unformatted text > > I make adjustments to the font and font size in Word. I goto Excel, and I > modify the text in the cell and go back to Word and it changes. > > How can I get the formatting to stay the same, no matter what? |