Forum Discussion
PeterSchmeits
Dec 15, 2020Copper Contributor
Hyperlink or Link between two tabs in the same document
Hi, I am working with Excel in Office365. I have a spreadsheet containing multiple tabs and what I would like to do is create a link between a specific cell (A1) in tab A, to a specific cell (B4) in...
MindreVetande
Dec 15, 2020Iron Contributor
You could define a name pointing att B4 (lets call it OldB4)
Use the name-box or [Ctrl]+[F3], New
Goto TabA and insert a Hyperlink-this book->Defined names
Now your hyperlink will always point att OlldB4
- PeterSchmeitsDec 15, 2020Copper ContributorThanks, it works with this one. With the Hyperlink function as mentioned in your second post I somehow don't get it working. The defined names option will work, thanks!