XL Hyperlink to other worksheet using hyperlink function in excel

20210710 2222 

 

REF

[1] "https://superuser.com/questions/163919/hyperlink-to-other-worksheet-using-hyperlink-function-in-excel"

 

00 Basic

=HYPERLINK("[File]SheetName!A1", "NiceName" )

⇒ we need something to indicate "This File" in the place of [File]

 

01 Using # as This File - needs small quotation marks

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

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

(note) Above case, we use small quotation marks, becasue the sheet name has "space" in it. If we don't have spaces in the sheet name, we don't need the small quoation marks.(see below)

 

 

 

02 Using [.\] as This File - don't need small quotation marks

=HYPERLINK("[.\]Report!D4", "Click here to go to cell D4 of the Report tab")