[Solved] Use cell as "button" to jump to another cell

[iraflet]

Is there a way to basically turn a cell into a button to move me to a certain location on the spreadsheet? Probably not, but I can hope.

Edit: Changed subject, was Navigation  Make your post understandable by others  -- MrProgrammer, forum moderator

[MrProgrammer]

Is there a way to basically turn a cell into a button to move me to a certain location on the spreadsheet?

Use the HYPERLINK function in the cell. Click cell B5 in my attachment to see this work. To select B5 so you can see its formula without triggering the link select A5 and use the right arrow key.

202212111213.ods

(9.88 KiB) Downloaded 203 times

Or you can use Insert → Hyperlink → Document. Read about hyperlinks in Help → Index or in User Guides (PDF) or searching for topics about them in the Calc Forum.

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know