Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to create a hyperlink in excel, using the text in a cell.
In the Address field in the 'Edit Hyperlink' window, I want to refer to a
cell that contains the http-address, rather than hardcoding it. I don't know how to do this. Thanks. |
#2
|
|||
|
|||
Why not use the hyperlink function? Then you can refer to any cell you
want. =HYPERLINK(A1,"Friendly Display Text") HTH, Gary Brown "Leo" wrote in message ... In the Address field in the 'Edit Hyperlink' window, I want to refer to a cell that contains the http-address, rather than hardcoding it. I don't know how to do this. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format a text cell in Excel | Setting up and Configuration of Excel | |||
Problems with hyperlinks | Excel Discussion (Misc queries) | |||
how do I display a hyperlink in a seperate cell in excel? | Excel Discussion (Misc queries) | |||
Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |