you wanna link to another sheet? There's a couple of ways we can do this. One way is that we may want the actual data to show up on another sheet. So we're going to create a new sheet sheet new, and if we want that other sheet to show up on this sheet, we're gonna need to use import range . We'll just need the URL. Put that in quotes and the range in quotes will be the name of the sheet, sheet one and the range A two to E eight. So we're gonna write that here. Sheet one, exclamation point a, two, colon E eight, and now it'll ask me to allow access . I will allow access on this sheet. We have our data , but what if we just wanted to have a link

on this sheet to this sheet? We need this URL here, and we could just past this URL. Now at the end of the URL, you'll see GID zero. That means it is this particular tab, but if we add another tab, sheet two, this one we wanna link to it. We'll take the URL and put it here and you'll see at the end the GID is. A different number . It is the same sheet ID here, but sometimes that URL doesn't look very nice. So we will use hyperlink and we'll put in the URL, same exact URL, but we can put in quotes here after a comma, some link label , some text to say, see the sheet. And quote and parentheses. And now we have a link to another sheet from here.

And that other sheet is our original sheet. And we can also link to maybe here it can say more data . We can write the text in and do command K and paste this URL. That's another way to link to another sheet. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.