How To Change The Name Of A Hyperlink In Word

The tutorial explains how to hyperlink in Excel by using 3 different methods. You will acquire how to insert, change and remove hyperlinks in your worksheets and at present to fix not-working links.

Hyperlinks are widely used on the Internet to navigate between web-sites. In your Excel worksheets, you can easily create such links likewise. In improver, you can insert a hyperlink to become to another prison cell, sheet or workbook, to open up a new Excel file or create an email bulletin. This tutorial provides the detailed guidance on how to do this in Excel 2016, 2013, 2010 and earlier versions.

• What is hyperlink in Excel
• How to create hyperlink in Excel
  • Insert links by using the Hyperlink feature
  • Create links by using the HYPERLINK role
  • Insert hyperlink in Excel programmatically
• How to edit hyperlinks in Excel
• How to remove hyperlinks in Excel
• Tips for using hyperlinks in Excel
  • Select a cell without opening a link
  • Extract URLs from hyperlinks
  • Catechumen a worksheet object into a clickable hyperlink
• Excel hyperlinks not working

What is hyperlink in Excel

An Excel hyperlink is a reference to a specific location, document or web-page that the user can bound to by clicking the link.

Microsoft Excel enables y'all to create hyperlinks for many unlike purposes including:

• Going to a certain location within the current workbook
• Opening another document or getting to a specific place in that document, east.g. a sheet in an Excel file or bookmark in a Word document.
• Navigating to a web-page on the Internet or Intranet
• Creating a new Excel file
• Sending an e-mail to a specified address

Hyperlinks in Excel are easily recognizable - generally this is text highlighted in underlined bluish like shown in the screenshot below.

Absolute and relative hyperlinks in Excel

Microsoft Excel supports 2 types of links: absolute and relative, depending on whether you lot specify a total or partial address.

An absolute hyperlink contains a total address, including the protocol and domain name for URLs, and the entire path and file name for documents. For example:

Absolute URL: https://www.ablebits.com/excel-lookup-tables/index.php

Accented link to an Excel file: C:\Excel files\Source Data\Book1.xlsx

A relative hyperlink contains a partial accost. For example:

Relative URL: excel-lookup-tables/index.php

Relative link to an Excel file: Source data\Book3.xlsx

On the spider web, it'south a common practice to use relative URLs. In your Excel hyperlinks, yous should always supply full URLs for spider web-pages. Though, Microsoft Excel can understand URLs without a protocol. For example, if you blazon "www.ablebits.com" in a jail cell, Excel volition automatically add the default "http" protocol and convert information technology into a hyperlink you can follow.

When creating links to Excel files or other documents stored on your calculator, you tin can apply either absolute or relative addresses. In a relative hyperlink, a missing office of the file path is relative to the location of the active workbook. The primary reward of this approach is that you don't accept to edit the link address when the files are moved to another location. For example, if your agile workbook and target workbook reside on drive C, and so you move them to drive D, relative hyperlinks will proceed working as long equally the relative path to the target file remains unchanged. In case of an absolute hyperlink, the path should exist updated every time the file is moved to another place.

How to create a hyperlink in Excel

In Microsoft Excel, the same task can often be accomplished in a few different ways, and information technology is as well true for creating hyperlinks. To insert a hyperlink in Excel, you can use any of the post-obit:

• Insert Hyperlink dialog
• HYPERLINK function
• VBA code

How to insert a hyperlink using the Excel Hyperlink feature

The most mutual mode to put a hyperlink straight into a cell is by using the Insert Hyperlink dialog, which can be accessed in 3 dissimilar ways. Simply select the cell where you want to insert a link and practise one of the following:

And now, depending on what sort of link you want to create, continue with i of the post-obit examples:

• Hyperlink to some other document
• Hyperlink to web-page (URL)
• Hyperlink to a specific pace in the current workbook
• Hyperlink to a new workbook
• Hyperlink to an email address

Create hyperlink to some other certificate

To insert a hyperlink to another document such as a unlike Excel file, Word document or PowerPoint presentation, open the Insert Hyperlink dialog, and perform the steps below:

