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
If after checking the cell is not set to
and even after entering a
email address Excel isn’t converting the entry to a hyperlinked
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
which takes two parameters: the first being the reference to
to, and the second being the
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:
formula converts a non-clickable cell into a clickable link
To check the formula is working click on cell
and this should open up your default email software and populate the
field in a new message with the email address
If it didn’t work you can make the
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
is the location of your non-clickable email address to transform the cell into something that Excel recognises as an email address.
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