×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Referenced Cell - Hyperlink

Referenced Cell - Hyperlink

Referenced Cell - Hyperlink

(OP)
I created 2 worksheets.
In the worksheet labeled address it has 3 cells that link to web address (i.e. CNN, JCREW).
In the worksheet labeled Summary it has 3 cells that reference the cells in the address worksheet.

This issue I have is that I want users to be able to click on the cells referenced in the summary worksheet and be linked to the web addresses from the address worksheet.

Every time I create a link from summary to the address worksheet, the user is just brought to the address sheet.

How do I make the referenced cell act like the original cell with the hyperlink in it?

RE: Referenced Cell - Hyperlink

1. To create a hyperlink to another cell in your spreadsheet, right-click on the cell where the hyperlink should go. Select Hyperlink from the popup menu.
2. When the Insert Hyperlink window appears, click on the "Place In This Document" on the left. Enter the text to display. In this example, we've entered "Hyperlink to cell A5". This is the value that will be displayed in Excel.
3. Next enter the cell reference that the hyperlink points to. We've chosen to link to cell A5. Click the OK button.
4. Now when you return to the spreadsheet, you should see the hyperlink.
5. If you click on the hyperlink, your active cell should become cell A5.

--
Smith


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close