Ask Your Question
0

Calc index sheet with links to the corresponding sheet

asked 2017-12-21 17:06:11 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have a Calc sheet with 18 sheets. I want to create an index sheet so that the end user can click on the name they are looking for and it will take them to the corresponding sheet.

I have created multiple sheets in one document which contain specific information about different sites. I want to create an index page that will have hyperlinks so that the end user can click on the desired site and it would take them to the corresponding sheet where they will find additional information.

When I use the Hyperlink command I get an error "Site XX " is not an absolute URL that can be passed to an external application to open it. The syntax is...

=HYPERLINK('161.119.139'.D222)
edit retag flag offensive close merge delete

Comments

Please do not post as community wiki. See guidelines for asking.

Jim K gravatar imageJim K ( 2017-12-21 18:38:56 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2017-12-21 17:43:12 +0200

librebel gravatar image

updated 2017-12-21 17:44:19 +0200

Hello @,

To make your hyperlink jump to a named Sheet, for example “Sheet2”, you could just use the jump mark “#” in front of the sheet name, e.g.:

=HYPERLINK("#Sheet2"; "CTRL-Click here to go to Sheet2")

NB. This locale uses the semicolon “;” as argument separator. If your locale uses the comma instead, then change the semicolon into a comma.

edit flag offensive delete link more

Comments

The syntax for the sheet and cell in the question is =HYPERLINK("#'161.119.139'.D222"; "CTRL-Click here to go to Sheet2").

Jim K gravatar imageJim K ( 2017-12-21 18:43:38 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-12-21 17:06:11 +0200

Seen: 288 times

Last updated: Dec 21 '17