Page 185 - IT 402 v2.0 class 10
P. 185
HYPERLINK
yperlinks are widely used on Internet to navigate between websites. In spreadsheet also such link options
can be easily created. yperlink is a reference to a specific location document or webpage that the user can
switch by clicking on that link.
Spreadsheet enables to create hyperlinks for many different purposes including:
Moving to a certain location within the current workbook
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
yperlinks in spreadsheet are easily recognisable as these are highlighted in light blue colour.
Relative and Absolute Hyperlink
n absolute hyperlink contains a full address the protocol and domain name for s and the entire path
and file name for documents. For example
Absolute URL: https: www.micaeduco.com about.html
solute lin to a S reads eet file: : sers c esktop ell eference.ods
Relative URL: relative hyperlink contains a partial address.
For example www.orangeeducation.in about.html
elati e lin to a S reads eet file: ell eference.ods
On Internet it is a common practice to use relative s. In spreadsheet hyperlinks user should always
apply full s for accessing webpages. It can understand s without the protocols. For example for
www.orangeeducation.in a cell spreadsheet will automatically add the default http protocol and convert it
into a hyperlink.
hile 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 workbook.
he 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 workbook and target workbook reside on drive and then
target workbook moves to drive 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
o create hyperlink in a worksheet follow these steps:
Step 1: On a worksheet click the cell where hyperlink needs to be created.
Step 2: lick on Insert menu and then select yperlink option.
Advanced Features of Spreadsheet 183

