Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
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")Ergebnis: 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").