Función de Google Sheets

HYPERLINK

Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

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.

Argumentos

link_locationobligatorioThe path and file name to the document to be opened as text.
friendly_nameopcionalThe jump text or numeric value that is displayed in the cell.

Ejemplos

=HYPERLINK("https://www.google.com", "Go to Google")

Resultado: Go to Google

Creates a clickable link with the display text 'Go to Google' that opens the Google homepage.

Preguntas frecuentes

Can I link to a specific cell in the same workbook?

Yes, use the syntax =HYPERLINK("#[sheetname]![celladdress]", "Click here").

Funciones relacionadas

INDIRECT OFFSET