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
PeterSchmeits
Dec 15, 2020Copper Contributor
Thanks, 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!