| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Paste-Values Equivalent in Word?
I use excel a lot and I am looking for a "paste-specialvalues" equivalent.
I have paste-linked cells from Excel into word documents as RTF. This is for a monthly bill, and once it is sent out, I want these links to be pure text. I do not want to copy as paste as a bitmap. The only option I can think of is to make the forms into pdfs. Do you have any other ideas? Thanks. |
|
#2
|
|||
|
|||
|
Wynn wrote:
I use excel a lot and I am looking for a "paste-specialvalues" equivalent. I have paste-linked cells from Excel into word documents as RTF. This is for a monthly bill, and once it is sent out, I want these links to be pure text. I do not want to copy as paste as a bitmap. The only option I can think of is to make the forms into pdfs. Do you have any other ideas? Thanks. I have to assume you have a reason to paste-special as links, rather than paste-special without the link (the Paste radio button in the Paste Special dialog). When it's time to freeze the value as plain text, select the linked value (or the whole document, to work on all links at once) and press Ctrl+Shift+F9 to "unlink" the LINK field. It won't change the RTF formatting. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org |
|
#3
|
|||
|
|||
|
Beautiful! This is exactly what I was looking for.
"Jay Freedman" wrote: Wynn wrote: I use excel a lot and I am looking for a "paste-specialvalues" equivalent. I have paste-linked cells from Excel into word documents as RTF. This is for a monthly bill, and once it is sent out, I want these links to be pure text. I do not want to copy as paste as a bitmap. The only option I can think of is to make the forms into pdfs. Do you have any other ideas? Thanks. I have to assume you have a reason to paste-special as links, rather than paste-special without the link (the Paste radio button in the Paste Special dialog). When it's time to freeze the value as plain text, select the linked value (or the whole document, to work on all links at once) and press Ctrl+Shift+F9 to "unlink" the LINK field. It won't change the RTF formatting. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Word 2003 documents to WordPerfect formate | Microsoft Word Help | |||
| On Paste command Word doesn't actually pastes from Clipboard - why | Microsoft Word Help | |||
| How do I create & merge specific data base & master documents? | New Users | |||
| WP Delay Code - Word Equiv | Microsoft Word Help | |||
| How do I convert a cd in word perfect to microsoft word | Microsoft Word Help | |||
Linear Mode