1. On the left-hand panel, under Link to, click the Existing File or Spider web Page
2. In the Look in list, browse to the location of the target file, and then select the file.
3. In the Text to display box, type the text you desire to appear in the cell ("Book3" in this case).
4. Optionally, click the ScreenTip… push in the upper-right corner, and enter the text to be displayed when the user hovers the mouse over the hyperlink. In this example, it's "Goto Book3 in My Documents".
5. Click OK.

The hyperlink is inserted in the selected prison cell and looks exactly equally y'all've configured it:

To link to a specific canvass or cell, click the Bookmark… button in the correct-mitt part of the Insert Hyperlink dialog box, select the sail and type the target jail cell address in the Type in the cell reference box, and click OK.

To link to a named range, select information technology under Defined names similar shown below:

Add a hyperlink to a web address (URL)

To create a link to a web page, open the Insert Hyperlink dialog, and go along with the following steps:

1. Under Link to, select Existing File or Web Page.
2. Click the Browse the Web button, open the web page y'all want to link to, and switch dorsum to Excel without closing your web browser.

Excel will insert the web site Address and Text to display for you lot automatically. You tin can modify the text to display the way you want, enter a screen tip if needed, and click OK to add the hyperlink.

Alternatively, you tin can copy the web page URL earlier opening the Insert Hyperlink dialog, and then merely paste the URL in the Address box.

Hyperlink to a sheet or prison cell in the current workbook

To create a hyperlink to a specific sheet in the active workbook, click the Identify in this Document icon. Under Cell Reference, select the target worksheet, and click OK.

To create an Excel hyperlink to cell, type the cell reference in the Type in the cell reference box.

To link to a named range, select it nether the Defined Names node.

Insert a hyperlink to open a new Excel workbook

Too linking to existing files, you can create a hyperlink to a new Excel file. Here'south how:

1. Under Link to, click the Create New Document icon.
2. In the Text to display box, blazon the link text to be displayed in the cell.
3. In the Proper noun of new certificate box, enter the new workbook name.
4. Under Full path, check the location where the newly created file will be saved. If you lot desire to modify the default location, click the Change button.
5. Nether When to edit, select the desired editing option.
6. Click OK.

A hyperlink to create an electronic mail message

Apart from linking to various documents, the Excel Hyperlink feature allows yous to send an email bulletin directly from your worksheet. To take it washed, follow these steps:

1. Under Link to, select the E-mail Address icon.
2. In the Electronic mail accost box, type the e-mail address of your recipient, or multiple addresses separated with semicolons.
3. Optionally, enter the message subject in the Subject box. Please keep in mind that some browsers and e-mail clients may not recognize the subject field line.
4. In the Text to display box, blazon the desired link text.
5. Optionally, click the ScreenTip… button and enter the text yous want (the screen tip will be displayed when you hover over the hyperlink with the mouse).
6. Click OK.

Tip. The fastest way to brand a hyperlink to a specific east-mail address it to blazon the address directly in a cell. As soon as you striking the Enter key, Excel will automatically convert information technology into a clickable hyperlink.

How to create links by using HYPERLINK part

If you are one of those Excel pros that employ formulas to tackle most of the tasks, yous can utilise the HYPERLINK role, which is specially designed to inset hyperlinks in Excel. It is peculiarly useful when you intend to create, edit or remove multiple links at a fourth dimension.

The syntax of the HYPERLINK office is as follows:

HYPERLINK(link_location, [friendly_name])

Where:

• Link_location is the path to the target document or web-page.
• Friendly_name is the link text to be displayed in a cell.

For instance, to create a hyperlink titled "Source data" that opens Sheet2 in the workbook named "Source information" stored in the "Excel files" folder on drive D, utilize this formula:

=HYPERLINK("[D:\Excel files\Source data.xlsx]Sheet2!A1", "Source data")

For the detailed explanation of the HYPERLINK part arguments and formula examples to create diverse types of links, please see How to use Hyperlink function in Excel.

How to insert hyperlink in Excel by using VBA

To automate the cosmos of hyperlink in your worksheets, you tin can use this simple VBA code:

            Public Sub AddHyperlink() 	 			Sheets("Sheet1").Hyperlinks.Add Anchor:=Sheets("Sheet1").Range("A1"), Address:="", SubAddress:="Sheet3!B5", TextToDisplay:="My hyperlink" 	 	End Sub          

Where:

