Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
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")Résultat : 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").