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
I overcomplicated. Use a formula instead (with or without $):
=HYPERLINK('tab b'!B4,"friendly text")
Or, if you want the visual address of the link to change:
=HYPERLINK('tab b'!B4,CELL("address",'tab b'!B4))