« Goal Seek | Main | Webquery : Importing HTML tables »
October 19, 2004
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.
The Hyperlink toolbar is outlined in red in the diagram below.
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.
Cell B3 now has a hyperlink to an external website. By clicking on B3, a browser window is opened to the specified website.
Posted by Dave at October 19, 2004 06:29 AM