• Sheets - the proper name of a sheet on which the link should be inserted (Canvas 1 in this example).
• Range - a cell where the link should be inserted (A1 in this example).
• SubAddress - link destination, i.e. where the hyperlink should signal to (Sheet3!B5 in this case).
• TextToDisplay -text to be displayed in a cell ("My hyperlink" in this case).

Given the above, our macro will insert a hyperlink titled "My hyperlink" in jail cell A1 on Sheet1 in the active workbook. Clicking the link will take you to jail cell B5 on Sheet3 in the aforementioned workbook.

If you have little feel with Excel macros, yous may notice the following instructions helpful: How to insert and run VBA lawmaking in Excel

How to alter hyperlink in Excel

If you lot created a hyperlink by using the Insert Hyperlink dialog, then apply a similar dialog to change it. For this, right-click a cell property the link, and select Edit Hyperlink… from the context menu or press the Crtl+K shortcut or click the Hyperlink push on the ribbon.

Whichever you lot practice, the Edit Hyperlink dialog box volition testify up. You lot make the desired changes to the link text or link location or both, and click OK.

To modify a formula-driven hyperlink, select the cell containing the Hyperlink formula and modify the formula's arguments. The following tip explains how to select a cell without navigating to the hyperlink location.

To alter multiple Hyperlink formulas, utilise Excel'southward Replace All feature as shown in this tip.

How to change a hyperlink appearance

By default, Excel hyperlinks take a traditional underlined blue formatting. To change the default appearance of a hyperlink text, perform the following steps:

1. Go to the Home tab, Styles group, and either:
   • Right-click Hyperlink, and then click Modify… to change the appearance of hyperlinks that accept non been clicked yet.
   • Right-click Followed Hyperlink, then click Modify… to modify the formatting of hyperlinks that accept been clicked.

   

2. In the Fashion dialog box that appears, click Format…
   
3. In the Format Cells dialog, switch to the Font and/or Make full tab, apply the options of your choosing, and click OK. For case, you can change the font style and font color like shown in the screenshot beneath:
   
4. The changes will exist immediately reflected in the Style dialog. If upon a 2d idea, you decide not to apply certain modifications, clear the check boxes for those options.
   
5. Click OK to relieve the changes.

Note. All changes made to the hyperlink style will apply to all hyperlinks in the current workbook. Information technology is not possible to change formatting of private hyperlinks.

How to remove hyperlink in Excel

Removing hyperlinks in Excel is a two-click process. You only right-click a link, and select Remove Hyperlink from the context carte du jour.

This will remove a clickable hyperlink, but keep the link text in a cell. To delete the link text too, correct-click the cell, and so click Clear Contents.

Tips for using hyperlinks in Excel

Now that you know how to create, modify and remove hyperlinks in Excel, you may desire to learn a couple of useful tips to work with links most efficiently.

How to select a cell containing a hyperlink

By default, clicking a jail cell that contains a hyperlink takes y'all to the link destination, i.e. a target document or spider web-page. To select a cell without jumping to the link location, click the prison cell and hold the mouse button until the pointer turns into a cross (Excel pick cursor) , and then release the push button.

