Hyperlink inside a workbook
Hyperlink inside a workbook
(OP)
Hi,
Is that possible I create a hyperlink in "Sheet 1" that it goes to "Sheet 2" of the same work book?
Thanks
Is that possible I create a hyperlink in "Sheet 1" that it goes to "Sheet 2" of the same work book?
Thanks





RE: Hyperlink inside a workbook
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
RE: Hyperlink inside a workbook
Thanks EGT01
RE: Hyperlink inside a workbook
=HYPERLINK("#Sheet2!A1","Sheet2")
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.