{"id":1801,"date":"2018-07-04T17:26:56","date_gmt":"2018-07-04T17:26:56","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1801"},"modified":"2023-11-03T09:08:09","modified_gmt":"2023-11-03T09:08:09","slug":"hyerlink","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/","title":{"rendered":"HYERLINK function"},"content":{"rendered":"\n

The HYPERLINK function in Excel is a useful tool for creating hyperlinks within your spreadsheet. It allows you to link to websites, other documents, specific cells or ranges within your workbook, and even send emails. This function is handy for creating interactive spreadsheets and navigating through your data efficiently.<\/p>\n\n\n\n

Syntax<\/h2>\n\n\n\n

=HYPERLINK(link_location, [friendly_name])<\/strong><\/p>\n\n\n\n

Arguments<\/h2>\n\n\n\n
link_location<\/strong><\/td>The address you want to link to. It can be a web URL, a file path, a cell reference, or an email address. You must enclose it in double quotes if it’s a text value.<\/td><\/tr>
[friendly_name]<\/strong><\/td>(Optional) The text or name you want to display for the hyperlink. If you don’t provide a friendly name, Excel will display the link_location as the text for the hyperlink.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

How to use<\/h2>\n\n\n\n

The HYPERLINK function is quite straightforward. You can use it in various ways:<\/p>\n\n\n\n

1. Create a hyperlink to a website:<\/strong><\/p>\n\n\n\n

Suppose you want to link to a website like Google. You can use the following formula:<\/p>\n\n\n\n

=HYPERLINK(\"https:\/\/www.google.com\", \"Visit Google\")<\/code><\/pre>\n\n\n\n
This will create a clickable link with the text “Visit Google” that directs you to the Google website when clicked.<\/p>\n\n\n\n
2. Link to a cell or range within the same workbook:<\/strong><\/p>\n\n\n\n
If you want to link to a different sheet or cell within the same Excel workbook, you can use cell references:<\/p>\n\n\n\n
=HYPERLINK(\"#Sheet2!A1\", \"Go to Sheet2\")<\/code><\/pre>\n\n\n\n
This formula will take you to cell A1 in Sheet2 and display “Go to Sheet2” as the link text.<\/p>\n\n\n\n
3. Send an email:<\/strong><\/p>\n\n\n\n
To create an email hyperlink, use the following format:<\/p>\n\n\n\n
=HYPERLINK(\"mailto:example@email.com\", \"Send Email\")<\/code><\/pre>\n\n\n\n
Clicking on “Send Email” will open the default email client with the recipient’s address pre-filled.<\/p>\n\n\n\n
4. Link to a file on your computer:<\/strong><\/p>\n\n\n\n
If you want to link to a file on your computer, use the file path as the link_location:<\/p>\n\n\n\n
=HYPERLINK(\"C:\\Documents\\example.pdf\", \"Open PDF\")<\/code><\/pre>\n\n\n\n
This will create a link to the specified file with “Open PDF” as the link text.<\/p>\n\n\n\n
Remember that the HYPERLINK function can be a powerful tool for enhancing your Excel spreadsheets, making them more interactive and user-friendly.<\/p>\n\n\n\n
Additional information<\/h2>\n\n\n\n
If you need further information or want to explore advanced hyperlink options, you can refer to Excel’s official documentation here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
The HYPERLINK function in Excel is a useful tool for creating hyperlinks within your spreadsheet. It allows you to link to websites, other…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nHYERLINK function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"HYERLINK function\" \/>\n<meta property=\"og:description\" content=\"The HYPERLINK function in Excel is a useful tool for creating hyperlinks within your spreadsheet. It allows you to link to websites, other...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T17:26:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T09:08:09+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"HYERLINK function\",\"datePublished\":\"2018-07-04T17:26:56+00:00\",\"dateModified\":\"2023-11-03T09:08:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/\"},\"wordCount\":352,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/\",\"name\":\"HYERLINK function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T17:26:56+00:00\",\"dateModified\":\"2023-11-03T09:08:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"HYERLINK function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"HYERLINK function","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/","og_locale":"en_US","og_type":"article","og_title":"HYERLINK function","og_description":"The HYPERLINK function in Excel is a useful tool for creating hyperlinks within your spreadsheet. It allows you to link to websites, other...","og_url":"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/","article_published_time":"2018-07-04T17:26:56+00:00","article_modified_time":"2023-11-03T09:08:09+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"HYERLINK function","datePublished":"2018-07-04T17:26:56+00:00","dateModified":"2023-11-03T09:08:09+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/"},"wordCount":352,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/","url":"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/","name":"HYERLINK function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T17:26:56+00:00","dateModified":"2023-11-03T09:08:09+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/hyerlink\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/hyerlink\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"HYERLINK function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1801"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1801"}],"version-history":[{"count":5,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1801\/revisions"}],"predecessor-version":[{"id":16450,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1801\/revisions\/16450"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}