Go to the slide where you want to add a text box or object. Click the link icon (□) that appears in the top-right corner above the table, and select Change range. Insert a text box or object On your computer, open a presentation in Google Slides. ![]() If you know you'll be adding more rows or columns of data to your Google Sheet, it's important to update the data range for your table in Google Docs. 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).
0 Comments
Leave a Reply. |