How to insert multiple hyperlinks in a cell in Excel?

As we all known, in Excel there is only one hyperlink can be inserted into a cell by default. But sometimes, we need to insert two or more hyperlinks into a cell. How to insert multiple hyperlinks in a cell in Excel? You can get it done as follows:

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

1. Click Insert in the ribbon, and then click Shape, then you can select a rectangle shape.

2. Drawing a rectangle in the text that you want to insert hyperlink. And the rectangle will shade the text. See screenshot:

doc-insert-multiple-hyperlinks1

3. Then click the rectangle and right-click, and choose the Format Shape from the menu, and then a Format Shape dialog box will pop out. Click Fill in the left pane, and check No fill in the right pane. See screenshot:

doc-insert-multiple-hyperlinks2

4. Go on clicking Line Color in the left pane, and check No line in the right pane.

doc-insert-multiple-hyperlinks3

5. Then click Close button. And the rectangle has been changed transparently. See screenshot:

doc-insert-multiple-hyperlinks4

6. Put the cursor at the transparent rectangle, and right-click, choose Hyperlink from the menu, and then you can specify the file or enter the address to be hyperlinked.

With this method, repeat the above steps, you can insert the second or multiple hyperlinks into an Excel cell.

Related Aticals:

Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Comments  

0#vinesh2014-02-04 18:57
thanks a lot. Helpful
Reply | Reply with quote | Quote
0#underwoodm2014-03-10 17:59
With Excel 2010, for step 6, I had to select the shape then choose Hyperlink from the Insert menu at the top. (Using the right-click method attached the hyperlink to the entire cell.)
Reply | Reply with quote | Quote
0#qaiser2014-04-06 08:08
I wish to know if it is possible to copy & paste a list of pdf files as hyperlinks in excel? If yes, How???
Reply | Reply with quote | Quote
0#Mosaddique2014-07-24 10:38
Is there a way of automatically updating multiple links in a cell if rows above it have be added/deleted?

I have a problem whereby adding an extra row causes the link to now point a cell one row out

I am using insert shapes and linking that way as described in this article in order to support multiple links in the cell
Reply | Reply with quote | Quote
0#mbarnewall2014-08-20 17:15
That is a fantastic idea! Way less hassle than making small pictures of each letter/word and inserting them into the cell... derp.
Reply | Reply with quote | Quote

Add comment


Security code
Refresh