| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
linking cells to carry forward a hyperlink
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 |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
linking cells to carry forward a hyperlink
If your hyperlink is in cell A1, then in any other cell enter:
=HYPERLINK(A1) to bring this link forward -- Gary''s Student gsnu200712 |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
linking cells to carry forward a hyperlink
Thanks--one more question--what is the formula if the original cell is in
another worksheet (say the worksheet is called "intro")? Thanks again "Gary''s Student" wrote: If your hyperlink is in cell A1, then in any other cell enter: =HYPERLINK(A1) to bring this link forward -- Gary''s Student gsnu200712 |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
linking cells to carry forward a hyperlink
someting like:
=HYPERLINK(intro!D14) -- Gary''s Student gsnu200712 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create 52 sheets and carry all formulas and figures forward? | Excel Worksheet Functions | |||
| Hyperlink in nested formula not linking | Excel Discussion (Misc queries) | |||
| How do I insert a line in excel and carry the formula forward? | Excel Discussion (Misc queries) | |||
| Carry forward formula help needed | Excel Discussion (Misc queries) | |||
| can I turn off the memory carry-over from previously typed cells | Excel Worksheet Functions | |||
Hybrid Mode
