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
Formulas and Functions
  • macrordinary's avatar
    macrordinary
    Jun 11, 2020

    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

macrordinary's avatar
macrordinary
Brass Contributor
Jun 11, 2020

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