Linking

Post Reply
Janderson
Posts: 2
Joined: Tue Jul 30, 2024 3:22 am

Linking

Post by Janderson »

I do quite a bit of linking in my spreadsheets. In Excel it is a breeze. PlanMaker is a challenge. What I want is simple. Click on a name and it goes to the dedicated sheet of that name, same workbook different sheets. But in order to do that, I need to have the Jump Target show the name of the tabs so I pick the one needed. But most of the tabs aren't even there. I noticed when I set the print area, that is an option to choose from in "Jump Target". Why aren't the names of each tab in there too?
We are hoping future releases can have linking just like Excel.
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 3115
Joined: Wed Mar 11, 2020 5:31 pm

Re: Linking

Post by SuperTech »

Thank you for posting your query. Jump target can be any range from any sheet, so this can be 1000s of combinations.

Simplest approach if you have many sheets:

1. Click on the cell where you want to set the link.
2. Click on ribbon command Insert | Hyperlink.
3. In jump target type <Destination sheet name>!A1 e.g., Sheet2!A1, where A1 is the designation cell.

If you don't want to type sheet's name, you can copy it from sheet tab.
Post Reply

Return to “PlanMaker NX and 2024 for Windows”