Linking

Copper Contributor

How to link one cell in an excel worksheet so that it will jump to another cell in a different worksheet (say source worksheet) when clicked on. 

2 Replies

hi @Rick0302 

 

You may use the function HYPERLINK 

 

 

=HYPERLINK("#Sheet2!C2","Go To Sheet2")

 

 

for details please see the below link 

https://support.office.com/en-us/article/hyperlink-function-333c7ce6-c5ae-4164-9c47-7de9b76f577f

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com

If you find the above solution resolved your query don't forget mark as Official Answer.

Hi,

Right-click on the particular cell and select Link
In the intermediate dialogue box, select Place in this document
Select the cell reference and sheet to link to...
Click OK