Move to a link?

I

its_my_dime

I want to create a cell on a worksheet that, if I click on it, a new
worksheet section (same workbook - different sheet ) will open.

(Essentially, if I click next to a cell that says Exhibit II, I want Exhibit
II to open.)

How do I do this?

Thank you
 
E

Earl Kiosterud

Dime,

It's not a link (that's different in Excel), but a hyperlink. Try Insert -
Hyperlink. Use "Place in this document" at the left. You can put in
"Exhibit II" at the top, and it will appear in the cell, blue and
underlined, in the typical hyperlink style, which you can remove or change
with the usual Excel formatting.
 
F

fuzzyfreak

You could use a Hyperlink - click on the cell, select Insert, Hyperlin
or click Ctrl K - Select "Place in this Document" located on the lef
hand menu, select the sheet you wish to link to from the documen
selection area. Change the cell reference or the text to display i
you wish and click OK
 
Top