How to Edit Hyperlink in Excel (5 Quick & Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

In this tutorial, I will explain how to edit a hyperlink in excel. Usually, we use hyperlinks often to serve different purposes such as: to go to a specific website, a location in the existing workbook, or opening a new excel file. In addition, you can open a different document or create email messages. However, you might need to edit these hyperlinks at times or fix broken ones. So, let’s see how we can edit hyperlinks.


How to Edit Hyperlink in Excel: 5 Quick & Easy Ways

In my Excel file, I have created several hyperlinks as below. Now, I will show you how to edit some of them.

5 Quick & Easy Ways to Edit Hyperlink in Excel

1. Edit Hyperlink through a Simple Right-Click in Excel

The easiest option to edit hyperlinks is to right-click on the active cell and thus edit later. For instance, Cell B5 is hyperlinked to www.exceldemy.com and I want to edit the link to www.google.com.

Steps:

  • Right-click on Cell B5 and select the Edit Hyperlink.

Edit Hyperlink through a Simple Right-Click in Excel

  • As a result, the Edit Hyperlink dialog box will show up.

Edit Hyperlink through a Simple Right-Click in Excel

  • Next, I have replaced ‘exceldemy’ with ‘google’ in the fields: Text to display and Address. You can edit as you require and then click OK.

Edit Hyperlink through a Simple Right-Click in Excel

  • As a consequence, the hyperlink in Cell B5 will direct you to google.com. You can change other hyperlinks by following the above method; depending on the type of the links.

Read More: How to Create a Hyperlink in Excel


2. Use Link Option to Modify Hyperlink (from Insert Tab in Excel)

We can modify hyperlinks from the Insert tab in excel. For example, I will change the hyperlink of Cell B5 to www.microsoft.com.

Steps:

  • Click on the hyperlink containing cell (Cell B5).

Use Link Option to Modify Hyperlink (from Insert Tab in Excel)

  • Go to Insert > Link (Links group).

Use Link Option to Modify Hyperlink (from Insert Tab in Excel)

  • Now, go to Link > Insert Link.

Use Link Option to Modify Hyperlink (from Insert Tab in Excel)

  • Then, the Edit Hyperlink dialog box will show up. Put ‘microsoft’ here like we showed in the procedure of Method 1 and click OK (see screenshot).

Use Link Option to Modify Hyperlink (from Insert Tab in Excel)

  • Finally, the modified hyperlink will direct us to the updated website.

Read More: Excel Hyperlink with Shortcut Key


3. Edit Multiple Hyperlink Path at Once (VBA)

Sometimes, we have multiple cells hyperlinked to the same address. In that case, if we can change the address of those multiple cells at once, that will save a lot of time.  For instance, I have several cells that are hyperlinked to www.exceldemy.com. Now I will convert this path to www.google.com using VBA.

Edit Multiple Hyperlink Path at Once (VBA)

Steps:

  • First, go to the sheet where the cells are hyperlinked and right-click on the sheet name, and select the View Code option.

Edit Multiple Hyperlink Path at Once (VBA)

  • Next, Microsoft Visual Basic for Applications window will show up. Write the below code in the Module.

Sub EditHyperlinks()

Dim Sheet As Worksheet
Dim xhyperlink As Hyperlink
Dim xPast As String, xChanged As String
xTitleId = "EditHyperlink"
Set Sheet = Application.ActiveSheet
xPast = Application.InputBox("Former text:", xTitleId, "", Type:=2)
xChanged = Application.InputBox("Changed text:", xTitleId, "", Type:=2)
Application.ScreenUpdating = False
For Each xhyperlink In Sheet.Hyperlinks
    xhyperlink.Address = Replace(xhyperlink.Address, xPast, xChanged)
Next
Application.ScreenUpdating = True

End Sub
Edit Multiple Hyperlink Path at Once (VBA)
  • Run the code using the F5 Upon running the code the below window (EditHyperlink) will show up. Then write ‘exceldemy’ in the field ‘Former text’ and click OK. I have put ‘exceldemy’ as our existing hyperlinks contain this word in the path.

Edit Multiple Hyperlink Path at Once (VBA)

  • After you click OK again, the EditHyperlink window will show up. Now enter the new website address (google) in the ‘Changed text’ field and click OK.

Edit Multiple Hyperlink Path at Once (VBA)

  • Consequently, all hyperlinked addresses are changed to www.google.com.

Read More: [Fix:] Hyperlink to Website Not Working in Excel


4. Edit Broken Hyperlink in Excel

Sometimes, hyperlinks do not work as expected. The reason might be that you have entered the wrong web addresses or wrong file path and so on. Let’s see how to fix these broken links. Such as if your web address is not correct, you will see the below warning (see the screenshot).

Edit Broken Hyperlink in Excel

To fix the above symptom, we will follow the below steps.

Steps:

  • Go to the hyperlink containing cell (Cell B5) and right-click on it to bring the Edit Hyperlink dialog box.
  • Then fix the URL in the Address field. For example, I have replaced ‘exceldem’ with ‘exceldemy’. Next, click OK.

Edit Broken Hyperlink in Excel

  • As a result, the broken link will be fixed and the link will direct us to the website.
  • In case your hyperlink cannot open a specific file, you have to update the file path as below and click OK (see the screenshot).

Read More: How to Fix Broken Hyperlinks in Excel


5. Modify Hyperlink If Appears as String

Sometimes when we copy addresses to excel cells, those URLs might not look like clickable hyperlinks. Those links will merely look like text strings. For example, I have some web addresses copied to my Excel file.

Modify Hyperlink If Appears as String

To convert above URLs to hyperlinks, follow the below steps.

Steps:

  • Just double-click on the cell containing the non-clickable URL (Cell B5) and hit Enter.

Modify Hyperlink If Appears as String

  • As a result, excel will automatically convert the URL to a hyperlink.

Read More: How to Convert Text to Hyperlink in Excel


Modify Hyperlink Appearance in Excel

We know that by default the color of hyperlinks is blue. If you want to change the color of the hyperlink of a selected cell, follow the below steps.

Steps:

  • Select the Cell B5.

Modify Hyperlink Appearance in Excel

  • Go to Home > Cell Styles (Styles group).

Modify Hyperlink Appearance in Excel

  • Next, from Cell Styles, right-click on the Following Hyperlink and click on Modify.

Modify Hyperlink Appearance in Excel

  • Consequently, the Style dialog box will pop up. Click on the Format.

Modify Hyperlink Appearance in Excel

  • Clicking on the Format will direct you to the Format Cells window. You can change font style, size, color, etc, from there. After you are done with the editing, click OK. I have changed the Font Color only.

Modify Hyperlink Appearance in Excel

  • Upon clicking OK, you will see the changes in the Style dialog, again click OK.

Modify Hyperlink Appearance in Excel

  • Now, double-click on Cell B5, and the hyperlink will be modified to changed color.

Note:

➤ You can change the color of the hyperlinks that are not clicked yet by following the path:

Home > Cells Styles > Hyperlink.

➤ You cannot change the color of only one hyperlink following the above method, the color of all the hyperlinks in the workbook will change.

Read More: How to Combine Text and Hyperlink in Excel Cell


Download Practice Workbook

You can download the practice workbook that we have used to prepare this article.


Conclusion

In the above article, I have tried to discuss several methods to edit the hyperlink in Excel elaborately. Hopefully, these methods and explanations will be enough to solve your problems. Please let me know if you have any queries.


Related Articles

<< Go Back To Hyperlink in Excel | Linking in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Hosne Ara
Hosne Ara

Hosne Ara is a materials and metallurgical engineer who loves exploring Excel and VBA programming. To her, programming is like a time-saving superhero for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B. Sc. in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, she's shifted gears and now works as a content developer. In this role, she... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo