1

Currently, it is possible to click a cell in Google Sheets and "get a link", however, when this "link" to the cell is inserted in a Google Doc, it hyperlinks to the Google Docs app, and does not show the cell value.

How can I render a Google Sheet Cell's VALUE in a Google Doc?

enter image description here

enter image description here

EDIT: To clarify, let's say I have my favorite number in a cell of a Google Sheet, and I want to have that number referenced in a Google Doc. I want this to look like the first line of the image below. The following lines are what I get if I command-C copy the cells in the Sheet, based on the answer from @doubleunary, which is not as ideal but at least it's closer to what I want!

enter image description here

4
  • Welcome to Web Applications Stack Exchange. Mar 28 at 20:37
  • You are showing two versions of what you do not want. It would probably make it easier to understand what you want if you showed an illustration of what you do want. Mar 28 at 20:39
  • thanks @doubleunary I made an update to clarify what I want, and also what I am getting so far from your answer.
    – user391339
    Mar 28 at 22:50
  • Since the paste link feature requires two cells at minimum, you should put the phrase "My Favorite number is:" and the number in adjacent spreadsheet cells, and then copy-paste those two cells as described in the answer. Mar 29 at 6:51

1 Answer 1

3

You can link a Google Sheets range to a Google Docs paragraph by using simple copy and paste. Just select the range (note: minimum two cells), press Control+C to copy, then open the text document and press Control+V to paste.

You will be asked if you want to paste the table as a link to the spreadsheet or if you want to paste the table unlinked. Choose the first option to make Docs automatically show an Update button on top of the table whenever the source data has changed.

Note that the dynamically linked option is not totally automatic as you will still need to click the button to refresh the values.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.