Create Hyperlink in Excel
The use of hyperlinks in Excel can transform a spreadsheet into an entire filing system.
For example, if you have a spreadsheet that keeps track of your expenditure, imagine how much more organised this would be if, a scanned-in image of every invoice or receipt that you received, could be opened up by a simple click of a hyperlink (see below).
How to Create a Hyperlink in Excel
The following steps describe how to create a hyperlink in Excel:
- Select the cell that you want to add the hyperlink to;
- Use the keyboard shortcut CTRL-K.
Any of these three options will open up the Insert Hyperlink dialog box, shown below:
Type the text that you want to display in the Excel worksheet into the top Text to display: field and then use the options in the dialog box to define your link address.
The available types of hyperlink are listed on the left hand side of the 'Insert Hyperlink' window. These are described, individually, below:
Hyperlink to an Existing File or Web Page
The default option in the 'Insert Hyperlink' dialog box is to create a hyperlink to an Existing File or Web Page.
You can either navigate to the file or web page or you can type the address of the file or web page directly into the Address: field of the dialog box.
Hyperlink to a Specified Place Within a File
If the file you link to is an Excel file, you can set the hyperlink to go to a specified place within the file that you link to.
To do this, first select the file that you want to link to and then:
Click on the Bookmark... button (which is located on the right hand side of the 'Insert Hyperlink' dialog box).This causes the 'Select Place in Document' dialog box to appear (see rightabove).
The 'Select Place in Document' dialog box gives you the option to select a specific place within a document.For example, the above dialog box on the right will link to cell B2 on Sheet2 of the selected Excel workbook.
- Once you have specified the location that you want to link to, click OK to close the 'Select Place in Document' dialog box and then click OK within the 'Insert Hyperlink' dialog box.
Hyperlink to a Place in This Document
The second option on the left of the 'Insert Hyperlink' window is to Hyperlink to a Place in This Document.
If you select this option, you will be presented with options that allow you to select a worksheet and specify a cell reference within the current Excel workbook.
In the example shown above (right), the hyperlink will take the user to cell C3 on Sheet3 of the current Excel workbook.
Hyperlink to a New Document
The third option on the left of the 'Insert Hyperlink' window is to create a hyperlink to a New Document. If you select this option, you will be presented with a window that asks you to specify the name and location of the new document. If you enter these details, and click OK, a new Excel document will be created and hyperlinked to.
Hyperlink to an E-Mail Address
The final option on the left of the 'Insert Hyperlink' window is to create a hyperlink to an e-mail address. Selecting this option allows you to specify an e-mail address to link to, either by typing the address directly into the window, or selecting from recently used e-mail addresses.
Further information on creating, editing and deleting hyperlinks in Excel is provided on the Microsoft Office Website.
See how to Remove Hyperlinks in Excel >>