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