Manuals/calci/HYPERLINK

Revision as of 20:37, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''HYPERLINK'''</font></font></font><font color="#4...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
 HYPERLINK(lnk_loc,name)

where link_loc is the path and file name to the document to be opened as text.



  • Link_location can be a text string enclosed in quotation marks or a cell that contains the link as a text string.
  • If the jump specified in link_location does not exist or cannot be navigated, an error appears when you click the cell.

name    is the jump text or numeric value that is displayed in the cell.


 It creates a shortcut or jump that opens a document stored on a network server.

HYPERLINK


 

Let's see an example

=HYPERLINK("http://www.google.com", "Click Here")

This example creates a hyperlink for Click here.


Syntax

Examples

Description

Column1 Column2 Column3 Column4
Row1

Click Here

Row2
Row3
Row4
Row5
Row6