Excel – Hyperlink to other worksheet using hyperlink function in excel

hyperlinkmicrosoft-excel-2007

I'm having problems using the Hyperlink function of Excel. I have a name in cell A1, In cell a2 I want a hyperlink that links to the worksheet that is named the same as the name in cell A1

Best Answer

=HYPERLINK("#'linked sheet name'!linked cell number","your message")

For example

=HYPERLINK("#'Page 2'!A4","TEST")

The linked sheet name is Page 2 and linked cell number is A4 and message is TEST. The # is shorthand for the local workbook.

Related Question