Forum Discussion

mahmoud zidan's avatar
mahmoud zidan
Copper Contributor
Apr 08, 2017

connecting sheets

how to use Hyperlink to jump to sheets in the same workbook

 

excel

2 Replies

Sort By
  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Apr 09, 2017
    =HYPERLINK( "#Sheet2!A1", "Link Text to Display")

    The # and " " are critical

    Also, safest approach is to name the cell you want to link to e.g. hypSht2

    Then your formula is =HYPERLINK( "#hypSht2", "Link Text to Display")

Resources