give hyperlink of specific worksheet in another workbook

By Super Man

give hyperlink of specific worksheet in another workbook

here i am showing how to give link of particular worksheet ( lets take sheet1) of workbook(workbook1)
in another workbook ( workbook2).

then in workbook follow the steps as below :)




• Select a cell where you want to place the hyperlink;
• Type a description of the workbook you want to link to;
• Right click on that cell and choose Hyperlink...;
• Click the File... button and browse to the file location;
• Select the file you want to link to and click OK;
• If you want to go to a specific sheet in the workbook, click on the Bookmark... button, select the sheet name and click OK.


• You can also click the Screen Tip... button to add a description to your hyperlink that will pop up when a user holds the mouse over the hyperlink.
• Click OK to close the Insert Hyperlink dialog box and save your workbook.
• Try out the hyperlink to see how it works.

give hyperlink of specific worksheet in another workbook  (1232 Views)