Ask Your Question

How to create a hyperlink in calc

asked 2019-03-03 19:25:05 +0100

monty gravatar image

I am trying to create a spreadsheet with the first worksheet containing a list of client names, and each name is hyperlinked to a specific worksheet that is named for the client. What I am TRYING to do is click on the hyperlink, and the worksheet associated with the client comes to the front so that I can work on it I have followed the instructions explicitly: Create a named range (A1) on the target worksheet; Insert a hyperlink in the first worksheet that points to the file, and the target worksheet. Sometimes the range comes up as a target choice, but most times it does not.

The created "hyperlink" is hi-lit as one would expect, but there is no action when I click on it. I have tried to insert as a button. Whenever I click on the button, it simply chooses the button so that I can delete it - again, no action

Any suggestions? Thanks -Monty

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-03-04 18:05:42 +0100

Lupp gravatar image

Are you looking for something as is demonstrated in this example?
The HYPERLINK() function should be the appropriate means for the purpose. However, it seems to be a bit fragile in its working if editing is done.
Anyway you don't need named ranges if it's ok for you to jump to cell A1 of any chosen sheet.

edit flag offensive delete link more


I opened the example spreadsheet which you sent, and the commands seem to make sense, but there is no action when I click on the hyperlinks. Could it perhaps be something I need to set within the preferences for LibreOffice? It seems like this should be pretty straightforward... (Oh, yes, thank you for your answer!)

monty gravatar imagemonty ( 2019-03-04 21:03:56 +0100 )edit

Did you try it with Ctrl+Click? Requiring the 'Ctrl' is a common setting to prevent inadvertent activation of links. Anyway the examle worked for me as intended.

Lupp gravatar imageLupp ( 2019-03-04 22:16:59 +0100 )edit

When I do the "command"-click (this on a mac) I get the desired result. Thank you so much for your help! -MOnty

monty gravatar imagemonty ( 2019-03-05 01:09:09 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-03 19:25:05 +0100

Seen: 64 times

Last updated: Mar 04