How do you display the actual worksheet in the file path? (excel 2010)

[stephenrodriguez]

How do you display the actual worksheet in the file path? (excel 2010) I need to be able to create a hyperlink where when I click on it, it will open directly that specific worksheet in the workbook. Thanks

[JieJenn]

Use hyperlink

http://www.techonthenet.com/excel/fo.../hyperlink.php

[DGagnon]

you can add #Sheet1!A1 to your hyper link, something like this

C:\Documents and Settings\ca705363\Desktop\Fourms\banking.xls#Sheet1!A1