How to Add Two Email Hyperlinks to One Cell in Excel
Microsoft Excel handles hyperlinks a bit differently than other Microsoft Office applications, such as Microsoft Word and PowerPoint. You cannot highlight a piece of text, such as a business contact name, and turn it into an email hyperlink. What you can do is turn an entire cell or object into a hyperlink. While you may put each email hyperlink in its own cell, this approach can affect the layout of adjacent columns and rows in your business spreadsheet. Fortunately, Microsoft Excel allows you to place multiple invisible objects in a single cell, each with their own email hyperlinks.
Load Microsoft Excel and click “Blank workbook” if you wish to create a blank workbook. Otherwise, click “Open Other Workbooks” on the bottom left corner and double-click the spreadsheet file you wish to edit.
Click on the cell you wish to place two email hyperlinks and type in any text you like.
Double-click the cell you just populated and highlight the text you wish to use as your first email hyperlink. Click the “Home” tab on the Microsoft Excel toolbar and apply any formatting styles you like to distinguish the hyperlink from the rest of the text within the cell. For instance, you may underline the text by clicking the underlined “U” button and set the font color to another color by clicking the small arrow button next to the “A” button with a colored line underneath. Repeat this step with the other piece of text you want to set as your second hyperlink.
Click the “Insert” tab on the Microsoft Excel toolbar and click “Shapes.” Click the first icon on the “Rectangles” category and draw a box around the piece of text you want as your first hyperlink. Right-click the box and click “Hyperlink.” In the “Address” text box within the Insert Hyperlink dialog, type “mailto:” (without quotation marks) followed by the email address you want to link the first hyperlink to. Repeat this step to make another box for the other hyperlink.
Hold the “Ctrl” key on your keyboard and click the first rectangle you made. Click “Format” on the toolbar to see the shape properties. Click “Shape Fill” on the toolbar and click “No Fill.” Click “Shape Outline” on the toolbar and click “No Outline.” Apply the same changes to the second box.