Hyperlinks In Excel 2010

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.

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.

select file 1

You will see a hyperlink is created in the cell, upon click it will open the desired file.

external

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.

within 1

You will notice on clicking link it will open the specified sheet and automatically highlights the specified cell location.

chart

sheet 3

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.

check

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;

=HYPERLINK(link_location, [friendly_name])

We will be filling arguments like this;

=HYPERLINK(“C:UsersUsmanDesktopEQ.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.

doc

You can also check out previously reviewed guides on Research Feature In Word 2010 & Translation in Word 2010.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *