Google Docs / Google Docs Power User
Copy and link data to documents
When you copy and paste data from Google Sheets or Google Slides into documents, you can create a link that can be updated at any time to show the latest data from the source you copied the information from. This allows you to keep your data synchronised across all documents that the data is in.
Copy and link Sheet data
To copy sheet data:
In the sheet, select the data you wish to copy
Click on the Edit menu and choose Copy
In the document where you want to link the data, click on the Edit menu and choose Paste
Ensure Link to spreadsheet is selected
Click on Paste
The table of data will be inserted, with a drop-down arrow showing above the table:
Click on the drop-down arrow and choose Unlink to break the link between the source sheet and this document
Click on the drop-down arrow and choose Open Source to view the sheet in a new window
Click on the drop-down arrow and choose Change range to change the range of data you have linked from the sheet
If the sheet data changes, a new button will show above the table. Click on Update to show the latest figures from the source sheet.
Copy and link Slide data
You can select any text or images from a Google Slide and copy it to a document - no link will be formed between the source and target.
If you select an entire slide in a Google Slides presentation, you can link the slide into a document, so that the document can be updated whenever the slide is changed.
In the presentation, select the slide you wish to copy
Click on the Edit menu and choose Copy
In the document where you want to link the data, click on the Edit menu and choose Paste
The slide will be inserted, with a drop-down arrow showing above the image. Click on the arrow to unlink the slide, open the source or show a summary of linked objects in the document.
Viewing linked objects
You can view a list of all linked objects in a document, so that you can easily select a specific object to view or update.
Click on the Tools menu
Choose Linked Objects
Click on the object you wish to select in the document
