While working on Excel spreadsheet, sometime there is a dire need to create links in cells to files, folders, web pages, images, sheets within workbook, etc to complement spreadsheet in a better way. Excel 2010 provides a convenient way for linking up cells data with whatever you want. By following a simple procedure you will be able to link up important datasheet with other content.
Launch Excel 2010 spreadsheet in which you want to add links. For instance, we have included a spreadsheet containing; Name, Marks, and Links field, as shown in the screenshot below.
Now we will be creating hyperlinks in the sheet. Select the cell in which you want to create hyperlink and right-click to select Hyperlink.
Link To Existing File or Web Page
You will reach Insert Hyperlink dialog, from the left sidebar select Existing File or Web Page, from right sidebar select the file for which to want to create hyperlink, from Text to display enter text you want to display instead of file path. Click OK to continue.
You will see a hyperlink is created in the cell, upon click it will open the desired file.
Link Sheet Within Workbook
Now if you want to link any sheet within same workbook, then open Insert Hyperlink dialog and from the left sidebar select Place in This Document, from right side select the sheet for which to want to create hyperlink, from Text to display enter text you want to display and under Type the cell reference enter the cell location you want to refer. Click OK to continue.
You will notice on clicking link it will open the specified sheet and automatically highlights the specified cell location.
Link To Email Address
It also allows you to insert an immediate link for sending mail. Open Insert Hyperlink dialog, from left sidebar select E-mail Address, from right side enter text to display, email address and subject of email. Click OK to continue.
Upon click, it will open up Outlook compose mail window.
Using Hyperlink Function
There is another way but it would be bit complicated for novices, you can also add hyperlink in to spreadsheet through HYPERLINK function.
The basic syntax of this function is;
We will be filling arguments like this;
=HYPERLINK(“C:\Users\Usman\Desktop\EQ.docx”, “Word Documet”)
The link_location and friendly_name argument both must be enclosed in double quotation marks. It will create link to a file specified, as shown in the screenshot below.
You can also check out previously reviewed guides on Research Feature In Word 2010 & Translation in Word 2010.