Google Sheets Links

in this video let's talk about creating links or hyperlinks in Google Sheets so let's start with the easy one so you could just create a link anywhere you like so let's say you have some text here it says click here and then you want to make a link out of this you can just simply right click and go to insert link and you have a few options here you can either just paste the hyperlink you want to point to so for example you can do something like this it's probably best to just copy this from the URL in the browser here whatever you want to link to and just point like this and that should work and at this point if I click here see that's a link you can click on it it will take you in this case to Google now then I can click this little pencil icon and we can go back and modify this this would be the text here and this is the actual link itself now that's an external link you can also do internal link inside of your spreadsheet so an example of that could be you might want to link to this tab here so the way you could do that I'm going to say go to tickers and again that's just text it doesn't do anything but I can right click go to insert link and then all the way down here we have sheets and named ranges so I'm going to click on that and that basically gives you the list of tabs you got here so I'm gonna point to that tickers and there it is now it's a link so if I click on this click here it will take me to the sheet now instead of linking to just a tab you might want to link to a particular cell or a range of cells and you can do that too so I'm going to go back and do this again so I'll just go ahead and click on this pencil to modify this link and I'll click on this sheets and named ranges again and all the way down we have select a range of cells to link and at this point you can just move wherever you like in your sheet so I'm going to go to this tab and let's say I wanted to link to this cell you could just click on that you can also link to a range of cells so for example I can scroll down here and link to these cells like this this range so I'm going to press ok and just to show you how this works I'm going to go back and scroll all the way up here and if I go now to that link and click on this see it will take me to that spot in my spreadsheet and also highlight that range and that's how you can make internal links inside of your own spreadsheet now let's talk about doing Dynamic links using hyperlink function so using this hyperlink function you have this URL and Link label parameters and both of them have to be in string format so that means in quotes you do something like this and then comma and then again in codes you do the text and now this is a link that will take us to Google now here we can also create these links by using some data we have here so over here you see I have these domains but notice these domains don't have this https part in them and for it to be a valid link you need to have that https colon and these two for that reason I'm going to create that by using concatenation so I'll just keep that part that says https colon and this format slashes and then I'll go after my quotations and do Ampersand which is basically concatenate it's plus sign for text and then I can just point to this cell to get the rest of that domain here so essentially we're going to create this https plus this and at this point if I'd enter see this will now take to this link and if I take this and drag it now each line it's going to point to the right website now at this point all of these say click here but let's say I don't want them to say click here I would like the link to be the name coming from here so I can do that too of course so instead of doing this hard-coded click here we can just point to this cell and at this point if I drag this like any other formula we'll get each link with a custom text with that company's name now finally I'm gonna also add a little bit of text in front of this so I wanted to say visit so I'll go in front of this and do visit space in quotes and then add that and Sign Plus so basically in addition to that text which is the name of the company now I'm going to have this text that's going to say visit with a space in front of that so I'm going to do that and you should be able to see now how that's going to give me that it's still going to work it's still going to link to the right page so basically you can use this idea of concatenation to build your links you can also add some more text after so I can say space website and this way it's gonna look like that and there it is that's our hyperlink function so if you want to use a formula to create links that's the way you can do that or you can just use the regular link which is where you just right click an insert link and do the link now finally before I end this video let me also go over how we can make internal links using this hyperlink function so let's say I want this function here to point to this cell over here so I can do that by going to that cell where I want to link right click on this and right here if I just scroll down to this view more cell actions I have this option get link to the cell so I'm going to click on that and then I'm going to go back here open this and then here as the URL which is the part before the first comma in quotes I'm going to paste Ctrl V command V that link that points to that cell now the text is still going to say what it used to say because I didn't change that now we should probably change that too so I'm going to go here and say something different so for now I'll just say click here and now it's going to be just a link internal that's going to point to that particular cell in here now if you pay attention to the actual link right here you'll see that the last part of the link is the cell where it's pointing to in that other spreadsheet and then again if you have that information someplace else so let's say here we just type B5 and would like to point to that particular cell we can go back here and instead of this B2 we can remove that and after this whole string after codes I'm going to do that Ampersand and point to that B5 right here which means now this should link to B5 cell in that particular sheet and see that links to this BP and by the way just something for you to pay attention to when I hover this see it shows the data that is linking to what it is BP so that's links in Google Sheets thanks for watching Please Subscribe and I'll see in the next video