Go to Excel worksheet by clicking on cell

15 pts.
Tags:
Microsoft Excel
I have two worksheets - namely ABC and XYZ. In worksheet ABC, I have written XYZ in one cell. So now how to I go to the worksheet XYZ by just clicking on the cell containing XYZ in worksheet ABC?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Read up on the  process to set up a link within the same work book here at the Microsoft Office support page

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Make a hyperlink to open another worksheet from current worksheet. You can invoke the Help page of Excel, which is an excellent helpful page with .chm file extension. You can get this one by clicking Help menu.  
    140,720 pointsBadges:
    report
  • fkpwala
    i tried all options but failed.
    15 pointsBadges:
    report
  • azohawk
    Do I understand that you simply want to type XYZ in any cell of worksheet ABC and automatically jump to XYZ worksheet.  Not sure that can be done, the hyperlink must be created prior to clicking on the cell. 
    4,055 pointsBadges:
    report
  • ToddN2000
    What version of Excel are you using?
    134,585 pointsBadges:
    report
  • Subhendu Sen
    What options did you try? How did you tried? Is hyperlink does not work on your excel sheet. Please come back with error(s) if any.
    140,720 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: