-
Go to Insert and select Link.
-
Select the This Document tab.
-
Type a destination or choose the worksheet name and select OK.
-
Go to Insert and select Hyperlink.
-
Select the second radio button, Location in this file.
-
Type the other worksheet name and a cell separated by an exclamation point and select OK. For example Sheet2!G15 or Accounting!A1.