ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Apply Hyperlink to Text in Cell (https://www.excelbanter.com/excel-discussion-misc-queries/65916-apply-hyperlink-text-cell.html)

Elaine

Apply Hyperlink to Text in Cell
 
Can you create a hyperlink on a portion of text in a cell? I have tried to do
this in the Edit mode and the hyperlink button is "grayed" out. I'm using
Excel 2003
--
Thank you... Elaine

Dave Peterson

Apply Hyperlink to Text in Cell
 
The cell is a hyperlink or not a hyperlink.

One trick is to put a rectangle over the text you want (hide the borders) and
assign the hyperlink to that rectangle. You may be able to format the text
under the rectangle so that it looks like a hyperlink.

Elaine wrote:

Can you create a hyperlink on a portion of text in a cell? I have tried to do
this in the Edit mode and the hyperlink button is "grayed" out. I'm using
Excel 2003
--
Thank you... Elaine


--

Dave Peterson


All times are GMT +1. The time now is 06:17 AM.

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