Forum Discussion
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...
The best way is to define a name range for Cell B4 in Tab B. See the example below:
1. Define Name
Formulas > Name Manager > New
2. Insert Hyperlink
Ctrl + K (shortcut) >Place in this Document > Defined Names
Now even if you add columns/rows, the defined cell will always be selected
adversi, Thanks for your reply, I got it working now. Thanks!
