{"id":30730,"date":"2023-01-16T17:21:54","date_gmt":"2023-01-16T17:21:54","guid":{"rendered":"https:\/\/mailinvest.blog\/index.php\/2023\/01\/16\/6-uses-for-the-hyperlink-function-in-microsoft-excel\/"},"modified":"2023-01-16T17:22:54","modified_gmt":"2023-01-16T17:22:54","slug":"6-uses-for-the-hyperlink-function-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/mailinvest.blog\/index.php\/2023\/01\/16\/6-uses-for-the-hyperlink-function-in-microsoft-excel\/","title":{"rendered":"6 Uses for the HYPERLINK Function in Microsoft Excel"},"content":{"rendered":"

<\/a>\n<\/p>\n

\n

\"Microsoft<\/p>\n

\n

With the HYPERLINK operate, you’ll be able to enter a file path or URL with the sheet, cell, or outlined identify you wish to hyperlink to. For instance: “=HYPERLINK(“[HTG_Desktop.xlsx]Sheet1!A6″)” Insert show textual content to make your hyperlink friendlier.<\/p>\n<\/div>\n

Excel presents its personal built-in linking feature in the toolbar<\/a>. However the HYPERLINK operate allows you to do extra, like a hyperlink to a workbook in your firm intranet, shared server, one other drive, or perhaps a bookmark in a Phrase doc. Let\u2019s take a look at the whole lot you are able to do with this versatile operate.<\/p>\n

What Is the HYPERLINK Perform?<\/h2>\n

HYPERLINK in Excel is a operate for creating clickable hyperlinks to all kinds of locations and objects.\u00a0You might, in fact, do among the identical issues that HYPERLINK does utilizing the Hyperlink instrument in Excel. Nevertheless, a formula<\/a> provides you finer management of the hyperlink, and HYPERLINK is a straightforward operate to study that may get you snug with creating formulation usually. Moreover, HYPERLINK allows you to hyperlink on to a particular cell or outlined identify.<\/p>\n

The syntax for the operate\u2019s method is HYPERLINK(location, textual content)<\/code> the place solely the primary argument is required and incorporates the trail to the Excel file.<\/p>\n

You should utilize the second argument to show particular textual content because the hyperlink. Place textual content in citation marks or use a cell reference. For instance, as an alternative of displaying the file path or URL<\/a>, you’ll be able to show \u201cClick on Right here\u201d or a price from one other cell within the present sheet.<\/p>\n

RELATED:<\/strong> How to Remove Hyperlinks in Microsoft Excel<\/em><\/strong><\/a><\/p>\n

1. Hyperlink to a Cell within the Spreadsheet<\/h2>\n

To hyperlink to a sure cell within the present spreadsheet, you\u2019ll embody the file identify, sheet identify, and cell reference. Discover that you just place the file identify in brackets and the complete argument in quotes.<\/p>\n

For instance, with this method, we hyperlink to cell A6 in our present spreadsheet named Sheet1. The file identify is HTG_Desktop.xlsx. Keep in mind to incorporate the file extension<\/a>, which is both .xls or .xlsx relying in your model of Excel.<\/p>\n

=HYPERLINK(\"[HTG_Desktop.xlsx]Sheet1!A6\")<\/pre>\n
\"HYPERLINK<\/p>\n
To hyperlink to the identical file, sheet, and cell, however use a pleasant identify for the hyperlink like \u201cGo to A6\u201d, you should use this method:<\/p>\n
=HYPERLINK(\"[HTG_Desktop.xlsx]Sheet1!A6\",\"Go to A6\")<\/pre>\n
\"HYPERLINK<\/p>\n
2. Hyperlink to a Cell Throughout the Workbook<\/h2>\n
To hyperlink to a cell within the present workbook, however on a different sheet<\/a>, merely exchange the present sheet identify with the opposite sheet\u2019s identify.<\/p>\n
RELATED:<\/strong> How to Link to Another Sheet in Microsoft Excel<\/em><\/strong><\/a><\/p>\n
Right here, we\u2019ll hyperlink to cell B2 on Sheet2:<\/p>\n
=HYPERLINK(\"[HTG_Desktop.xlsx]Sheet2!B2\")<\/pre>\n
\"HYPERLINK<\/p>\n
You too can insert the CELL function<\/a> because the location<\/code> argument moderately than typing the file identify. Right here\u2019s the method for linking to the identical cell as above:<\/p>\n
=HYPERLINK(CELL(\"handle\",Sheet2!B2))<\/pre>\n
\"HYPERLINK<\/p>\n
For this mixed operate method, you may also enter show textual content for the textual content<\/code> argument. As a substitute of including textual content in quotes, we\u2019ll use the worth in cell D1 which is the phrase \u201cTitle\u201d:<\/p>\n
=HYPERLINK(CELL(\"handle\",Sheet2!B2),D1)<\/pre>\n
\"HYPERLINK<\/p>\n
3. Hyperlink to a Outlined Title<\/h2>\n
Possibly you\u2019d wish to hyperlink to a named range of cells<\/a> within the present or one other Excel workbook. On this case, you\u2019ll add brackets across the path straight earlier than the outlined identify.<\/p>\n
RELATED:<\/strong> How to Assign a Name to a Range of Cells in Excel<\/em><\/strong><\/a><\/p>\n
To hyperlink to the outlined identify Scores within the present workbook titled HTG_Desktop.xlsx, you\u2019d use the next method:<\/p>\n
=HYPERLINK(\"[HTG_Desktop.xlsx]Scores\")<\/pre>\n
\"HYPERLINK<\/p>\n
To hyperlink to the outlined identify Totals in a unique workbook, you\u2019ll enter the entire path in brackets adopted by the cell vary identify like this:<\/p>\n
=HYPERLINK(\"[C:UsersSandyDesktopMyDataEntryForm.xlsx]Totals\")<\/pre>\n
\"HYPERLINK<\/p>\n
To make use of one thing completely different for the show textual content, in both instance, merely add it to the second argument:<\/p>\n
=HYPERLINK(\"[HTG_Desktop.xlsx]Scores\",\"Go There\")<\/pre>\n
\"HYPERLINK<\/p>\n
4. Hyperlink to a Workbook on One other Drive<\/h2>\n
Linking to an Excel file<\/a> on a unique drive in your laptop is an alternative choice. You too can hyperlink on to a cell or named vary if wanted.<\/p>\n
To hyperlink to the file with no designated cell or outlined identify, embody the entire path in quotes. Right here, we\u2019ll hyperlink to the file MyDataEntryForm.xlsx on the E drive.<\/p>\n
=HYPERLINK(\"E:MyDataEntryForm.xlsx\")<\/pre>\n
\"HYPERLINK<\/p>\n
For a selected cell, we\u2019ll hyperlink to C9 on Sheet1 in the identical file and site. Add brackets across the path with the sheet identify and cell reference afterwards.<\/p>\n
=HYPERLINK(\"[E:MyDataEntryForm.xlsx]Sheet1!C9\")<\/pre>\n
\"HYPERLINK<\/p>\n
For an additional instance, we\u2019ll hyperlink to the named vary Totals in the identical file and site. Since you\u2019re using a defined name<\/a>, be sure you insert the brackets across the path. Right here, we\u2019ll embody the show textual content Totals:<\/p>\n
=HYPERLINK(\"[E:MyDataEntryForm.xlsx]Totals\",\"Totals\")<\/pre>\n
\"HYPERLINK<\/p>\n
RELATED:<\/strong> How to See All of the Named Cell Ranges in an Excel Workbook<\/em><\/strong><\/a><\/p>\n
5. Hyperlink to a Workbook on the Internet<\/h2>\n
Possibly the workbook you wish to hyperlink to is in your firm intranet or an internet site. You may hyperlink to a\u00a0 distant XLSX file by together with the total path in quotes as follows:<\/p>\n
=HYPERLINK(\"http:\/\/www.mysite.com\/report.xlsx\")<\/pre>\n
\"HYPERLINK<\/p>\n
To hyperlink to a particular sheet and cell, embody the file path in brackets with the sheet identify and cell reference straight following.<\/p>\n
=HYPERLINK(\"[http:\/\/www.mysite.com\/report.xlsx],Sheet1!A7\")<\/pre>\n
\"HYPERLINK<\/p>\n
6. Hyperlink to a Phrase Doc<\/h2>\n
If you wish to combine your paperwork along with your spreadsheets, you should use the HYPERLINK operate to hyperlink to a Phrase doc. Plus, you’ll be able to hyperlink straight to a bookmark you\u2019ve created in Word<\/a>.<\/p>\n
RELATED:<\/strong> How to Reuse or Move a Bookmark in Microsoft Word<\/em><\/strong><\/a><\/p>\n
To hyperlink to the Phrase doc, embody the total path in quotes and don\u2019t overlook the file extension. For Phrase, it\u2019s both .doc or .docx relying in your model:<\/p>\n
=HYPERLINK(\"C:UsersSandyDesktopMiscWorkDoc.docx\")<\/pre>\n
\"HYPERLINK<\/p>\n
To hyperlink to a bookmark in Phrase as an alternative, you\u2019ll add these brackets adopted by the bookmark identify. Right here, we hyperlink to the identical file as above however on to the bookmark named Particulars and embody the show textual content Report:<\/p>\n
=HYPERLINK(\"[C:UsersSandyDesktopMiscWorkDoc.docx]Particulars\",\"Report\")<\/pre>\n
\"HYPERLINK<\/p>\n
Should you\u2019re searching for an alternate strategy to create hyperlinks in Excel, particularly for a selected cell in one other workbook or one on the net, preserve the HYPERLINK operate in thoughts.<\/p>\n
For extra, take a look at the best way to link to cells or spreadsheets in Google Sheets<\/a> too!<\/p>\n<\/div>\n