In this tutorial you will learn how to use hyperlinks in excel. By using hyperlink you can insert the link by which you can go on other location. you can link the sheet with the text by using hyperlink in microsoft excel. You can link the web page with the text in excel by selection of option existing file or web page in insert hyperlink dialog box. The most common use of hyperlink is to patch link of email address with the text of cell in the worksheet of excel.
use hyperlinks in excel example:-
Create worksheet in excel that have name of sheets like as following sheet.
Now add hyperlink to text sheet2 so click on insert menu and visit the Links panel same as following sheet.
Click on the Hyperlinks option of the links panel from the insert menu to add link to sheet2. After clicking on Hyperlinks insert hyperlink dialog box appear and select place in this document option like as following sheet.
Select sheet2 and click on OK button then hyperlink added to sheet2 like as following sheet.
Select the cell C3 in the excel like as following sheet.
So now right click of mouse and select hyperlink option like as following sheet.
After clicking on hyperlink option the dialog box appear like as following.
Click on OK button to insert hyperlink in sheet1 of sheet3 like same as following sheet.
You also can insert the link of first sheet in sheet2 and sheet3. For this go in sheet2 and type in cell A1 home.
Press ctrl + k and insert hyperlinks dialog box appear like as following.
After click OK button the hyperlink of sheet1 added to sheet2 same as like following.
You can do same for the sheet3. Hence you have learned the use of hyperlinks in excel.