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
   180   181   182   183   184   185   186   187   188   189   190