While the provided reference only briefly mentions the need to delete a text box to insert a table, the process of inserting and linking a table from Google Sheets into Google Slides involves these steps:
-
Open your Google Slides presentation. Go to the slide where you want to insert the linked table. If you are starting in a text box, you might need to delete the text box first to create a blank area.
-
Open the Google Sheet containing the table you want to insert.
-
Select the range of cells you want to include in your table. Click and drag your mouse to select the specific cells that constitute your desired table.
-
Copy the selected cells. You can do this by pressing
Ctrl+C(Windows) orCmd+C(Mac). -
Go back to your Google Slides presentation.
-
Paste the copied cells. Press
Ctrl+V(Windows) orCmd+V(Mac). -
Choose to link the table. A dialog box will appear, asking if you want to paste the table linked to the spreadsheet. Select "Link to spreadsheet." This is the crucial step to ensure the table in your slide updates when the source spreadsheet changes.
-
Adjust the table's appearance (optional). You can resize the table, change its position, and format the text within the Google Slides environment. Be aware that extensive formatting changes in Slides might not persist if the data is updated from Sheets.
-
Update the linked table (when necessary). If you make changes to the original Google Sheet, a link icon will appear on the linked table in your Google Slides. Click the link icon, and then click "Update" to refresh the table in your slide with the latest data from the spreadsheet.
By following these steps, you can effectively insert a linked table from Google Sheets into Google Slides, ensuring your presentation data remains synchronized with your spreadsheet.
