In the original example, only data from cells A2:D7 were copied. Fortunately, Google thought ahead on this one.īefore I get into how to update your table in Google Docs-with just one click-a quick note: when you originally copied data from your spreadsheet to your document, you effectively copied a specific cell range. It would be time-consuming (and ripe for errors) if you had to manually update the table in your doc every time you updated your original data source. And I, for one, am always looking to make my Google Docs just a little bit prettier. At a minimum, you'll have a beautifully formatted table in your Google Doc. If you haven't already tried syncing Google Sheets and Google Docs in this way, give it a go. If the table is being linked to a spreadsheet from another account, you need to have Editor access to that spreadsheet. Tables in Google Docs can only be linked to spreadsheets from Google Sheets in the same Google account. That means any updates made to the original spreadsheet won't be reflected in the Google Doc. If you select Paste unlinked, the table in Google Docs won't include a link to the original data source (the spreadsheet).
