linking cells to carry forward a hyperlink

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am setting up an excel spreadsheet with internally linked cells. Some of
the original cells contain hyperlinks. How do I create a link so that the new
cell not only contains the content of the original cell, but the new
hyperlink as well (at the moment, it contains the content of the original
cell (the actual words) but will not carry a URL?

Thanks
 
If your hyperlink is in cell A1, then in any other cell enter:

=HYPERLINK(A1)

to bring this link forward
 
Thanks--one more question--what is the formula if the original cell is in
another worksheet (say the worksheet is called "intro")? Thanks again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Import Comments 3
Excel Macro to hyperlink an archived worksheet to an index page 0
Cell shows the last typed text, no matter where it is typed 0
Can UDF return a customized hyperlink? 3
View Hyperlink in another cell 1
Help with hyperlinks 2
Copy hyperlinks 6
Unable to follow Hyperlink via keyboard Enter button 1

Back
Top