Hyperlink to worksheet tab

Post Reply
Tardis40
Posts: 2
Joined: Fri Jun 12, 2020 5:23 pm

Hyperlink to worksheet tab

Post by Tardis40 » Fri Jun 12, 2020 5:29 pm

I have a file that has 3 tabs. The first tab is an index and I'd like to put a hyperlink to another tab so clicking on a cell will take me to a specific cell in another tab. An example is tab INDEX and the other tabs TAB A and TAB B. Click on a cell in INDEX will take me to TAB B cell A12.

I've tried a number of ways to do this but can't make it work. Can someone help me accomplish this?

SuperTech
SoftMaker Team
SoftMaker Team
Posts: 1424
Joined: Wed Mar 11, 2020 5:31 pm

Re: Hyperlink to worksheet tab

Post by SuperTech » Fri Jun 12, 2020 5:45 pm

Yes, you can use the Hyperlink function for that purpose. In the cell where you want to click in Index Tab to jump on Tab B, enter below function:

=HYPERLINK("[]Tab B!A12")

Thanks

Tardis40
Posts: 2
Joined: Fri Jun 12, 2020 5:23 pm

Re: Hyperlink to worksheet tab

Post by Tardis40 » Fri Jun 12, 2020 6:48 pm

Thank you.

Post Reply

Return to “PlanMaker 2021 for Mac”