How to Add a Mailto Hyperlink

The hyperlink can quickly direct us to the information. Please follow the steps below to add a mailto hyperlink:

Step 1: Select the cell or data range you want to add a hyperlink;

Step 2: Right click and select "Link" at the bottom from the list (or use shortcut "Ctrl+K") to bring up "Insert Hyperlink" window.

Alternatively, click "Link" in the "Insert" tab.

Step 3: In the "Insert Hyperlink" window:

1. Click "E-mail Address";

2. Type an email address;

3. Type a subject in the box.

Step 4: Click OK at the bottom.

Leave a Reply