This is the last part in a series describing how to use the Hyperlink tool in Microsoft Excel (see the bottom of this post for links to the first three parts). In this part, I will be showing you how to create a link to an email address in your spreadsheet.

When would this be useful? A good example where I’ve seen this used is for contact information. If you have a user working on a spreadsheet you created (say an order tracking form), and they have a question or problem, they can click on the email link and a new message window will pop-up (in their default email application) with the To address and Subject pre-populated.

Once again, I’m going to make the assumption that you know how to open the Hyperlink tool dialog (as discussed in Part I of this series). From this dialog, select the E-mail Address option in the Link to: box. The result is shown below:

Read the rest of this entry »