Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Put cell values in a Word document
I don't know what newsgroup I should direct this question, so I'll start
here. I have a Word document that I want to link up with data from an Excel spreadsheet. For instance, say I have a sentence in a Word document like: Last quarter the foreclosure rate fell by ____ basis points to ____ percent. I want to fill in the blanks by using specific cells in a spreadsheet. The data will change every month, so I thought I could automate the process instead of keying it into the Word document. I don't know if I can even do such a thing, let alone how do it. Thanks for your help or directing me to the proper newsgroup. Jeannine |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Put cell values in a Word document
Here's one way to do it (there are others):
- In Excel, select one of the cells you want to show in Word. Copy to the clipboard. - Switch to the Word document. Put the cursor where you want the value to appear. - Click Edit Paste Special. - In the dialog, click the Link option button and select "Unformatted text" in the list. - Click OK. - Repeat the preceding steps for each of the other cells. This is a live link. When you change the value in the cell in Excel, the value shown in Word will change. If you have the Word document open but not Excel, right-click the value in Word and choose Linked Worksheet Object Edit Link to open Excel to the corresponding cell. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Jeannine wrote: I don't know what newsgroup I should direct this question, so I'll start here. I have a Word document that I want to link up with data from an Excel spreadsheet. For instance, say I have a sentence in a Word document like: Last quarter the foreclosure rate fell by ____ basis points to ____ percent. I want to fill in the blanks by using specific cells in a spreadsheet. The data will change every month, so I thought I could automate the process instead of keying it into the Word document. I don't know if I can even do such a thing, let alone how do it. Thanks for your help or directing me to the proper newsgroup. Jeannine |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word should catalog misspelled words to study. | Microsoft Word Help | |||
Reveal codes in a word document | Microsoft Word Help | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
I am having difficulty with deleting headers and footers | New Users | |||
Word applies direct format on File open | Microsoft Word Help |