Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.
Sintaxis
HYPERLINK(link_location, [friendly_name])Argumentos
link_locationobligatorio
The path and file name to the document to be opened as text.
friendly_nameopcional
The jump text or numeric value that is displayed in the cell.
The HYPERLINK function allows you to navigate to a specific file, web page, or location within a workbook. When a user clicks the cell containing this function, Excel opens the target destination.
=HYPERLINK("https://www.google.com", "Go to Google")→Go to GoogleCreates a clickable link with the display text 'Go to Google' that opens the Google homepage.
Select the cell
Click on the cell where you want the hyperlink to appear.
Enter the formula
Type =HYPERLINK followed by the URL and the display name in quotes.
Yes, use the syntax =HYPERLINK("#[sheetname]![celladdress]", "Click here").