Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink trouble
I have a hyperlnk in cell A1. I want to place a formula in G1 that says: = A1 When I do that, I get same text as I have in A1, but it does not behave as a hyperlink. I want my cell with formula to behave as hyperlink. I know I can cut/paste from A1 to G1, that gives me hyperlink in G1. However, I want to use a formula. Is this possible to do? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink trouble
"ticu" wrote in message
... I have a hyperlnk in cell A1. I want to place a formula in G1 that says: = A1 When I do that, I get same text as I have in A1, but it does not behave as a hyperlink. I want my cell with formula to behave as hyperlink. I know I can cut/paste from A1 to G1, that gives me hyperlink in G1. However, I want to use a formula. Is this possible to do? Even with a formula in the cell, you can insert a hyperlink as well if you wish to: Insert/ Hyperlink -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink trouble | Excel Worksheet Functions | |||
answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
Quickdoc imports to Excel 2003 hyperlink trouble | Excel Discussion (Misc queries) | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Removing hyperlink | Excel Discussion (Misc queries) |