Multiple links in one cell google sheets

I find that Google Sheets can be an incredible tool for organizing projects — the endless rows and columns let me track and categorize things to my heart’s content. (You should see my byzantine spreadsheet for my family’s personal finances.)

Until recently, though, I’ve run into one major limitation that irked my organizational brain. If I wanted to add hyperlinks to a cell, I could only hyperlink an entire cell instead of hyperlinking individual words inside it. That meant, for example, if I wanted to track interesting links about personal finance in my spreadsheet, I’d have to make individual cells for each one of those hyperlinks, which could quickly fill up way more cells than I’d like.

But earlier this summer, while researching a big story, I must have subconsciously noticed something had changed. I could, at long last, hyperlink as many things as I wanted in one single cell, allowing me to pack even more organization into my handcrafted spreadsheets. The feature was so good — and felt so natural — that I immediately switched to using it as if it had always been there, and didn’t think much more about it.

But today, another Verge staffer excitedly noticed the change, too, sharing it in The Verge’s Slack as a PSA. And then my editor realized that he, like me, has started using it without even thinking about it. It’s just that handy.

Admittedly, my colleagues and I might be a little late to the hyperlinking party. I found a Google support thread discussing the new functionality from May 7th and a YouTube tutorial posted the same day. But perhaps the feature reached my colleagues and I a bit later than May, as Google sometimes rolls out features over time.

We figured we’d share our shared discovery of the feature along to you, dear Verge reader, so you can begin hyperlinking all the things.

Join the conversation

Most Popular

1. Fortnite’s latest live event was its strangest yet

---

2. Elon Musk’s promised Twitter exposé on the Hunter Biden story is a flop that doxxed multiple people

---

3. Lessons learned after living in an off-grid rental

---

4. Disney’s latest AI tool de-ages actors in seconds

---

5. You deserve more than $2 for running your phone’s data through Amazon

---

Verge Deals

/ Sign up for Verge Deals to get deals on products we've tested sent to your inbox daily.

Email (required)Sign up

By submitting your email, you agree to our Terms and Privacy Notice. This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Today someone asked me if they could hyperlink parts of the text within a cell in Google Sheets and I responded with no. Literally minutes later I was editing a spreadsheet cell that happened to have a hyperlink in the cell and all of a sudden the link became live. I think my eyes literally bugged out of my head (okay that is the opposite of the definition of literally, it was figuratively). THIS IS VERY EXCITING! (Remember, new features always roll out meaning they may not be available to you for up to 2 weeks).

Hyperlink Text Within the Cell

While typing in a cell in Google Sheets if you type a web address, even without the http:// and press space after the last character it will hyperlink. However, not ALL the text, just the web address.

You can also highlight portions of text within the cell and use Control K to hyperlink just the selection within the cell.

Now we can select substring or part of a text in a cell in Google Sheets to hyperlink. That means inserting multiple hyperlinks within a cell is now possible in Google Sheets.

Earlier when we were hyperlinking a (whole) text in a cell by clicking Insert > Insert link, actually Google Sheets was inserting a HYPERLINK formula within that cell.

As you may know, the formulas will be normally starting with an = (equal) sign and so there is no chance to insert two working formulas within a cell.

In the past, that closed the chance of inserting multiple hyperlinks within a cell in Google Sheets. Now things are slightly changed! Let me clarify it.

For example, there is a hyperlinked text in cell E1 that inserted by clicking the above-said menu option. The label (the visible blue text) is “Google” and the URL is “http://www.google.com/”.

When using the =FORMULATEXT(E1) in cell E2, you would get the below HYPERLINK formula.

=HYPERLINK("http://www.google.com/", "Google")

The same formula you can see on the formula bar by clicking cell E2.

Now things are different. If you follow the above same menu (Insert > Insert link) you would get the hyperlinked text as above.

But the FORMULATEXT would return #N/A (invalid formula parse result). That means there is no formula in cell E1 but the link is there!

Two Methods to Insert Hyperlinks within a Cell and Their Difference in Google Sheets

Now there are two methods to insert HYPERLINKS in Google Sheets. One using the HYPERLINK function and the other using the Insert menu > Insert link.

Earlier also these two options were available. But the result was the same.

I mean both the options were not capable of inserting multiple hyperlinks in a cell in Google Sheets. The reason both were inserting the HYPERLINK formula.

Formula Approach

Create hyperlinks by following the below syntax.

HYPERLINK(URL, [link_label])

Example: Type the below formula in any cell.

=HYPERLINK("https://google.com","google")

I’m not going to the details as the example above is self-explanatory.

Insert Menu Approach

This is only suitable for inserting a single hyperlink. Yes! I’ll come back to how to insert multiple hyperlinks in a cell after this.

When you type a domain name in cell E1 or any other cells, for example, “infoinspired.com” in cell B2, in most of the cases, it would automatically be hyperlinked to the corresponding website URL.

If you just want to link to a text, not a domain name, for example, “infoinspired”, then click Insert > Insert link and enter the link in the given field (please refer to screenshot # 1 above).

Multiple Hyperlinks within a Cell in Google Sheets – Insert Menu Approach

Finally, we are here! Here are the steps to insert multiple hyperlinks within a cell in Google Sheets. This is a new feature in Google Sheets.

In cell B1 I have the comma-separated text “Google Maps, Google Play”. See how I am hyperlinking two different URLs to these words in cell B1.

First, double click on cell B1 or hit F2 on your keyboard and select “Google Maps”. Then hit Ctrl + k (Windows) or ⌘ + k (Mac).

Alternatively, after selecting the text, you can click the insert link icon. I am following this, not the shortcut, in my example below.

Then type the link in the “Link” field then click “Apply”.

Select the second text, i.e. Google Play, and follow the above steps and voila!

How to jump to the above two linked web addresses in Sheets then?

It’s quite easy. Follow either of the methods.

• To see all the links in cell B1, hover your mouse pointer over cell B1. It’ll show (pop up) the above two added URLs (see the image below).
• Double click on cell B1 and click on either of the text to see the corresponding URL.

That’s all about how to insert multiple hyperlinks within a cell in Google Sheets. Thanks for the stay. Enjoy!

Can you add multiple links in a Google Sheet?

How do you insert multiple hyperlinks in Google Docs?