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...
tauqeeracma Im sorry, I know i am being dense, but I dont understand that last step. After I have entered the '=' sign, I must go to the other sheet (0001 in this case), but once I am there, how do I link it? Ive been trying for a while now, and I cant get it to work...
No issues
Before entering '=' sign, please select the text in formula bar and then press = and simply make a link to other sheet.
tauqeeracma ok, so once I have the =, do I hit ctrl+k to make the link? that doesnt seem to work for me...