By Shivani Garg
Hyperlinks in MS Excel
MS Excel allows users to organize, maintain and analyze various types of data. You can add Links to websites, Email IDs, other documents, or even other cells and sheets within the same worksheet.
How to Create Hyperlinks in MS Excel
There are many ways to Insert Hyperlink
- Link to Existing File
- Link to Web Page
- Place in This Document
- E-Mail Address.
How to Create Hyperlinks to Existing File
Let's Learn with Example:
To create a hyperlink to Existing File, take following steps.
>> On Insert tab, click Hyperlink.
>> 'Insert Hyperlink' dialog box will appear. Now, to Create Link to an existing Excel file, select a file . You can use Look in drop-down list, if required.
>> Click Ok and link will be created to Continents.
How to Create Hyperlinks to Web Page
Let's Learn with Example:
To Create a Hyperlink to Web Page, Take following steps.
>> On Insert tab, click Hyperlink. Insert Hyperlink Dialog Box will appear.
>> To Create Link to Web Page, Type Text to display, the Web page Address.
>> Click Ok and Link will be created to web page.
How to Create Hyperlinks to a place in this document
Let's Learn with Example:
To Create a Hyperlink to a place in this document, Take following steps.
>> On Insert tab, click Hyperlink. Insert Hyperlink Dialog Box will appear.
>> Click Place in This Document under Link to.
>> Type the Text to display, the cell reference or select a place in this document.
>> Click Ok and Link will be created to a Page in this document.
>> For Creating Link on same page select cell Reference.
>> Click Ok and Link will be created to a same Page in this document.
Read More on References :
Read More on Functions :
Also Read :
Labels:
MS Excel