What is Hyperlink and write the Procedure to create Hyperlink in MS-excel with Example.

 A hyperlink is text or an image within a file on your computer that you can click on that gives access to another document or image. Words on a website that are underlined and highlighted in blue and that you can click on in order to open a new web page are an example of a hyperlink.

We can use hyperlinks in spreadsheet too for the following:- 

1. Hyperlinks to websites 

2. Hyperlinks to an existing document 

3. Hyperlink to a new document 

1. Creating a Hyperlinks to websites:- we can create hyperlinks to websites for additional references, important email address etc. 

To create a hyperlink to a website, do the following steps:- 

1. Open a new worksheet in spreadsheet software. 

2. Place the cursor where we want the hyperlink to be displayed. Eg Cell A1 

3. Type the URL. Eg:- www.ecomputerconcepts.com 

4. The hyperlink automatically created and displayed. 

We can also modify and replace the hyperlink text.

2. Creating a hyperlink to an existing document (this sheet):- we can create hyperlink to documents available on the computer or another computer in our network. To create a hyperlink to a document, do the following steps:- 

1. Open a new blank worksheet. 

2. Place the cursor where we want the hyperlink to be displayed. Eg Cell A1 

3. Select the Insert Menu. 

4. Select the hyperlink option under insert menu. 

5. Select document option in the left pane under the hyperlink dialog box. 

6 click the folder icon, browse and select file and click open button. 

7 click apply and close button. Notice the hyperlink is created now click this link open this document.

3. Creating a hyperlink to a new document (external data):- This is useful when we want to create the document after the hyperlink. To create a hyperlink to a new document, do the following steps:- 

1. Open a new blank worksheet. 

2. Place the cursor where we want the hyperlink to be displayed. Eg Cell A1 

3. Select the Insert Menu. 

4. Select the hyperlink option under insert menu. 

5. Select New Document option in the left pane under the hyperlink dialog box. 

6. If we create a presentation and also embed a link to the presentation. 

7. Click the apply and close button. Notice the presentation is created and launched a new window for further editing.