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.
Linking
Re: Linking
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.
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
2 posts
• Page 1 of 1
Return to “PlanMaker NX and 2024 for Windows”
Jump to
- SoftMaker Office NX and 2024
- ↳ SoftMaker Office NX and 2024 for Windows
- ↳ SoftMaker Office NX and 2024 for Windows (General)
- ↳ TextMaker NX and 2024 for Windows
- ↳ PlanMaker NX and 2024 for Windows
- ↳ Presentations NX and 2024 for Windows
- ↳ BasicMaker NX and 2024 for Windows
- ↳ SoftMaker Office NX and 2024 for Mac
- ↳ SoftMaker Office NX and 2024 for Mac (General)
- ↳ TextMaker NX and 2024 for Mac
- ↳ PlanMaker NX and 2024 for Mac
- ↳ Presentations NX and 2024 for Mac
- ↳ SoftMaker Office NX and 2024 for Linux
- ↳ SoftMaker Office NX and 2024 for Linux (General)
- ↳ TextMaker NX and 2024 for Linux
- ↳ PlanMaker NX and 2024 for Linux
- ↳ Presentations NX and 2024 for Linux
- ↳ SoftMaker Office NX for iOS
- ↳ SoftMaker Office NX for iOS (General)
- ↳ TextMaker NX for iOS
- ↳ PlanMaker NX for iOS
- ↳ Presentations NX for iOS
- ↳ SoftMaker Office NX for Android
- ↳ SoftMaker Office NX for Android (General)
- ↳ TextMaker NX for Android
- ↳ PlanMaker NX for Android
- ↳ Presentations NX for Android
- SoftMaker Office 2021
- ↳ SoftMaker Office 2021 for Windows
- ↳ SoftMaker Office 2021 for Windows (General)
- ↳ TextMaker 2021 for Windows
- ↳ PlanMaker 2021 for Windows
- ↳ Presentations 2021 for Windows
- ↳ BasicMaker 2021 for Windows
- ↳ SoftMaker Office 2021 for Mac
- ↳ SoftMaker Office 2021 for Mac (General)
- ↳ TextMaker 2021 for Mac
- ↳ PlanMaker 2021 for Mac
- ↳ Presentations 2021 for Mac
- ↳ SoftMaker Office 2021 for Linux
- ↳ SoftMaker Office 2021 for Linux (General)
- ↳ TextMaker 2021 for Linux
- ↳ PlanMaker 2021 for Linux
- ↳ Presentations 2021 for Linux
- ↳ SoftMaker Office 2021 for Android
- ↳ SoftMaker Office 2021 for Android (General)
- ↳ TextMaker 2021 for Android
- ↳ PlanMaker 2021 for Android
- ↳ Presentations 2021 for Android
- ↳ SoftMaker Office 2021 for iOS
- ↳ General
- ↳ TextMaker 2021 for iOS
- ↳ PlanMaker 2021 for iOS
- ↳ Presentations 2021 for iOS
- FreeOffice 2024
- ↳ FreeOffice 2024 for Windows
- ↳ FreeOffice 2024 for Windows (General)
- ↳ FreeOffice TextMaker 2024 for Windows
- ↳ FreeOffice PlanMaker 2024 for Windows
- ↳ FreeOffice Presentations 2024 for Windows
- ↳ FreeOffice 2024 for Mac
- ↳ FreeOffice 2024 for Mac (General)
- ↳ FreeOffice TextMaker 2024 for Mac
- ↳ FreeOffice PlanMaker 2024 for Mac
- ↳ FreeOffice Presentations 2024 for Mac
- ↳ FreeOffice 2024 for Linux
- ↳ FreeOffice 2024 for Linux (General)
- ↳ FreeOffice TextMaker 2024 for Linux
- ↳ FreeOffice PlanMaker 2024 for Linux
- ↳ FreeOffice Presentations 2024 for Linux
- FreeOffice 2021
- ↳ FreeOffice 2021 for Windows
- ↳ FreeOffice 2021 for Windows (General)
- ↳ FreeOffice TextMaker 2021 for Windows
- ↳ FreeOffice PlanMaker 2021 for Windows
- ↳ FreeOffice Presentations 2021 for Windows
- ↳ FreeOffice 2021 for Mac
- ↳ FreeOffice 2021 for Mac (General)
- ↳ FreeOffice TextMaker 2021 for Mac
- ↳ FreeOffice PlanMaker 2021 for Mac
- ↳ FreeOffice Presentations 2021 for Mac
- ↳ FreeOffice 2021 for Linux
- ↳ FreeOffice 2021 for Linux (General)
- ↳ FreeOffice TextMaker 2021 for Linux
- ↳ FreeOffice PlanMaker 2021 for Linux
- ↳ FreeOffice Presentations 2021 for Linux
- ↳ FlexiPDF 2022
- ↳ FreePDF 2022
- Miscellaneous
- ↳ SoftMaker Fonts
- ↳ Water Cooler
- ↳ SoftMaker Office 2018 for Windows (General)
- ↳ TextMaker 2018 for Windows
- ↳ PlanMaker 2018 for Windows
- ↳ Presentations 2018 for Windows
- ↳ Thunderbird for Windows
- ↳ BasicMaker 2018 for Windows
- ↳ SoftMaker Office 2018 for Mac (General)
- ↳ TextMaker 2018 for Mac
- ↳ PlanMaker 2018 for Mac
- ↳ Presentations 2018 for Mac
- ↳ SoftMaker Office 2018 for Linux (General)
- ↳ TextMaker 2018 for Linux
- ↳ PlanMaker 2018 for Linux
- ↳ Presentations 2018 for Linux
- ↳ BETA SoftMaker Office 2024 for Windows
- ↳ BETA SoftMaker Office 2024 for Windows (general)
- ↳ BETA TextMaker 2024 for Windows
- ↳ BETA PlanMaker 2024 for Windows
- ↳ BETA Presentations 2024 for Windows
- ↳ BETA BasicMaker 2024 for Windows
- ↳ BETA SoftMaker Office 2024 for Mac
- ↳ BETA SoftMaker Office 2024 for Mac (general)
- ↳ BETA TextMaker 2024 for Mac
- ↳ BETA PlanMaker 2024 for Mac
- ↳ BETA Presentations 2024 for Mac
- ↳ BETA SoftMaker Office 2024 for Linux
- ↳ BETA SoftMaker Office 2024 for Linux (general)
- ↳ BETA TextMaker 2024 for Linux
- ↳ BETA PlanMaker 2024 for Linux
- ↳ BETA Presentations 2024 for Linux
- ↳ BETA SoftMaker Office NX for Android
- ↳ BETA SoftMaker Office NX for Android (general)
- ↳ BETA TextMaker NX for Android
- ↳ BETA PlanMaker NX for Android
- ↳ BETA Presentations NX for Android
- ↳ BETA SoftMaker Office NX for iOS
- ↳ BETA SoftMaker Office NX for iOS (general)
- ↳ BETA TextMaker NX for iOS
- ↳ BETA PlanMaker NX for iOS
- ↳ BETA Presentations NX for iOS