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.