How to insert a link as a hyperlink in LibreOffice Calc?

Question

libreoffice

In LibreOffce Calc, a link from the browser is inserted in two forms:
1) As text - if I simply paste the copied link into a cell using Ctrl + V
2) As a hyperlink - if I first put a caret in the cell (either through F2 or double click) , and then I copy the link

Is there an option to make a copy according to paragraph 1, but so that the link is inserted not as text, but as a hyperlink?

And then every time I'm tired of pressing F2, can I somehow copy the hyperlink by default?