If you’re working in Google Slides and you want to have a spreadsheet linked into it,
you couldn’t do that before with Google Sheets.
But now, if you create a spreadsheet in Google Sheets, you can paste it as a link into Slides.
It’s going to be smart enough to be updated when you update the data in the Google Sheet.
There’s only a couple easy steps to follow.
There’s a few things to keep in mind too as you do it.
If you’re starting with a slide like this and you’re already inside a text box, you
have to delete the text box.
It just wants a blank area.
Obviously if you have a table that you want to embed, it’s already made.
Here it is.
It just has some fake data in it.
You want to select the area of data that you want to link.
Just right-click it and copy.
If you right-click in the area and you paste, then you get the dialog to Link to Spreadsheet.
It knows that your spreadsheet is on the clipboard and it’s from Google Sheets so it’s ready
to link it live.
Click paste and here it is.
It doesn’t look all that magical but the thing about this is that if you go and update
the original sheet, let’s just change the 60 to an 80.
This icon popped up and knows it’s changed.
If you click update, the 60 changed to an 80.
Another thing that you can do is, you can tell if you’re looking in Sheets, the formatting
looks OK.
You can read the numbers, you can read the letters.
When it comes over to Slides, it doesn’t look it’s formatted very well.
You may have to go back into Google Sheets and then increase the font size, let’s just
do it to 24.
It looks like I didn’t get the bottom row.
Increase it to 24, then you’ll have to increase the columns a little bit.
I just double-clicked there which tells it to increase the columns only as much as you
need to.
Then, we’ll go back into Slides and we’ll update it.
Your Slide is going to look better.
Your audience will be able to read can that now.
Now I’ll center it.
So, we pasted it, it’s remained linked, we formatted it so that it looks good.
There’s a few minor things to keep in mind.
If you add a row to it, so we’re going to go back and a row in the middle, and we’re
just going to put some data on here, and we’ll go back to Google Slides.
First of all you know it’s was updated, so it gives you this option.
If you click it though, it added the row, but it’s not smart enough to expand the
table down so that you can see the entire table.
You have to go on the more options, left-click and change the range.
We go down to D8 now in Google Sheets so just increment that last number one higher, click
OK, now you’re going to see all the rows.
We lost some of the formatting for whatever reason on here.
Let’s go back to the Google Sheet, it looks like it’s formatted correctly so it looks
like it’s formatted correctly so you may want to re-link it.
Actually, I think that’s an error in the program that it happened that way.
You have you’re live, linked sheet.
It will update in the future going forward.
If you want to see any of these steps on the website, you can click in the upper right-hand
corner.
You can go through it.
They’re all written out for you here so you won’t forget.