Sep 10 2018 09:50 AM
Hey there,
I was wondering if anyone can tell me how this works:
I have a question on page 1 in cel A1 and I want whenever I click on that cell to go to another page or cell where the question is explained. Is this possible?
Greetings,
Jules
Sep 10 2018 10:21 AM
SolutionHi Jules,
You can insert a hyperlink for each quesion to point it to a specific cell reference in the same sheet or in another sheet.
To do that, select the question then press Ctrl+K to open Insert Hyperlink dialog box.
Then select Place in This Document, specify the sheet, type the cell reference, and then hit OK.
Hope that helps
Haytham
Sep 11 2018 12:47 AM - edited Sep 11 2018 12:54 AM
sorry to intrude, I tried your hyperlinks, it's nice.. after seeing the answer say in other sheet - how to return back to the questionaire when we press the cell with the answer...
thanks
Sep 11 2018 01:11 AM
Sep 11 2018 09:33 AM
Thanx Haytham for your response. It is exactly what I meant. Thanks a lot!
May 29 2019 01:17 AM
Haytham,
I am having problems using Hyperlinks to Cells within the same Excel Sheet, but the only similar thread I could find was this one that you previously responded to.
Is there any way you can use Absolute Cell Referencing (ie $G$1) in the Hyperlink?
In your example, Relative Cell Referencing (G1) is used, and that is all I have been able to do in a Spreadsheet I am trying to work on. However, if in your simple example, you then insert another Column or Row (Left of G, or above 1), the Hyperlink will point to the wrong Cell (as it does not automatically update).
I hope that you can understand what I am trying to say, and that you are still around to help.
If not, could anyone else help?
Thanks in advance,
Craig H
May 29 2019 02:24 AM
Enclose the link_location argument of HYPERLINK with double quotes, like this:
=HYPERLINK("#'Destination Sheet'!G1","LinkName")
May 29 2019 06:37 AM
Hi @CraigHealdpoint,
The problem with hyperlinks in Excel is that they are related to the location, not the content!
But there is a workaround as follows:
Hope that helps
Regards,
Haytham
Sep 10 2018 10:21 AM
SolutionHi Jules,
You can insert a hyperlink for each quesion to point it to a specific cell reference in the same sheet or in another sheet.
To do that, select the question then press Ctrl+K to open Insert Hyperlink dialog box.
Then select Place in This Document, specify the sheet, type the cell reference, and then hit OK.
Hope that helps
Haytham