Share via

How can i choose the cell range of an excel spreadsheet in a word doc?

Anonymous
2019-02-13T16:11:11+00:00

It seems that a recent update has change the way that excel spreadsheet embedded in word docs are edited. Previously the spreadsheet would be edited within the word doc, however now when double clicked, the spreadsheet opens in a separate excel window. I have been unable to figure out how to limit the cells that are displayed in the word doc to a specific range. In my situation, there are a number of cells in the first column and first couple rows that are used for the calculations, however I do not want those to be displayed on the word doc. 

Any thoughts?

thanks!

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-02-21T14:09:00+00:00

    Yes, however it's a spreadsheet that we use frequently, so hiding rows and columns seems like an inefficient work-around rather than a solution...  until recently, that wasn't necessary... you could adjust the displayed range by dragging the edges of the spreadsheet within the word document. Thanks for responding!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. triptotokyo-5840 36,686 Reputation points Volunteer Moderator
    2019-02-21T15:35:04+00:00

    Yes, however it's a spreadsheet that we use frequently, so hiding rows and columns seems like an inefficient work-around rather than a solution...  until recently, that wasn't necessary... you could adjust the displayed range by dragging the edges of the spreadsheet within the word document. Thanks for responding!

    Yes I'm familiar with how it works. 

    Have you tried re-embedding the EXCEL file into the WORD doc and then trying, once again, to edit in WORD? Just a thought.

    Was this answer helpful?

    0 comments
  3. triptotokyo-5840 36,686 Reputation points Volunteer Moderator
    2019-02-20T20:05:57+00:00

    there are a number of cells in the first column and first couple rows that are used for the calculations, however I do not want those to be displayed on the word doc.

    Any thoughts? YES - have you tried hiding the columns and / or rows that you don't want to see?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-02-20T19:53:38+00:00

    Sherry,

    Thanks for the quick reply. I inserted the excel file through insert>table>excel spreadsheet. I did not insert an existing spreadsheet, but rather created the spreadsheet through the doc file. Until recently the it worked well, allowing me to adjust the cell range that is visible in the Word document. Now, however I am unable to control that(unless I'm missing something!) because it opens in a separate window.

    Any additional thoughts?

    thanks!

    Was this answer helpful?

    0 comments
  5. Anonymous
    2019-02-14T01:48:25+00:00

    Hello RyaNels,

    How did you insert the embedded Excel file? If you double click on the the embedded Excel file and opens in a seperate Excel document, it means that the changes you are doing will reflect on the original Excel file. On the other hand, if the file opens within the Word application, the changes made will only reflect on the existing Word document and doesnt affect the original Excel file. 

    In this case, to change this settings, make sure that link to file is disabled. Kindly refer to the screenshot below. 

    If you would like me to provide additional advice, simply respond to this thread. I will get notified and I’ll reply to you as soon as I can.

    Regards.

    Was this answer helpful?

    0 comments