Hyperlink to worksheet tab

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

Hyperlink to worksheet tab

Post by Tardis40 »

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: 2935
Joined: Wed Mar 11, 2020 5:31 pm

Re: Hyperlink to worksheet tab

Post by SuperTech »

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 »

Thank you.
Post Reply

Return to “PlanMaker 2021 for Mac”