| 100 | =HYPERLINK("#Sheet1!A1","Septmeber 2016") | ||||||||
| 101 | |||||||||
| 150 | |||||||||
| 160 | |||||||||
| 170 | |||||||||
| 180 | |||||||||
| 190 | |||||||||
| 111 | |||||||||
<tbody>
</tbody>
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Multiple Hyperlinks
- Thread starter a1b2c3d4
- Start date
to be more clear, while dragging down the cell reference should consider as =HYPERLINK("#Sheet1!B1","Septmeber 2016") in 2nd row and =HYPERLINK("#Sheet1!C1","Septmeber 2016") in 3rd row and so on. Please assist.
Last edited:
Upvote
0
- Joined
- Aug 18, 2011
- Messages
- 7,155
- Office Version
- 365
- Platform
- Windows
Hi, you could try this:
=HYPERLINK("#"&ADDRESS(1,ROWS($A$1:A1),1,1,"Sheet1"),"Septmeber 2016")
For robustness, change the A1 references to the cell where you initially place the formula.
=HYPERLINK("#"&ADDRESS(1,ROWS($A$1:A1),1,1,"Sheet1"),"Septmeber 2016")
For robustness, change the A1 references to the cell where you initially place the formula.
Upvote
0
Similar threads
- Question
- Solved
