Fields from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have used the insert field document to insert text from a different word
document. I wanted to know whether this was possible with word and excel. If
i enter a value in word, i would like it to appear on an excel spreadsheet
either automatically (which would be great) or by pressing F9 after clicking
on the cell. Is this possible?
 
Yes it is possible. The quick and dirty way is simply to select and copy the
text/cell in one application, switch to the other and Paste Special > Paste
as link.

Or insert a hyperlink using the Bookmark switch. For Word, you need to
bookmark the piece of text you want to refer to in Excel; going the other
way, the cell reference or any defined name can be used as the bookmark.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Issue is facing on Word 2016 -{EMBEDED Excel.Sheet.12} 0
Must enter SHIFT F9 before entering text in new WORD 2007 doc 1
Word 2007 Import Excel spreadsheet from Workbook 1
Summary table for track changes 0
Update field within a text box 2
Mail merge between Word and Excel 1
type simultaneously 4
Fill-in Fields/Codes when to use how to print Word 2007 1

Back
Top