Forum Discussion
How to get the link to show the text in referenced cell
So I have an index that links to other sheets. But it will name the link '1'. I am not sure what i need to do, so that the hyperlink simply copies the text in a specific cell, which in this case will...
Hi
I understand your confusion because you have 2 contributors replying to you using two completely different concepts:
The CTRL + K for inserting a hyperlink is a STATIC technique used when you need just one or 2 links >> I am not using this technique.
However
The technique I am showing you is a DYNAMIC technique that enables you to create a "HYPERLINK" formula that can be copied to thousands of cells
Please do not mix the instructions from different contributors when they discuss different options.
Nabil Mourad