Hyperlink to another sheet, same workbook

D

Dgwood90

I am trying to create hyperlinks to other sheets in the same book. When I
click on the link, I receive File not found. I followed the instructions in
help with no success.
 
J

JE McGimpsey

Since you didn't say which instructions you followed (there's more than
one way to create a hyperlink), it's hard to say what went wrong, but
one way to do it:

1) Select the cell to contain the hyperlink.
2) Choose Insert/Hyperlink
3) In the Link to: box, enter an octothorpe followed by the sheet and
cell reference. For instance, for worksheet Sheet3, cell J10:

#Sheet3!J10

4) Enter any display text in the Display: box
5) Click OK.
 
D

Dave Peterson

You could also use the =hyperlink() worksheet function:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
 
Top