/a/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
Multiple Links in One Google Sheets Cell 0 Recommended Answers 12 Replies 75 Upvotes
1 Recommended Answer
$0 Recommended Answers
1 Relevant Answer
$0 Relevant Answers
Hello,

I received a message as I was typing into one of my Google Sheets (attached). I knew this was not a capability before, but I thought I would give it a try. Unfortunately, I was not successful after multiple attempts. Does anyone know if this works for them, or if Google is still in the process of finalizing this feature? 

Thank you so much!
Relevant Answer Relevant Answers (0)
All Replies (12)
Relevant Answer
You need to double click / select the text you want to link from within the cell and then select the link button from the Google Sheets menu.  You can do that to link only certain portions of text within the cell or have multiple links for multiple portions of text.
marked this as an answer
Relevant Answer
I have the same problem as the above poster. Double-clicking the text and hitting link or CMD-K still reverts it to the HYPERLINK Forumla. Even when I select the text within the formula bar, it just adds the hyperlink formula
marked this as an answer
Relevant Answer
I am also having difficulty, but only with some documents.  For all documents, I tried highlighting specific text ("The Registrar") then hitting Cmd + K (for Mac).

For an older Google Sheets document (created in April 2020), I am able to use the new option:



However, for a newer copy of the same document (created this week), I am unable to use the new option.  Instead, I am given the message "Cannot edit multi-paragraph selection":
marked this as an answer
Relevant Answer
I am still having problems inserting multiple links into a cell. I followed the pop up instructions, but it still only shows 1 link. Can anyone help?
marked this as an answer
Relevant Answer
I think you need to remove the previous hyperlink reference and recreate it. I was able to create multiple links in the same cell after doing that. I had to highlight the text I wanted to link inside of the cell and then use CTRL+K which brought up the linking interface. So far that is the only way I've been able to do this.
marked this as an answer
Relevant Answer
Please someone help.  I am so excited that we now can use multiple links in one cell.  The problem I am running into is that the links do not carry over when using the "=lookup" command.  I've tried "vlookup" and "index-match" and these don't work either.  Can someone help me?  If I can get this to work, it will be a game changer.
marked this as an answer
Relevant Answer
Similar to Shayne's question, I'm also wondering about preserving multiple links when importing to another sheet via "=IMPORTRANGE". It seems to remove the links if there are multiple in one cell. Does anybody know if this can be fixed?
marked this as an answer
Relevant Answer
It works for me. I struggled a bit as I didn't understand it at first because I read the instructions in a rush. I assumed that I'll get a popup with an option to increase the number of fields where I input the link.

Turns out that all I have to do is select the text, select the link, and add the link. Then select another text in the same cell and add a different link. Just like a regular text editor.
marked this as an answer
Relevant Answer
I've encountered issues with the multi-paragraph selections in the past.  Often times I have inadvertently included a line break in my selection.  Unselecting the line break often resolves the error for me.
marked this as an answer
Relevant Answer
p3n1sboi99 has it right.  I have been working in a master list of materials and want to navigate between specific items within one of the groupings, in this case, Jacks, Faceplates & Surface Mount Boxes. Instead of having to scroll down to get to the Faceplates & Surface Mount Boxes, I am now able to keep the heading in one cell, and link to all three separately

Here are the specific steps I took: 
1) Deleted the current links assigned to the heading "Jacks, Faceplates & Surface Mount Boxes".
2) Went back to the cell, now only containing text, and double clicked to select just the first listing, "Jacks"
3) CTRL + K to pull up the link options, THEN click on "Select a range of cells to link"
4) Navigate to and click on the cell OR select the desired range of cells, then click "ok", THEN click "apply".

Repeat...
5) Back to the cell, double clicked and selected only the second listing, "Faceplates"
6) CTRL + K to pull up the link options, THEN click on "Select a range of cells to link"
7) Navigate to and click on the cell OR select the desired range of cells, then click "ok", THEN click "apply".

Repeat again...
8) Back to the cell a final time, double clicked and selected only the last listing, "Surface Mount Boxes"
9) CTRL + K to pull up the link options, THEN click on "Select a range of cells to link"
10) Navigate to and click on the cell OR select the desired range of cells, then click "ok", THEN click "apply".

A few things I noticed that may be at the root of difficulties some are having:
  • If two of the words you are trying to assign links to are directly adjacent to one another, when you click to add the second link, it sometimes will pull up the first link - I found this happening myself a few times as I was testing.  I had to delete the pre-populated link, then continue on...("Select a range of cells to link", navigate to and click on, etc.)
  • The sequence of clicks is very deliberate and specific - if I accidentally hit "enter" instead of clicking, or tried to use the 'Insert' menu (instead of Ctrl+K), it would fail and I'd have to start the series of clicks and strokes all over again.  It requires a lot more "clicking" than I realized...even in writing out these steps, I inadvertently omitted one of the necessary clicks on my first pass at describing.
I hope this helps someone!  Thanks!!!
marked this as an answer
Relevant Answer
Is there a way to open both hyperlink that are in that single cell with just one click?
marked this as an answer
Relevant Answer
When I export my Google sheet to a PDF, I loose ALL my links (exporting to Excel preserves the first link only). I love the multiple-link function, but I need them to show up in the exported PDF. Is there any way to make this happen? Thanks!
marked this as an answer
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
Report post
What type of post are you reporting?
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/a/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Marked as Recommended Answer
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
/a/profile/0