We can either use a Hyperlink formula or the Insert menu Link command to link to an email address in Google Sheets.

That means to insert an email address that is clickable (clickable email IDs), we can follow two methods – formula-based and menu command-based.

I prefer the menu command if I want to Hyperlink to a single email address in Google Sheets.

I may prefer a formula to hyperlink to more than one cell because it has the edge over the menu command.

The formula supports hyperlinking multiple email addresses at a time, but the link command doesn’t.

In both cases, I mean using the HYPERLINK function or the Insert > Link command, we can either use the label or email address itself as a label for hyperlinking.

For more details, please find the examples below.

Using Insert Menu Link Command

It is the simplest method to make an email address clickable.

To begin with, enter your email address or name in cell A1.

Go to the menu Insert and click on Link.

In the given field, which is blank, key in your email ID, and you may click on “Apply.”

To quickly access the Link command use the shortcut Ctrl+k in Windows or ⌘ + k in Mac.

Please note that the active cell should be the cell containing the label to link.

You May Like: Inserting Multiple Hyperlinks within a Cell in Google Sheets.

Using Hyperlink Formula

To hyperlink to an email address using a formula in Google Sheets, follow the below syntax.

=HYPERLINK("mailto:prashanth@temp.com","PRASHANTH")

Insert the above formula in cell A1.

Replace prashanth@temp.com with the email address that you want to hyperlink.

The name “PRASHANTH” in the above formula is the label.

That means the visible text on cell A1 will be PRASHANTH. Change that too.

The following formula will insert the email address prashanth@temp.com in cell A1, and it will hyperlink to the same email address.

That means the label, as well as the email address, is the same.

=HYPERLINK("mailto:prashanth@temp.com","prashanth@temp.com")

What about Linking an Email Address in Cell B1 with the Name in Cell A1?

It is a different scenario, and we want to see it in a spreadsheet cell in real life.

Example:

In C1, we can use the below formula.

=HYPERLINK("mailto:"&B1,A1)

Prefixing "mailto:" is the key to making a clickable email address in Google Sheets.

Can We Hyperlink to Multiple Email Addresses in Google Sheets?

Fortunately, the HYPERLINK function works with an ArrayFormula. So my answer is YES!

Example:

Column A has names, and column B has email addresses.

In column C, we can make a list of clickable email addresses with a Hyperlink array formula. It’s as follows.

=ArrayFormula(HYPERLINK("mailto:"&B1:B4,A1:A4))

To include future rows, include the IF logical part at the beginning as below.

=ArrayFormula(if(A1:A="",,HYPERLINK("mailto:"&B1:B,A1:A)))

More Hyperlink Related Posts

1. How to Label URL in Google Sheets Using HYPERLINK Function.
2. Search Value and Hyperlink Cell Found in Google Sheets.
3. Create Hyperlink to Vlookup Output Cell in Google Sheets.
4. UNIQUE Duplicate Hyperlinks in Google Sheets – Same Labels Different URLs.
5. Hyperlink Max and Min Values in Column or Row in Google Sheets.
6. Hyperlink to Index-Match Output in Google Sheets.
7. Jump to the Last Cell with Data in a Column in Google Sheets (Hyperlink).
8. Hyperlink to Jump to Current Date Cell in Google Sheets.