Hyperlinks : Linking to a webpage

Like the other Openoffice tools, it is possible to add hyperlinks to OOo Calc. In this tutorial, we will activate the Hyperlink toolbar and link to an external website from a spreadsheet.



The Hyperlink toolbar is activated as shown below.

hyperlink1.jpg

The Hyperlink toolbar is outlined in red in the diagram below.

hyperlink2.jpg

Having chosen a cell to which we wish to link to an external website, we fill in two combo boxes in the Hyperlink toolbar. The URL address is taken from the entry in the Internet URL combo box on the right, and the name of the link is taken from the URL Name combo box on the left. To complete the addition of the URL hyperlink to the spreadsheet, we clicking on the Hyperlink button on the right.

hyperlink3.jpg

Cell B3 now has a hyperlink to an external website. By clicking on B3, a browser window is opened to the specified website.

hyperlink4.jpg

Leave a Reply