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