7 Easy Ways to Insert Hyperlinks in Excel

Discover 7 simple and intuitive ways to insert hyperlinks into your Excel spreadsheet. Improve navigation and user experience with this comprehensive guide.

Inserting hyperlinks into a worksheet Excel This can be an extremely useful feature for improving navigation and the end-user experience. Whether it's links to web pages, other tabs in your file, or even email addresses, the options available to you are numerous and easy to implement.

In this article, we'll explore in detail seven simple and intuitive methods for inserting hyperlinks in Microsoft Excel. You'll discover how to make the most of the software's built-in features, as well as some more advanced techniques that will allow you to automate and customize your links. Get ready to make your spreadsheet even more interactive and user-friendly.

1. Insert a hyperlink from the Insert tab

One of the quickest ways to insert a hyperlink in Excel is through the "Insert" tab. Let's see how:

Add a link to a website

1. Select the cell where you want to insert the link.
2. Go to the “Insert” tab and click on the “Link” command.
3. In the "Insert Link" window, type a description in the "Text to Display" field. This will become the contents of your cell.
4. Click the “Hint” button to add a more detailed description that will appear when you hover over the link.
5. Paste the desired web address into the “Address” field.
6. Click “OK” to confirm.

Add a link to another tab

1. Select the cell from which you want to create the link.
2. Go to the “Insert” tab and click on the “Link” command.
3. In the “Insert Link” window, select the “Place in this document” option on the left.
4. Under “Cell Reference,” choose the tab you want to link to.
5. Type the reference of the specific cell you want to link to.
6. Click “OK” to confirm.

Add a link to an email

1. Select the cell to link.
2. Go to the “Insert” tab and click on the “Link” command.
3. In the “Insert Link” window, select the “Email Address” option on the left.
4. In the “Email Address” field, type the recipient’s address.
5. Describe the subject of the message in the “Subject” field and click “OK”.

2. Insert a hyperlink from the right-click menu

An alternative to the previous method is to use the menu that appears when you right-click on the cell you want to link:

1. Right-click the cell you want to make hyperlinked.
2. Select the “Connection” option.
3. You will be redirected back to the “Insert Link” window, where you can create any type of link you want.

3. Insert a hyperlink with a keyboard shortcut

Another convenient shortcut to access the “Insert Link” window is through a key combination:

1. Select the cell to link.
2. Press the “Ctrl” “K” keys on your keyboard.
3. This will instantly open the “Insert Link” window.

4. Insert a hyperlink with the LINK function

Excel offers a dedicated function called “LINK” that allows you to create hyperlinks in a similar manner to the “Insert Link” window.

Here's how to use it to link to a web page:=COLLEGAMENTO("http://www.example.com/", "Vai al sito")

The first argument is the web address you want to link to, while the second determines the text that will be displayed in the cell.

To link to another tab within the same file, the syntax is slightly different:=COLLEGAMENTO("#'Foglio2'!A1", "Vai al Foglio2")

Here the cell reference is preceded by the # symbol to indicate that the link is within the same file.

Finally, here's how to create a link to an email:=COLLEGAMENTO("mailto:example@email.com", "Invia e-mail")

The “mailto:” prefix indicates that it is an email address.

5. Insert a hyperlink with copy and paste

A unique method to insert a hyperlink is through copy and paste with the right mouse button:

1. Locate the target cell of your link.
2. Place the cursor on the cell border until a 4-way arrow appears.
3. Right-click and drag to the cell where you want to create the link, then release the button.
4. Select the “Create link here” option.

This method allows you to “paste” the link directly into the source cell.

6. Insert a hyperlink with VBA

If you're familiar with VBA programming, you can automate the insertion of hyperlinks into your Excel worksheet.

For example, suppose you have tab names in a range of cells. Here's how to convert them into hyperlinks:

1. Open the VBA Editor by pressing “Alt” “F11” or selecting “Visual Basic” in the “Developer” tab.
2. Go to the “Insert” menu and select “Module”.
3. Paste the following code into the new module:

 

Sub InsertHyperlinks() Dim sheet As Range Dim link_destination As String Dim friendly_name As String For Each sheet In Selection.Cells link_destination = "#'" 

1. Select the desired range of tab names.
2. Go to the “View” tab, select “Macros” and choose your “InsertHyperlinks” script.
3. Click “Run” to turn the names into hyperlinks.

7. Insert a hyperlink with Office Scripts

If you use Microsoft 365 Business, you can use Office Scripts to automate the insertion of hyperlinks into your Excel spreadsheet online.

Here's how to proceed:

1. Open your Excel file in your browser and go to the “Automate” tab.
2. Click “New Script” to create a new script.
3. Paste the following code into the editor:

 

function main(workbook: ExcelScript.Workbook) {
    let range = workbook.getSelectedRange();
    let numeroRighe = range.getRowCount();
    let numeroColonne = range.getColumnCount();
    
    for (let riga = 0; riga 

Select the desired range of tab names.
Click “Run” in the editor to apply the hyperlinks.

Conclusions
In this article, we've explored seven simple and intuitive methods for inserting hyperlinks in Microsoft Excel, leveraging both the software's built-in features and more advanced techniques like VBA and Office Scripts. You now have a wide range of options to make your spreadsheet even more interactive and user-friendly, simplifying navigation and improving the overall end-user experience. Which method did you find most convenient or interesting? Share your experience in the comments!
  Published in Excel

September 17, 2024
Paolo Bergamaschi
Excel
0