Hyperlink inside a workbook

[mohtogh]

Hi,
Is that possible I create a hyperlink in "Sheet 1" that it goes to "Sheet 2" of the same work book?

Thanks

 

[EGT01]

You would need to pick a spot to go to on Sheet 2 but here's a couple of ways.

Use the Hyperlink function, for example, if the workbook you have open is named Book1 and you want to go to cell A1 on Sheet2, enter the following:
=HYPERLINK("[Book1]Sheet2!A1","Sheet2")

as an alternative

Right click the cell where you want to put a hyperlink and select Hyperlink from the pop-up menu.
In the Insert Hyperlink window select and complete the following:
Link to: Place in This Document
Text to display: Sheet2
Type the cell reference: A1
Or select a place in this document: Sheet2
Now click on "OK" to close the window

 

[mohtogh]

Excellent.
Thanks EGT01

 

[joerd]

If you don't want to be dependent on the name of the file (because you might want to save it under another name), use the # sign:
[tt]=HYPERLINK("#Sheet2!A1","Sheet2")[/tt]

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.