| 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) | |||
Linear Mode
