Insert Hyperlink in OpenOffice Spreadsheet

How to insert hyperlink in OpenOffice Spreadsheet?

Explanation

To insert a hyperlink, follow the steps given below
Step 1: Select the cell, where you want to insert the hyperlink.
Step 2: Select Insert→ Hyperlink

Step 3: In the hyperlink window, select the Hyperlink type (web, FTP, Telnet)
Step 4: In the left tree, select any one of the four categories of hyperlink.
i) Internet:
In this option, the given hyperlink will point to a web address. The web address starts with "http://"

In the below picture, the text is hyper-linked.

ii) Mail and News: In this option, the given Hyperlink opens an email message which is pre-addressed to a specific recipient.

In the below image, text is hyper-linked with the email address.

iii) Document:
If you choose this option, the hyperlink which you type will point to another document or to another place in the current document.

In the below image, the text is hyper-linked with local document path.

iv) New Document:
New Document option is used to create a new document from the given hyperlink.
For creating a new document, there are two options named as, Edit Now and Edit Later. Edit now option is used to generate a new file immediately and Edit Later option is used to just create a new file and edit it later.

In the below image, the new image will be hyper-linked with the new document.

Related Topics