Forum Discussion

SanjeevSoni's avatar
SanjeevSoni
Copper Contributor
Jun 11, 2020
Solved

How to set hyperlink to specific cell to another workbook

How to use Hyperlink command to setup link to another workbook to specific sheet and cell

  • SanjeevSoni

     

    The command is: =HYPERLINK([File Name]SheetName!RangeName)

    An example is: =HYPERLINK([Book1.xlsx]Sheet2!A10)

     

    Full documentation on this function is at https://support.office.com/en-us/article/hyperlink-function-333c7ce6-c5ae-4164-9c47-7de9b76f577f?NS=EXCEL&Version=90&SysLcid=1033&UiLcid=1033&AppVer=ZXL900&HelpId=xlmain11.chm60407&ui=en-US&rs=en-US&ad=US

2 Replies

  • macrordinary's avatar
    macrordinary
    Brass Contributor

    SanjeevSoni

     

    The command is: =HYPERLINK([File Name]SheetName!RangeName)

    An example is: =HYPERLINK([Book1.xlsx]Sheet2!A10)

     

    Full documentation on this function is at https://support.office.com/en-us/article/hyperlink-function-333c7ce6-c5ae-4164-9c47-7de9b76f577f?NS=EXCEL&Version=90&SysLcid=1033&UiLcid=1033&AppVer=ZXL900&HelpId=xlmain11.chm60407&ui=en-US&rs=en-US&ad=US

Resources