Hyperlink in Excel

This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.


Hyperlink in Excel






 

 

 

Hello Everybody
And welcome to excel Made Easy!
I’m your Excel guru and today I’m going to tell you how to use the hyperlink feature in excel. Well hyperlinks can be used to link a word, a sentence, a photograph, a graph to a excel file, a folder in your computer, to a website, to a email address and all such things. It’s a wonderful thing. It can help you so much. Let us see. There are two ways of putting a hyperlink. The first one is right clicking on the place where you want to have the hyperlink, then choosing the hyperlink option, open hyperlink or there is one more way.

 

Type something say hyperlink and then do a Control K. Control K opens the hyperlink for you. Now this is something we are going to check. Link to existing files or webpage this is most commonly if you would like to hyperlink website to this to whatever in Excel. Say I link it to www. This is my YouTube channel Ok so I will link to www.YouTube.com/excelmadeeasy. So now it is hyperlinked to that. See if I rollover my mouse over it, it will read that it’s hyperlinked to this specific channel. So that’s one way of hyperlinking it to website. Let’s do another thing, so to do that, let’s also edit this. We can edit this hyperlink by just right clicking it and clicking on the edit hyperlink and you can remove the link like this. The link is gone. Right click it again and say hyperlink and we can even link to any of the folders over here in your computer. You can choose your folder and link it over there. Or place in this document.



See if you want that whenever you click somewhere, your, the computer should take you the hyperlink should take you to a specific cell on your excel file. So yes that can be done. On sheet 2, I have done something, I have written something on the cell G4. Let us see what is that. So I’ll type in the cell address G4 that’s very important you need to remember the cell address so click Sheet 2 and G4 and click ok. So if I click it over here now it will take me to G4 and what I had mentioned over here was Excel made easy. You can even hyperlink it back to Sheet 1. So this is in F3 Ok so let’s see. We click it over here we do a Control K , place in this document Sheet 1 and we type in the address F3 We click on OK and see they are hyperlinked to one another. And there are few more things that can be done. Say let’s edit this one first. And sorry Edit hyperlink and we remove this link and we do it another hyperlink and we can create a new document.

 



So now it is hyperlinked to that. See if I rollover my mouse over it, it will read that it\u2019s hyperlinked to this specific channel. So that\u2019s one way of hyperlinking it to website. Let\u2019s do another thing, so to do that, let\u2019s also edit this. We can edit this hyperlink by just right clicking it and clicking on the edit hyperlink and you can remove the link like this. The link is gone. Right click it again and say hyperlink and we can even link to any of the folders over here in your computer. You can choose your folder and link it over there. Or place in this document. See if you want that whenever you click somewhere, your, the computer should take you the hyperlink should take you to a specific cell on your excel file. So yes that can be done. On sheet 2, I have done something, I have written something on the cell G4. Let us see what is that. So I\u2019ll type in the cell address G4 that\u2019s very important you need to remember the cell address so click Sheet 2 and G4 and click ok. So if I click it over here now it will take me to G4 and what I had mentioned over here was Excel made easy. You can even hyperlink it back to Sheet 1. So this is in F3 Ok so let\u2019s see. We click it over here we do a Control K , place in this document Sheet 1 and we type in the address F3 We click on OK and see they are hyperlinked to one another. And there are few more things that can be done. Say let\u2019s edit this one first. And sorry Edit hyperlink and we remove this link and we do it another hyperlink and we can create a new document. You can use this to create a new document, you can also use it link it to an email address and there are a few things that, two more things I would like to tell about hyperlink

 

This is more about Excel 2007 and above. If you type in the website address www.facebook.com/excelmadeeasy. That\u2019s me. It\u2019s become hyperlink automatically that\u2019s one of the feature of excel same would happen to any email id. Say if I type in my email id. Say it [email protected], it became hyperlink automatically. So that is what is hyperlink is. This file is available for free download on my website ExcelMadeEasy.weebly.com. Very soon we are coming with new website Myelesson.org, Wonderful website, will cater to so many things. And you can go to training files page and download the training files for free. You can also go video tutorial page and see all the video tutorials we have. And you can also go to Facebook and like me over there and share my work with others. Share the work that\u2019s the main motto. Let\u2019s Share Knowledge.\r\nSo this is your Excel Guru signing off for the day \r\nHave a wonderful day ahead!\r\nHappy Excel learning!\r\n\r\n”]” data-sheets-userformat=”[null,null,513,[null,0],null,null,null,null,null,null,null,null,0]”>Hyperlink in Excel

 

You can use this to create a new document, you can also use it link it to an email address and there are a few things that, two more things I would like to tell about hyperlink feature. This is more about Excel 2007 and above. If you type in the website address www.facebook.com/excelmadeeasy. That’s me. It’s become hyperlink automatically that’s one of the feature of excel same would happen to any email id. Say if I type in my email id. Say it [email protected], it became hyperlink automatically.  Let’s Share Knowledge.So this is your Excel Guru signing off for the day. Have a wonderful day ahead!
Happy Excel learning!

 








Our Other Services




Read Free Ebooks

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!



Buy Excel Course

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788



Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!


Download Excel Crash Course


This Excel Crash Course contains the list of topics that cover the most important and used features and formula of Excel . This Excel Crash Course lists 43 major topics in Excel so that you can start using Excel like a pro in the shortest possible time.



Learn Photoshop Web Designing


You can Buy the Photoshop Course to learn Photoshop and start a career in Web Designing and Photo Editing. .



Learn HTML CSS


You can Buy the HTML CSS Course to learn HTML CSS and start a career in Web Designing and Photo Editing. .


Download Full list of Excel Shortcuts


This Excel Shortcuts Complete list is to help you become save time and use Excel like a Master level user. Excel is best used when you know the Keyboard shortcuts because the use of keyboard shortcuts in Excel helps you in completing tasks faster.

I have created a Excel Shortcuts complete list for you to use Excel better, this list has 242 excel keyboard shortcuts which means that it covers almost everything that can be done using shortcuts in Excel.




Full List of Excel Formulas

This is a complete alphabetical list of all the Formula in Excel with a description. You can learn all these formulas on www.Myelesson.org




Convert Numbers to Text in Excel

Now easily convert numbers to Text in Excel with this inbuilt sheet from myelesson.org .  Many times we need the amount in figures to be converted into words. This is a typical requirement for writing checks or any other financial reports. Microsoft Excel does not have standard function available for this requirement. Just download this sheet and then you can convert any number to text in Excel.




List of Most Commonly Asked Excel Questions in Interviews

Here is the list of most asked excel related questions in interviews.  Prepare for this excel questions and you would be able to most of the excel interviews. This list of excel questions covers excel formula, excel analysis, excel reporting, excel charts and more.





Myelesson © 2010 - 2014. All rights reserved.

Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok
Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok