Page 184 - IT_V1.0_Class10
P. 184
HYPERLINK
Hyperlinks are widely used on Internet to navigate between websites. In spreadsheet also, such link options
can be easily created. Hyperlink is a reference to a specific location, document or webpage that the user can
switch by clicking on that link. Hyperlinks can be used in Calc to jump to a different location from within a
spreadsheet and can lead to other parts of the current file, to different files. It can be stored within a file as
either Relative or Absolute hyperlinks.
Spreadsheet enables to create hyperlinks for many different purposes including:
Moving to a certain location within the current spreadsheet
Opening another document or getting to a specific place in that document
Navigating to a webpage on the Internet or Intranet
Sending an email to a specified address
Hyperlinks in spreadsheet are easily recognisable as these are highlighted in light blue colour.
Relative and Absolute Hyperlink
An absolute hyperlink contains a full address, the protocol and domain name for Uniform Resource Locator
(URL), and the entire path and file name for documents. For example,
Absolute URL: https://orangewebsupport.co.in
Absolute Link to a Spreadsheet File: D:\Cell Referencing.ods
Relative URL: A relative hyperlink contains a partial address. For example, www.orangeeducation.in/about.html
Relative Link to a Spreadsheet File: Cell Referencing.ods
On the Internet, it is common practice to use relative URLs. In spreadsheet hyperlinks, users should always
apply full URLs for accessing webpages. It can understand URLs without the protocols. For example, for
www.orangeeducation.in a cell, spreadsheet will automatically add the default 'https' protocol and convert it
into a hyperlink.
While creating links to spreadsheet files or other documents stored on computer, either absolute or relative addresses
can be used. In a relative hyperlink, a missing part of the file path is relative to the location of the active spreadsheet.
The main advantage of relative hyperlink is that we don't have to edit the link address when the files are
moved to another location. For example, if active spreadsheet and target spreadsheet reside on drive C and
then target spreadsheet moves to drive D, relative hyperlinks will continue working as long as the relative
path to the target file remains unchanged. In case of an absolute hyperlink, the path should be updated every
time the file is moved to another place.
Working with Hyperlink
To create hyperlink in a sheet, follow the given steps:
Step 1: Select the cell, in which hyperlink needs to be created.
Step 2: Click on the Insert menu and select Hyperlink option.
182 Information Technology Play (Ver 1.0)-X

