Creating HTML Link in Excel


Basically i want to create a HTML link in Excel but i dont know the correct code to do so. I just type in the web address like normal in a colum in Excel and when i convert it over into an html page it just shows the actually address of the link i typed.

For example:

I type in

The link shows up but it is not clickable its only normal text. I want it to come up as clickable.


Hi, thanks for your consideration.

If you want to add a hyperlink in Cell A1 of the first worksheet, try the following code:

excel.Worksheets[0].Hyperlinks.Add(0, 0, 1, 1, " ");