If a hyperlink occupies but part of a prison cell (i.east. if your cell is wider than the link's text), move the mouse pointer over the whitespace, and equally before long as information technology changes from a pointing manus to a cantankerous, click the jail cell:

Ane more mode to select a prison cell without opening a hyperlink is to select a neighboring prison cell, and apply the arrow keys to get to the link cell.

How to extract a web address (URL) from Excel hyperlink

There are two ways to extract a URL from a hyperlink in Excel: manually and programmatically.

Extract a URL from a hyperlink manually

If you accept simply a couple of hyperlinks, yous tin can speedily excerpt their destinations past following these simple steps:

1. Select a cell containing the hyperlink.
2. Open the Edit Hyperlink dialog by pressing Ctrl + K, or right-click a hyperlink and then click Edit hyperlink….
3. In the Address field, select the URL and printing Ctrl + C to re-create it.
   
4. Press Esc or click OK to close the Edit Hyperlink dialog box.
5. Paste the copied URL into any empty prison cell. Done!

Excerpt multiple URLs by using VBA

If yous have a swell lot of hyperlinks in your Excel worksheets, extracting each URL manually would be a waste product of time. The following macro can speed upwards the process by extracting addresses from all hyperlinks on the current sheet automatically:

            Sub ExtractHL() 			Dim HL As Hyperlink 			Dim OverwriteAll Equally Boolean 	 			OverwriteAll = False 	 			For Each HL In ActiveSheet.Hyperlinks 	 					If Non OverwriteAll So 							If HL.Range.Beginning(0, 1).Value <> "" Then 									If MsgBox("1 or more of the target cells is not empty. Practice y'all want to overwrite all cells?", vbOKCancel, "Target cells are not empty") = vbCancel Then 											Exit For 									Else 											OverwriteAll = True 									Stop If 							End If 					Stop If 					HL.Range.Offset(0, i).Value = HL.Address 			Next 	 	End Sub          

Every bit shown in the screenshot below, the VBA lawmaking gets URLs from a column of hyperlinks, and puts the results in the neighboring cells.

If 1 or more cells in the side by side column contains data, the code volition display a alert dialog asking the user if they want to overwrite the electric current data.

Convert worksheet objects into clickable hyperlinks

Autonomously from text in a jail cell, many worksheet objects including charts, pictures, text boxes and shapes can be turned into clickable hyperlinks. To have it done, you simply right-click an object (a WordArt object in the screenshot beneath), click Hyperlink…, and configure the link as described in How to create hyperlink in Excel.

Tip. The right-click menu of charts does not have the Hyperlink option. To convert an Excel nautical chart into a hyperlink, select the nautical chart, and press Ctrl + K.

Excel hyperlinks not working - reasons and solutions

If hyperlinks are not working properly in your worksheets, the following troubleshooting steps will help y'all pin downwardly the source of the trouble and set up it.

Reference isn't valid

Symptoms: Clicking a hyperlink in Excel does non take the user to the link destination, but throws the "Reference isn't valid" error.

Solution: When you create a hyperlink to another sail, the sheet'south name becomes the link target. If you rename the worksheet subsequently, Excel won't be able to locate the target, and the hyperlink will stop working. To fix this, you need to either change the sheet'south proper noun back to the original name, or edit the hyperlink so that it points to the renamed sheet.

If you created a hyperlink to another file, and later moved that file to another location, then you will need to specify the new path to the file.

Hyperlink appears as a regular text cord

Symptoms: Web-addressed (URLs) typed, copied or imported to your worksheet are not converted into clickable hyperlinks automatically, nor are they highlighted with a traditional underlined bluish formatting. Or, links look fine but nothing happens when yous click on them.

Solution: Double-click the cell or press F2 to enter the edit mode, go to the end of the URL and press the Space key. Excel will catechumen a text cord into a clickable hyperlink. If there are many such links, check the format of your cells. Sometimes there are issues with links placed in cells formatted with the General format. In this case, try changing the prison cell format to Text.

Hyperlinks stopped working after reopening a workbook

Symptoms: Your Excel hyperlinks worked but fine until you saved and reopened the workbook. Now, they are all grey and no longer work.

Solution: First off, check if the link destination has not been changed, i.eastward. the target document was neither renamed nor moved. If information technology'due south not the instance, you may consider turning off an option that forces Excel to cheque hyperlinks every fourth dimension the workbook is saved. There accept been reports that Excel sometimes disables valid hyperlinks (for example, links to files stored in your local network may be disabled considering of some temporary issues with your server.) To plow off the choice, follow these steps:

1. In Excel 2010, Excel 2013 and Excel 2016, click File > Options. In Excel 2007, click the Role push > Excel Options.
2. On the left console, select Advanced.
3. Roll down to the General department, and click the Web Options…
4. In the Web Options dialog, switch to the Files tab, articulate the Update links on relieve box, and click OK.

Formula-based hyperlinks do not work

Symptoms: A link created by using the HYPERLINK part does not open or displays an error value in a cell.

Solution: Well-nigh problems with formula-driven hyperlinks are acquired by a not-existent or incorrect path supplied in the link_location argument. The following examples demonstrate how to create a Hyperlink formula properly. For more troubleshooting steps, please see Excel HYPERLINK office not working.

This is how yous create, edit and remove a hyperlink in Excel. I thanks for reading and promise to encounter you on our weblog adjacent week!

Yous may also be interested in

Source: https://www.ablebits.com/office-addins-blog/2017/03/29/hyperlink-excel-create-edit-remove/

Posted by: stubbslieuphe.blogspot.com

Share this post