Skip to main content

How to insert multiple hyperlinks in a single cell in Excel?

In Excel, while the default setting allows only one hyperlink per cell, there are occasions when inserting multiple hyperlinks into a single cell becomes necessary. To achieve this, and also to efficiently insert multiple hyperlinks across several cells, this article will guide you through the process step by step.


Insert multiple hyperlinks into a single cell

  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:
  3. Then click the rectangle, under the Shape Format tab, click Shape Fill drop down and choose No Fill. See screenshot:
  4. Go on clicking Shape Outline drop down, and select No Outline.And the rectangle has been changed transparently. See screenshot:
  5. Put the cursor at the transparent rectangle, and right-click, choose Link from the menu.
  6. In the popped out Insert Hyperlink dialog box,  you can specify the file or enter the address to be hyperlinked. Then, click OK. See screenshot:
  7. Hyperlink has been inserted into this specific shape.
  8. Then, please repeat the above steps to insert the second or multiple hyperlinks into a cell.

Enhance Excel Productivity with Kutools: Batch Insert Images Directly from URLs

To convert image URLs from the web into actual images in Excel, you can utilize the handy feature of Kutools for Excel named "Insert Pictures from Path(URL)". This function enables users to swiftly transform image links from the internet into real images within Excel cells, significantly saving time on downloading and inserting images, and making reports more visually appealing and vivid. Download and install Kutools for Excel now!


Related Articles:

  • Change multiple hyperlink paths at once
  • For some purpose, you may create multiple hyperlinks for your data in the worksheet, and all of the hyperlinks are linked to the same file path or address, but now, you need to replace this hyperlink path with another address at a time. To change the path of the hyperlinks individually may waste a lot of time, is there a quick way to solve this problem?
  • Open multiple hyperlinks at once
  • If you have many hyperlinks in a spreadsheet, normally you would have to open them one by one, which can be tedious. Fortunately, there are some simple ways to open all the selected hyperlinks at once. By following the methods described below, you can easily accomplish this task.
  • Follow hyperlink to hidden sheet
  • For example, I have a workbook which contains multiple worksheets, the first master sheet has hyperlinks to other sheets, and now, I hide all sheets except the first one. In this case, the hyperlinks which link to hidden sheets are not available. But, how could you make these hyperlinks work successfully? When you click one hyperlink, the linked hidden sheet will be opened at once as following screenshot shown:

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Description


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (19)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Muito mal redigido, manda fazer coisas que não correspondem com os botões do programa Excel. Péssimo
This comment was minimized by the moderator on the site
How can i hyperlink two cells in different sheets (names defined) in Name Manager by easiest way?
This comment was minimized by the moderator on the site
Hi, I wanna link 4 different regions data to same cell. for example I have one cell named as training and when I check the A region training results I want to click on training cell and see all details per employee. and do same for all other regions. Which it means need to link one training cell todifferent regions data per employee in different sheets , how can I do it?Thanks
This comment was minimized by the moderator on the site
How do you keep the shape from moving when resizing the workseet?
This comment was minimized by the moderator on the site
Hi Kriste,
You can right click the shape and select Format Shape to open the Format Shape pane. In the Format Shape pane, enable the Size & Properties tab, go to the Properties section, and check the Move and Size with cells option.
FYI, the Move and Size with cells option is checked by default.
This comment was minimized by the moderator on the site
is there any option available in excel for insertion/ replacement of cell reference in multiple links at once????
This comment was minimized by the moderator on the site
Hi Zaibi,
What kinds of content do you want to insert or replace in bulk? Hyperlinks?
Kutools for Excel released a feature of Super Find, which can search and select specific text values only in hyperlinks in Excel.
https://www.extendoffice.com/product/kutools-for-excel/excel-find-text-in-hyperlinks.html
This comment was minimized by the moderator on the site
inserting multiple links is not working with shapes.. Please don't give wrong information.
This comment was minimized by the moderator on the site
It works perfectly! I just did it multiple times.
This comment was minimized by the moderator on the site
It works Deepthi. I tried it just now
This comment was minimized by the moderator on the site
Thank you. It's so helpful.
This comment was minimized by the moderator on the site
Thank you. Your instructions are clear.
This comment was minimized by the moderator on the site
That is a fantastic idea! Way less hassle than making small pictures of each letter/word and inserting them into the cell... derp.
This comment was minimized by the moderator on the site
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
This comment was minimized by the moderator on the site
You need to define a name for the range you are wanting to hyperlink to. Once you do this it does not matter how many row are inserted before or after, it will hyperlink to that range.
This comment was minimized by the moderator on the site
Great, that is a very useful tip. thank you. I shall try that.
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations