Okay, so we have a list of a ton of links and a ton of titles, but we want the link text to show the title. I'm gonna show you how to do that in this video very quickly within this row. I can do this here. I'm gonna show you a more elegant way to do this so we can do hyperlink . As a formula , make sure you have that equal sign at the beginning. And we need two things. The URL and the link label . Actually the link label is optional. And our URL, this is gonna be a reference to this cell, A four and comma, make the link label a reference to B four in parentheses and hit enter. And now we have combined that link and that text. We can copy and paste this all the way down. And all of these are combined, but what if I just want that meaning I don't

want this link and this title to show. Actually, I'm gonna sort of create an archive here. I'm gonna make this just two columns. I'm gonna call this data , I'm gonna create a new sheet and I'm gonna put videos here and just take this formatting . We can call it videos. And now an A two here on this new sheet. I'm gonna do this hyperlink . Make sure you have that equal sign at the beginning and the URLI can once I have my cursor here, and you see there's like a tiny little gray line. Let's say I can go to data and I can select a cell like a. One or a two and I'm gonna then hit comma and select B two in parentheses.

And now that cell has referenced the other page. So I can label this videos and I can copy and paste this all the way down. And that's a thousand videos. All have the link and the text combined here. 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.