Creating hyperlink

[AlokBeheria]

Hello All,

Hello ,

I am trying to create hyperlink from sheet 1 to jump to another sheet within a range. For example, in the given sheet 1, there are values like First , Second and Third to jump to the values which sits in another sheet. In given below image , I want to click Value first and it should direct me to sheet 2 "This is a first line". I want to use this hyperlink to use other values to perform similar task as it did in First case.  I tried to use built in hyperlink function to no avail.

Regrds

[#2]

Hi @AlokBeheria 

if you want to use the HYPERLINK function to jump to another sheet within the same workbook, you need to include the filename in the link address and put everything in quotation marks:

=HYPERLINK("[Creating_hyperlink.xlsx]Sheet2!A2","Title")

[#3]

@Martin_Weiss  : Thanks for your inputs. I tried doing it , but discovered errors.

[#4 · Accepted solution]

Hi @AlokBeheria 

you have a comma after the ] that needs to be removed:

Instead of 

=HYPERLINK("[hyperlink_test.xlsx],Sheet1!A2","title")

it should be

=HYPERLINK("[hyperlink_test.xlsx]Sheet1!A2","title")

[#5]

@Mart : Thanks a ton ! Your inputs helped me. 

Regards