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 ?
A:
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.
keyboardP
2009-12-24 04:46:27
A:
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".
Himanshu
2009-12-24 09:26:55