Calc: hyperlink is unreadable

When I create a hyperlink in Calc, it’s surrounded in grey, which makes it very hard to read. How can I fix this?

You can use the function HYPERLINK and create with a formula in a cell.

For example:

=HYPERLINK("www.google.com")

Maybe also change color to blue and underline to make it more obvious its a link

Edit:
If you want to display different text in the link then the second argument needs to be a text string, or a reference to a text string.

=HYPERLINK("http://vidgo.com";"Vidgo")

I tried using the function wizard, and the syntax for this function is different from what is shown in the online help menu; the difference is that the help menu shows a semicolon between the URL and name, while the function wizard doesn’t show it. Regardless of how I enter it, I get a #NAME? error. For example, I entered

=HYPERLINK(“http://vidgo.com”;Vidgo)

I tried this with and without the http and it still flags this as an error. I even used the select buttons to enter the text, and it still doesn’t work.

I really wish this worked like Excel does - SO much easier…any hints?

=HYPERLINK(“http://vidgo.com”;“Vidgo”) works fine for me, you need to put the text with quotes.

Thank you very much. That seem to work just fine. Much appreciated. I will add a bug report for the function wizard to correctly show the syntax for that command - right now, it’s not correct.

Maybe it can be more detailed, but all text to include as part of functions must be with quotes. If the answer solves your question please tick the :heavy_check_mark:.