How do you make an email address in an Excel spreadsheet clickable?
To make an email address clickable in a spreadsheet check the format of the cell is not set to text, if not when entering an email address Excel should automatically detect that it is an email address and add the
mailto: hyperlink automatically.
If after checking the cell is not set to
Text and even after entering a valid email address Excel isn’t converting the entry to a hyperlinked
mailto: address you can get Excel to force the cell to be a hyperlink using the
Get Cell Clickable By Using
To make a cell clickable you can use the
HYPERLINK(link, [text]) which takes two parameters: the first being the reference to
link to, and the second being the
text to display in the cell if you don’t want to display the
In my use case here to make a cell that hasn’t automatically been detected by Excel as an email address, due either to the value of the cell being imported from a CSV or text file, or from the result of a formula, then you can make a new set of cells clickable by using the
Here’s how this would look in your spreadsheet:
HYPERLINK()formula converts a non-clickable cell into a clickable link
To check the formula is working click on cell
A2 and this should open up your default email software and populate the
TO field in a new message with the email address
If it didn’t work you can make the
HYPERLINK() function more explicit by using the following:
Here’s how this looks on my computer after entering the formula and clicking on the link:
If you still don’t find that a email app opens after clicking on the cell then check you do have an email program on your machine and that it is flagged as the default mail client. Perhaps reinstall the email package in case something in your system registries has knocked it out from being the default mail client.
To make an email address clickable in Excel use the function
cell is the location of your non-clickable email address to transform the cell into something that Excel recognises as an email address.
HYPERLINK() will automatically make a cell clickable, but if you don’t have a default email application on your computer then your computer will not understand the