ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlink within cell (https://www.excelbanter.com/excel-discussion-misc-queries/3750-hyperlink-within-cell.html)

Mike D.

Hyperlink within cell
 
Hi. I know how to apply a hyperlink to the full contents within a cell. How
do I go about inserting a hyperlink within a cell. For instance, if the cell
contents were "Click here to go to the Engineering web page", I would like to
have "Click here" contain the hyperlink.

Thanks,
Mike.

Peo Sjoblom

Not really, there might be some workarounds using text boxes or multiple
cells (removing the grid lines) but otherwise no


Regards,

Peo Sjoblom

"Mike D." wrote:

Hi. I know how to apply a hyperlink to the full contents within a cell. How
do I go about inserting a hyperlink within a cell. For instance, if the cell
contents were "Click here to go to the Engineering web page", I would like to
have "Click here" contain the hyperlink.

Thanks,
Mike.


Dave Peterson

You could cheat.

If you inserted the link via Insert|Hyperlink...

Select the cell
format|style...
Change it to normal
in the formula bar, select the "click here" text.
Format|cells
Underline, and a nice shade of blue

It'll look kind of ok.

(But the user can click anywhere in that cell.)


Mike D. wrote:

Hi. I know how to apply a hyperlink to the full contents within a cell. How
do I go about inserting a hyperlink within a cell. For instance, if the cell
contents were "Click here to go to the Engineering web page", I would like to
have "Click here" contain the hyperlink.

Thanks,
Mike.


--

Dave Peterson


All times are GMT +1. The time now is 01:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com