Forum Discussion
Book Marking in Excel
Hi all, Hoping someone can help me, I have a large working spreadsheet that I need to add bookmarks too between worksheets. Now, I know you can hyperlink from a anchor text to a specific cell. Ho...
You could use the HYPERLINK function in combination with the CELL function. like so:
=HYPERLINK(CELL("address",Sheet1!B9),"Click here")
If you do it this way, inserting or deleting rows/columns will cause the HYPERLINK function to adjust itself. Alternatively, you can also use range names for the cells you want to link to. A disadvantage is that you have to create a range name for each link.
=HYPERLINK(CELL("address",Sheet1!B9),"Click here")
If you do it this way, inserting or deleting rows/columns will cause the HYPERLINK function to adjust itself. Alternatively, you can also use range names for the cells you want to link to. A disadvantage is that you have to create a range name for each link.
Hi, JKPieterse
Thank you for your response! I am not fantastically confident with excel formula's but I'll give it ago!
Thanks 🙂