Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.
Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.
HYPERLINK(link_location, [friendly_name])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")Risultato: Go to Google
Creates a clickable link with the display text 'Go to Google' that opens the Google homepage.
Yes, use the syntax =HYPERLINK("#[sheetname]![celladdress]", "Click here").