I simply want to create a link on the main page of a work book that, when clicked, will move to a specific cell in another worksheet of the same workbook. Seems this should be simple, but I cannot locate the correct command. Any guidance would be greatly appreciated! Thank you!!!

Nope, you only create the link for end user to click on which (s)he goes on another sheet. To create the link click on and after that something like this Please see attached.

Want a button in worksheet1 to connect to a specific cell in worksheet2 of same workbook as "go to."

SergeiBaklan
MVP
May 29, 2018
Hi Ginger,

In ribbon Insert->Link->Place in this document, here select the cell and text to display
- Ginger M
  Copper Contributor
  May 29, 2018
  Thank you, Sergei. However, either I did not understand your instruction, or the function you describe is not available to me. To be clear, you meant that while in the Worksheet 1 that I want to permit user to activate a link, I should type in the ribbon as you note below entering the cell coordinates on Worksheet 2 that I want to link - correct?
  
  This did not work for me.
  - SergeiBaklan
    MVP
    May 29, 2018
    Nope, you only create the link for end user to click on which (s)he goes on another sheet. To create the link click on
    
    and after that something like this
    
    Please see attached.
    
    Link to sheet.xlsx10 KB

Forum Discussion

Want a button in worksheet1 to connect to a specific cell in worksheet2 of same workbook as "go to."