Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Dennis
Lv 6
Dennis asked in Computers & InternetSoftware · 8 years ago

Is it possible to set a formula in excel to apply to MS word?

Is it possible to actually link both software so that if I input data into a formula in excel it will input that information into MS word? Like say I put the sum of cell A:1+A:2, and the SUM would show up in MS word rather than a designated cell in excel?

3 Answers

Relevance
  • ?
    Lv 7
    8 years ago
    Favorite Answer

    Hi. What you can do is insert the object from your Excel file, into Word, and link the file. Then, whatever you do in the Excel file does show up in Word.

    Here is how: (I do not know what version you have, so I hope the instructions are similar)

    1. You do not have to close the Excel file, but save it first. Before you save it, get rid of the grid lines.

    To get rid of the grid lines, go to Tools>Options>View tab, and Uncheck the grid lines box>OK

    2. Open Word and go to Insert>Object

    3. Click the Create from File tab

    4. Click Browse and locate the saved Excel file, then highlight it and click insert

    5. Look for, and place a check-mark in the "Link to File" box

    6. Click OK

    You should now see what you typed into Excel in Word.

    The really neat part is when you make changes to the Excel file they should show up in the Word file at the same time. You do not have to hit save on the Excel file either, to see the immediate changes.

    Hope that is what you wanted to accomplish.

  • 4 years ago

    convinced, easily. click at the cellular that has the formula you desire to reproduction. interior the backside top hand nook of the border of that cellular, there will be a tiny sq.. click for the period of this and drag it down the column - this would reproduction the formula into all these cells

  • 8 years ago

    I don't think that's possible. They are two (somewhat) completely different programs.

Still have questions? Get your answers by asking now.