We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

where is the goto function within calc

asked 2018-10-06 05:05:56 +0200

IT Mechanic gravatar image

where is the "goto function" within calc? created index for an in sheet location of data. would like to click on the subject or row number and go directly to that particular row for data

edit retag flag offensive close merge delete

4 Answers

Sort by » oldest newest most voted

answered 2018-10-06 11:30:42 +0200

Lupp gravatar image

updated 2018-10-06 11:33:29 +0200

In addition to the answer by @MikeKaganski:
For a target you need to go to repeatedly, you also can use the HYPERLINK function like in one of the following examples:

=HYPERLINK("#G15:J32"; "Check!")  for a target in the same sheet.
(The arbitrary string in the second position is shown in the cell if present.)
=HYPERLINK("#myUsefulSheet.G15:J32")  for a target in the sheet named myUsefulSheet
=HYPERLINK("#relevantRange") to go to a range named "relevantRange"
=HYPERLINK(myAbsoluteFilePath & "#$refSheet.C11:C13")  for a target in any sheets document
(myAbsoluteFilePath is expected to NOT be "single quoted".)

This allows for quick editing and also for calculated target strings.

edit flag offensive delete link more

answered 2018-10-06 10:11:47 +0200

Also in your index, you may simply InsertHyperlink (Ctrl+K) to a target in the document, like Sheet1.B100 or just a named range's name.

edit flag offensive delete link more

answered 2018-10-06 07:53:23 +0200

ebot gravatar image

In the sidebar, call up the navigator. There you can specify column and row.

edit flag offensive delete link more

answered 2018-10-06 05:55:27 +0200

Ratslinger gravatar image

updated 2018-10-06 06:11:03 +0200


First define a name. See -> Naming Cells. That name will appear in the Name Box on the Formula Bar. Use the dropdown and select the name to go to that cell/range.

You can also just enter a cell location in the Name Box & hit Enter to go to that cell.

Edit: You can also see this info in the LO documentation -> Getting Started with LibreOffice. Chapter 5 - Getting Started with Calc. Look at Formula bar (around page 9).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-06 05:05:56 +0200

Seen: 1,698 times

Last updated: Oct 06 '18