Forum Discussion
Solved
Creating hyperlink
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...
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")
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")
@Mart : Thanks a ton ! Your inputs helped me.
Regards
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")
