Insert Multiple Hyperlinks within a Cell in Google Sheets

We can now hyperlink a substring or part of the text in a cell in Google Sheets. That means insert multiple hyperlinks within a cell in Google Sheets is now possible — a feature many users had been waiting for!

Earlier, when hyperlinking a (whole) text in a cell by clicking Insert > Link, Google Sheets would insert a HYPERLINK formula into the cell.

As you may know, formulas in Google Sheets start with an equal sign (=), and a cell can only contain one functioning formula. So there was no way to insert two separate, working formulas (and thus multiple hyperlinks) within a single cell.

In the past, this limitation meant that it wasn’t possible to insert multiple hyperlinks within a cell in Google Sheets. But now, things have changed slightly. Let me clarify.

Say you insert a hyperlink in cell E1 by using the Insert > Link menu. The label (the visible blue text) is “Google,” and the URL is http://www.google.com/.

Insert link option in Google Sheets under the Insert menu
screenshot # 1

Now try entering the following formula in cell E2:

=FORMULATEXT(E1)

Earlier, this would return the formula used to create the hyperlink:

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

You could also view this in the formula bar by selecting E1.

But now, if you insert a hyperlink using the same Insert > Link method, the link will still work — yet FORMULATEXT will return #N/A (invalid formula parse result). That’s because there’s no formula anymore, just a rich-text hyperlink directly embedded in the cell!

Today, there are two methods to insert hyperlinks in Google Sheets:

  1. Using the HYPERLINK function
  2. Using Insert > Link from the menu

These options existed earlier as well, but the result was the same — you could only insert one hyperlink per cell using either method.

Why? Because both methods used the HYPERLINK formula behind the scenes.

Formula Approach

To create a hyperlink using a formula, follow this syntax:

HYPERLINK(URL, [link_label])

Example:

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

I’m not going into more detail here — the example is self-explanatory.

Insert Menu Approach (Legacy)

This approach is best for inserting a single hyperlink — but hang tight, I’ll show you how to insert multiple hyperlinks within a cell in Google Sheets shortly.

When you type a domain name in a cell (like infoinspired.com in cell B2), Sheets may automatically hyperlink it.

Automatically hyperlinked domain name displaying as blue text in a Google Sheets cell
screenshot # 2

If you want to link regular text (e.g., “infoinspired”), select the text, click Insert > Link, and enter the desired URL in the popup field (refer to screenshot #1).

Now for the exciting part — here’s how to insert multiple hyperlinks within a cell in Google Sheets using the latest rich-text editing feature.

Let’s say cell B1 contains the comma-separated text: Google Maps, Google Play

Here’s how I’m adding two different hyperlinks to these words in the same cell.

  1. Double-click cell B1 or press F2 to edit.
  2. Highlight “Google Maps” and press Ctrl + K (Windows) or ⌘ + K (Mac).
    Alternatively, use the Insert link icon from the toolbar.
  3. Type the link in the field and click Apply.
  4. Next, select “Google Play” and repeat the steps above.
Steps to add multiple hyperlinks to different text parts within a single Google Sheets cell
screenshot # 3

That’s it!

Wondering how to jump to those two web addresses?

There are two easy ways:

View all hyperlinks in a single Google Sheets cell by hovering or double-clicking the cell
screenshot # 4
  1. Hover over cell B1 – a popup will show both hyperlinks.
  2. Double-click cell B1 – click either linked text to open the corresponding URL.

That’s all about how to insert multiple hyperlinks within a cell in Google Sheets. Thanks for reading — enjoy using this new feature in your Sheets workflow!

Resources

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Expert Prashanth KV is a Diamond Product Expert in Google Sheets, officially recognized by Google for his contributions to the Docs Editors Help Community and featured in the Google Product Experts Directory. Explore his blog to learn advanced formulas, automation tips, and problem-solving techniques to elevate your spreadsheet skills.

Calculate Trip Days by Month (Start, End, and Full Days) in Google Sheets

If you're managing business travel in Google Sheets, you may need to calculate how...

Mode of Comma-Separated Numbers in Excel (Dynamic Array)

There is no dedicated function in Excel to directly find the mode of comma-separated...

How to Find Mode of Comma-Separated Numbers in Google Sheets

Working with comma-separated numbers inside a single cell is a common scenario in Google...

How to Count Merged Cells in Google Sheets (and Get Their Size)

Sometimes, you may have blocks of merged cells in a column or row. But...

More like this

Calculate Trip Days by Month (Start, End, and Full Days) in Google Sheets

If you're managing business travel in Google Sheets, you may need to calculate how...

How to Find Mode of Comma-Separated Numbers in Google Sheets

Working with comma-separated numbers inside a single cell is a common scenario in Google...

How to Count Merged Cells in Google Sheets (and Get Their Size)

Sometimes, you may have blocks of merged cells in a column or row. But...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.