{"id":539607,"date":"2023-01-16T19:00:29","date_gmt":"2023-01-16T16:00:29","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/6-uses-for-the-hyperlink-function-in-microsoft-excel\/"},"modified":"2023-01-16T19:00:29","modified_gmt":"2023-01-16T16:00:29","slug":"6-uses-for-the-hyperlink-function-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/6-uses-for-the-hyperlink-function-in-microsoft-excel\/","title":{"rendered":"#6 Uses for the HYPERLINK Function in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a4154034eb7c\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a4154034eb7c\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/6-uses-for-the-hyperlink-function-in-microsoft-excel\/#%E2%80%9C6_Uses_for_the_HYPERLINK_Function_in_Microsoft_Excel%E2%80%9D\" >&#8220;6 Uses for the HYPERLINK Function in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/6-uses-for-the-hyperlink-function-in-microsoft-excel\/#What_Is_the_HYPERLINK_Function\" >What Is the HYPERLINK Function?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/6-uses-for-the-hyperlink-function-in-microsoft-excel\/#1_Link_to_a_Cell_in_the_Spreadsheet\" >1. Link to a Cell in the Spreadsheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/6-uses-for-the-hyperlink-function-in-microsoft-excel\/#2_Link_to_a_Cell_Within_the_Workbook\" >2. Link to a Cell Within the Workbook<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/6-uses-for-the-hyperlink-function-in-microsoft-excel\/#3_Link_to_a_Defined_Name\" >3. Link to a Defined Name<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/6-uses-for-the-hyperlink-function-in-microsoft-excel\/#4_Link_to_a_Workbook_on_Another_Drive\" >4. Link to a Workbook on Another Drive<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/buradabiliyorum.com\/en\/6-uses-for-the-hyperlink-function-in-microsoft-excel\/#5_Link_to_a_Workbook_on_the_Web\" >5. Link to a Workbook on the Web<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/buradabiliyorum.com\/en\/6-uses-for-the-hyperlink-function-in-microsoft-excel\/#6_Link_to_a_Word_Document\" >6. Link to a Word Document<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9C6_Uses_for_the_HYPERLINK_Function_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;6 Uses for the HYPERLINK Function in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\"\/><\/p>\n<div class=\"keytakeaways\">\n<p style=\"font-weight: 400;\">With the HYPERLINK function, you can enter a file path or URL with the sheet, cell, or defined name you want to link to. For example: &#8220;=HYPERLINK(&#8220;[HTG_Desktop.xlsx]Sheet1!A6&#8243;)&#8221; Insert display text to make your link friendlier.<\/p>\n<\/div>\n<p>Excel offers its own built-in linking feature in the toolbar. But the HYPERLINK function lets you do more, like a link to a workbook on your company intranet, shared server, another drive, or even a bookmark in a Word document. Let\u2019s look at everything you can do with this versatile function.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"What_Is_the_HYPERLINK_Function\"><\/span>What Is the HYPERLINK Function?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>HYPERLINK in Excel is a function for creating clickable links to all sorts of places and objects.\u00a0You could, of course, do some of the same things that HYPERLINK does using the Link tool in Excel. However, a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/767852\/functions-vs.-formulas-in-microsoft-excel-whats-the-difference\/\">formula gives you finer control of the link, and HYPERLINK is a simple function to learn that can get you comfortable with creating formulas in general. Additionally, HYPERLINK lets you link directly to a specific cell or defined name.<\/p>\n<p>The syntax for the function\u2019s formula is <code>HYPERLINK(location, text)<\/code> where only the first argument is required and contains the path to the Excel file.<\/p>\n<p>You can use the second argument to display specific text as the link. Place text in quotation marks or use a cell reference. For example, instead of displaying the file path or URL, you can display \u201cClick Here\u201d or a value from another cell in the current sheet.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Remove Hyperlinks in Microsoft Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"1_Link_to_a_Cell_in_the_Spreadsheet\"><\/span>1. Link to a Cell in the Spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To link to a certain cell in the current spreadsheet, you\u2019ll include the file name, sheet name, and cell reference. Notice that you place the file name in brackets and the entire argument in quotes.<\/p>\n<p>For example, with this formula, we link to cell A6 in our current spreadsheet named Sheet1. The file name is HTG_Desktop.xlsx. Remember to include the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/356448\/what-is-a-file-extension\/\">file extension, which is either .xls or .xlsx depending on your version of Excel.<\/p>\n<pre>=HYPERLINK(\"[HTG_Desktop.xlsx]Sheet1!A6\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855779\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkCurrentSheet-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK function to link within the current sheet\" width=\"650\" height=\"121\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To link to the same file, sheet, and cell, but use a friendly name for the link like \u201cGo to A6\u201d, you can use this formula:<\/p>\n<pre>=HYPERLINK(\"[HTG_Desktop.xlsx]Sheet1!A6\",\"Go to A6\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855778\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkCurrentSheetText-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK function to link within the current sheet and use display text\" width=\"650\" height=\"107\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"2_Link_to_a_Cell_Within_the_Workbook\"><\/span>2. Link to a Cell Within the Workbook<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To link to a cell in the current workbook, but on <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/828275\/how-to-link-to-another-sheet-in-microsoft-excel\/\">a different sheet, simply replace the current sheet name with the other sheet\u2019s name.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Link to Another Sheet in Microsoft Excel<\/em><\/strong><\/p>\n<p>Here, we\u2019ll link to cell B2 on Sheet2:<\/p>\n<pre>=HYPERLINK(\"[HTG_Desktop.xlsx]Sheet2!B2\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855782\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkOtherSheet-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK function to link to a cell in another sheet\" width=\"650\" height=\"121\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also insert the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/support.microsoft.com\/en-us\/office\/cell-function-51bd39a5-f338-4dbe-a33f-955d67c2b2cf\">CELL function<\/a> as the <code>location<\/code> argument rather than typing the file name. Here\u2019s the formula for linking to the same cell as above:<\/p>\n<pre>=HYPERLINK(CELL(\"address\",Sheet2!B2))<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855781\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkOtherSheetCELL-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK and CELL functions\" width=\"634\" height=\"125\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For this combined function formula, you can also enter display text for the <code>text<\/code> argument. Instead of adding text in quotes, we\u2019ll use the value in cell D1 which is the word \u201cTitle\u201d:<\/p>\n<pre>=HYPERLINK(CELL(\"address\",Sheet2!B2),D1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855780\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkOtherSheetCELLText-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK and CELL functions with a cell as display text\" width=\"650\" height=\"120\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"3_Link_to_a_Defined_Name\"><\/span>3. Link to a Defined Name<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maybe you\u2019d like to link to a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/242652\/how-to-assign-a-name-to-a-range-of-cells-in-excel\/\">named range of cells in the current or another Excel workbook. In this case, you\u2019ll add brackets around the path directly before the defined name.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Assign a Name to a Range of Cells in Excel<\/em><\/strong><\/p>\n<p>To link to the defined name Scores in the current workbook titled HTG_Desktop.xlsx, you\u2019d use the following formula:<\/p>\n<pre>=HYPERLINK(\"[HTG_Desktop.xlsx]Scores\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855786\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkCurrentDefinedName-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK function to link a defined name\" width=\"640\" height=\"125\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To link to the defined name Totals in a different workbook, you\u2019ll enter the complete path in brackets followed by the cell range name like this:<\/p>\n<pre>=HYPERLINK(\"[C:\\\\Users\\Sandy\\Desktop\\MyDataEntryForm.xlsx]Totals\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855784\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkOtherDefinedName-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK function to link a defined name in another sheet\" width=\"650\" height=\"94\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To use something different for the display text, in either example, simply add it to the second argument:<\/p>\n<pre>=HYPERLINK(\"[HTG_Desktop.xlsx]Scores\",\"Go There\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855783\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkOtherDefinedNameText-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK function to link a defined name with display text\" width=\"650\" height=\"112\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"4_Link_to_a_Workbook_on_Another_Drive\"><\/span>4. Link to a Workbook on Another Drive<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/358380\/how-to-link-or-embed-an-excel-worksheet-in-a-powerpoint-or-word-document\/\">Linking to an Excel file on a different drive on your computer is another option. You can also link directly to a cell or named range if needed.<\/p>\n<p>To link to the file without a designated cell or defined name, include the complete path in quotes. Here, we\u2019ll link to the file MyDataEntryForm.xlsx on the E drive.<\/p>\n<pre>=HYPERLINK(\"E:\\MyDataEntryForm.xlsx\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855789\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkOtherDrive-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK function to link a sheet on another drive\" width=\"638\" height=\"125\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For a particular cell, we\u2019ll link to C9 on Sheet1 in the same file and location. Add brackets around the path with the sheet name and cell reference afterwards.<\/p>\n<pre>=HYPERLINK(\"[E:\\MyDataEntryForm.xlsx]Sheet1!C9\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855788\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkOtherDriveCell-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK function to link a sheet cell on another drive\" width=\"650\" height=\"112\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For another example, we\u2019ll link to the named range Totals in the same file and location. Because you\u2019re using a defined name, be sure to insert the brackets around the path. Here, we\u2019ll include the display text Totals:<\/p>\n<pre>=HYPERLINK(\"[E:\\MyDataEntryForm.xlsx]Totals\",\"Totals\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-855791 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkOtherDriveDefinedNameText-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK function to link a defined name on another drive with text\" width=\"650\" height=\"107\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to See All of the Named Cell Ranges in an Excel Workbook<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"5_Link_to_a_Workbook_on_the_Web\"><\/span>5. Link to a Workbook on the Web<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maybe the workbook you want to link to is on your company intranet or a website. You can link to a\u00a0 remote XLSX file by including the full path in quotes as follows:<\/p>\n<pre>=HYPERLINK(\"http:\/\/www.mysite.com\/report.xlsx\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855796\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkWeb-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK function to link a workbook on the web\" width=\"650\" height=\"114\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To link to a specific sheet and cell, include the file path in brackets with the sheet name and cell reference directly following.<\/p>\n<pre>=HYPERLINK(\"[http:\/\/www.mysite.com\/report.xlsx],Sheet1!A7\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855795\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkWebCell-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK function to link a workbook cell on the web\" width=\"650\" height=\"102\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"6_Link_to_a_Word_Document\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_6\">6. Link to a Word Document<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to integrate your documents with your spreadsheets, you can use the HYPERLINK function to link to a Word document. Plus, you can link straight to a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/269379\/how-to-reuse-or-move-a-bookmark-in-microsoft-word\/\">bookmark you\u2019ve created in Word.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Reuse or Move a Bookmark in Microsoft Word<\/em><\/strong><\/p>\n<p>To link to the Word document, include the full path in quotes and don\u2019t forget the file extension. For Word, it\u2019s either .doc or .docx depending on your version:<\/p>\n<pre>=HYPERLINK(\"C:\\\\Users\\Sandy\\Desktop\\MiscWorkDoc.docx\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855794\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkWord-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK function to link a Word document\" width=\"650\" height=\"104\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To link to a bookmark in Word instead, you\u2019ll add those brackets followed by the bookmark name. Here, we link to the same file as above but directly to the bookmark named Details and include the display text Report:<\/p>\n<pre>=HYPERLINK(\"[C:\\\\Users\\Sandy\\Desktop\\MiscWorkDoc.docx]Details\",\"Report\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-855793\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/LinkWordBookmarkText-ExcelHYPERLINKFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"HYPERLINK function to link a Word document bookmark with text\" width=\"650\" height=\"90\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019re looking for an alternative way to create links in Excel, especially for a particular cell in another workbook or one on the web, keep the HYPERLINK function in mind.<\/p>\n<p>For more, look at how to link to cells or spreadsheets in Google Sheets too!<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/855773\/hyperlink-function-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;6 Uses for the HYPERLINK Function in Microsoft Excel&#8221; With the HYPERLINK function, you can enter a file path or URL with the sheet, cell, or defined name you want to link to. For example: &#8220;=HYPERLINK(&#8220;[HTG_Desktop.xlsx]Sheet1!A6&#8243;)&#8221; Insert display text to make your link friendlier. Excel offers its own built-in linking feature in the toolbar. But&#8230;<\/p>\n","protected":false},"author":1,"featured_media":539608,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-539607","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/539607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=539607"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/539607\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/539608"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=539607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=539607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=539607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}