Create a hyperlink from a string in Microsoft Excel 2010

In this article we will learn how to create a hyperlink from a string, we need to use the Hyperlink function in Microsoft Excel 2010. We will learn non-vba solution in this article.

HYPERLINK: -This function is used to create a shortcut or jump that opens a document stored on your hard drive, network server or on the internet.  It can also be used to link one sheet to one or more other sheets in the same workbook or in another workbook.

There are 2 ways to create the hyperlink.

1^st Hyperlink Formula

2^nd Shortcut Command of Hyperlink

Hyperlink Formula

Syntax of Hyperlink:- =Hyperlink(link_location,[friendly_name])

For Example:- Cell A1 contains c:\ExcelTip\tips.xls.

To create the hyperlink for this, follow the below given steps:-

• Select the cell A2.
• Write the formula to create the hyperlink.
• =HYPERLINK(A1), press Enter on the keyboard.
• The function will create the hyperlink.
• When you will click on the link,the file will be opened.

Shortcut Command:-

Lets create a link for a Web page.

• Select the cell where you are going to create the hyperlink, in this example cell A1.
• Right click with the mouse.

• Select Hyperlink from the shortcut menu.
• The Insert hyperlink dialog box will appear.

• To create the hyperlink for Web page, click on Existing file or Web Page.
• 3 vertical tabs will appear- Current Folder, Browsed Pages and Recent Files.
• If you want to create the link for a file in the current folder, click on Current Folder tab, for Web Pages click on Browsed pages and for Recent files click on Recent File’s tab.

• We will click on Browsed Pages to create the link for the Web page.

• And select the required web page.
• Click on OK.

The webpage link will appear in the selected cell. So in this way we can create the hyperlinks in Microsoft Excel.