hyperlink to a sheet in excel

is it possible to create a hyperlink in an excel document , clicking on which opens a particular sheet in the excel document . please开发者_开发问答 let me know ?

If you want to add that hyperlink in the same workbook then

a. Right click on cell in which you want to display hyperlink and click "Hyperlink"

b. It presents you a dialog. From left pane titled "Link to", press "Place in this document"

c. Your worksheet names will appear in the list box titled "Select a place in this document"

d. Select the desired sheet and write the text you want to display and click "OK".

If it's a hyperlink on your website, and you can choose what worksheet you want to use, simply open that particular sheet, save, then close Excel. It will open the workbook on whichever sheet it was closed on.