Hyperlinks In Excel

In Excel, we have the opportunity to create hyperlinks that lead us to other cells or spreadsheets. We can also create links to other Office files, even to create links that lead us to the Web or to an E-mail address. Links as these can be placed on text, on buttons or images. The most important thing with the links is that with just one click of the button we have reached our destination.

Hyperlinks

To add Hyperlinks to a spreadsheet we must define two things:

  • The object that we want to add the connection and then by clicking on it to activate the link.
  • The destination where the link would lead from the moment that we activate it.

The destinations that the hyperlink would lead in a workbook, can be a cell reference, a cell area or a different spreadsheet.

The destinations that the hyperlink would lead outside of a workbook, can be an existing file (any sort) that we want it to open when the link is activated. An url address from a webpage that we want to visit by clicking the link. An e-mail address for a new message that will be created and last a link that will create a new file (Excel, Word, PowerPoint etc.).

Hyperlinks: Place in this Document

To add a hyperlink in the text of a cell or on a graphic we must follow the next steps:

We select the cell or graphic that we want to add the hyperlink. Then we choose the Insert Tab and from the area of the ribbon named Links we select the command Hyperlink as we can see in the image below.

01

Once selected the Insert Hyperlink window appears as shown below.

02

In the area below of the Link To: we select Place In This Document. Then in the area Type The Cell Reference we select the cell destination that we want the link to lead us to.

In the area of the window where it is named Or Select A Place In This Document, the other spreadsheets of the workbook appear as long with the defined names, which can also be chosen.

By selecting the Screen Tip button the Set Hyperlink Screen Tip window appears, where we can type in a description of our hyperlink, so every time we move with our mouse on top of the hyperlink the Screen Tip will appear.

03

Once we have typed in the Screen tip text we press the OK button, and once we have defined our destination for our hyperlink we press the OK button. When we return to our spreadsheet we will see that the text of our cell is blue with an underline. Once we move there with our mouse our arrow pointer changes shape into a hand, indicating that there is a link there and the screen tip text appears.

05 (2)

Once we have moved on top of our hyperlink, one left click with our mouse will activate the hyperlink and we will reach our destination.

Hyperlinks: Existing File Or Web Page

To add a hyperlink to an Existing File or Web Page we must follow the next steps:

We select the cell or graphic that we want to add the hyperlink. Then we choose the Insert Tab and from the area of the ribbon named Links we select the command Hyperlink as we can see in the image below.

Once selected the Insert Hyperlink window appears as shown below.

04

In the area below of the Link To: we select Existing File Or Web Page. For an existing file we select the arrow at the right of the command Look In:, in order to navigate to another place of our computer as shown in the image above. We just choose the file, no matter its location and then press the OK button.

For a webpage, at the bottom of the Insert Hyperlink window and in the area Address, we type in the URL address that we want our link to lead to and press the OK button.

Here also we can use the Screen Tip if we want to. To activate the hyperlink we follow the same steps as described above. The difference is that when we added the hyperlink to an existing file that file will open once activated, and if we added the hyperlink to an Url address, once the link is activated we will visit the webpage automatically.


Hyperlink: Create New Document

To add a hyperlink in order for a new document to be created we must follow the next steps:

We select the cell or graphic that we want to add the hyperlink. Then we choose the Insert Tab and from the area of the ribbon named Links we select the command Hyperlink as we can see in the image below.

Once selected the Insert Hyperlink window appears as shown below.

05

In the area below of the Link To: we select Create New Document. In the text area Name Of New Document, we type in the name of our new document. If we press the Change button we can define a different location for our new document. In the When To Edit location, we can either select Edit The New Document Later or Edit The New Document Now, where we define when we want to edit the document by selecting the appropriate check box. Once we have defined everything we select the OK button in order to return to our spreadsheet. When the hyperlink is activated a New Excel Workbook is created, or depending on the extension that we have typed the new file will be created. For example if we had typed *.docx a new Word document will be created.


Hyperlink: E-mail Address

To add a hyperlink in order for an E-mail message to be created we must follow the next steps:

We select the cell or graphic that we want to add the hyperlink. Then we choose the Insert Tab and from the area of the ribbon named Links we select the command Hyperlink as we can see in the image below.

Once selected the Insert Hyperlink window appears as shown below.

06

In the area below of the Link To: we select E-mail Address. In the text area named E-Mail Address we type in the recipients email address. In the area below the Subject text box we type in the text we want to appear as the subject of our message. Once finished we press the OK button and when the hyperlink is activated a new E-mail message is created and in the area of To: of the message the recipients email address is there as long with the Subject text.

07

Hyperlinks: Edit

To edit a hyperlink just in case we have done something wrong, or we want to change it the easiest way is to navigate with our mouse on top of the link and to do a right click with our mouse, and from the shortcut menu that appears we select the command Edit Hyperlink as shown below.

08

The Edit Hyperlink window appears where we can do the adjustments that we want to.

09

Hyperlink: Remove

If we want to remove a hyperlink, the easiest way is to navigate with our mouse on top of the link and to do a right click with our mouse, and from the shortcut menu that appears to select the command Remove Hyperlink as shown below.

10

The hyperlink has been removed from our cell.

Another way to remove our hyperlink is to select the Edit Hyperlink command and from the window that appears and from the bottom right area of the window to select the command Remove Link as we can see in the image below.

11

HYPERLINK Function

Instead of using the Hyperlink command that is located at the Insert Tab of the ribbon, we can use the Hyperlink function. The Hyperlink function is located at the Functions Tab, and in the area of the ribbon named Function Library we select the Lookup & Reference category in order to find ti. We cannot use this function on an object.

The Hyperlink function uses the following arguments:

HYPERLINK(link_location,[friendly_name])

12

In the Link_location area we define the path and file name to the document to be opened on our hard drive, to a network server or to the Internet. In the area Friendly_name we type in the text that we want to appear.

An Hyperlink function example that we could use is the following:

=HYPERLINK(“http://www.systemplus.gr”,”Επίσημο Κέντρο Τεχνικής Εκπαίδευσης”)

15

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on November 13, 2011, in Excel 2010 English, Microsoft Office 2010 English and tagged , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Hyperlinks In Excel.

Comments are closed.