Excel offers its ownbuilt-in linking feature in the toolbar.
Let’s look at everything you could do with this versatile function.
What Is the HYPERLINK Function?
HYPERLINK in Excel is a function forcreating clickable linksto all sorts of places and objects.
Additionally, HYPERLINK lets you link directly to a specific cell or defined name.
you’re free to use the second argument to display specific text as the link.
Place text in quotation marks or use a cell reference.
Related:How to Remove Hyperlinks in Microsoft Excel
1.
Notice that you place the file name in brackets and the entire argument in quotes.
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 thefile extension, which is either .xls or .xlsx depending on your version of Excel.
In this case, you’ll add brackets around the path directly before the defined name.
you’re able to also link directly to a cell or named range if needed.
To link to the file without a designated cell or defined name, include the complete path in quotes.
Here, we’ll link to the file MyDataEntryForm.xlsx on the E drive.
For a particular cell, we’ll link to C9 on Sheet1 in the same file and location.
Add brackets around the path with the sheet name and cell reference afterwards.
For another example, we’ll link to the named range Totals in the same file and location.
Because you’reusing a defined name, be sure to insert the brackets around the path.
Here, we’ll include the display text Totals:
5.
Plus, you might link straight to abookmark you’ve created in Word.
For more, look at how tolink to cells or spreadsheets in Google Sheetstoo!
