blocks|key|544131|text|这在Excel中是不可能的。超链接与整个细胞相关联。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|544132|如果您查看Excel超链接对象的文档，您可以看到它与一个范围相关联。如果可以将超链接与单元格内的span相关联，则超链接对象需要有关联的范围和人物对象。|offset|length|544133|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/bb242296%2528v=office.12%2529.aspx|1|http://msdn.microsoft.com/en-us/library/bb255882%2528v=office.12%2529.aspx^0|0|5|D|0|1Z|2|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]|$D|U|E|V|1|W]]|A|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]|N|$5|I|J|K|A|$L|O]]]]

This isn't possible in Excel. Hyperlinks are associated with entire cells.

If you look at the <a href="http://msdn.microsoft.com/en-us/library/bb242296%28v=office.12%29.aspx" rel="nofollow">documentation for the Excel hyperlink object</a>, you can see that it's associated with a Range. If it were possible to associate hyperlinks with a span within the cell, the Hyperlink object would need to have an associated Range and <a href="http://msdn.microsoft.com/en-us/library/bb255882%28v=office.12%29.aspx" rel="nofollow">Characters</a> object.

blocks|key|544157|text|在创建超链接之后，您可以在单元格中格式化文本，以便只有感兴趣的单词带有下划线/蓝色。超链接仍然可以工作，但显然每个单元格只能有一个链接，单击文本中的任何位置都会触发超链接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|544158|例如：|544159|​|544160|📷|atomic|offset|length|544161|544162|Sub+Tester()

++++Dim+rng+As+Range

++++Set+rng+=+ActiveSheet.Range("A1")

++++rng.Parent.Hyperlinks.Add+Anchor:=rng,+Address:="",+SubAddress:=+_
++++++++"Sheet1!A10",+TextToDisplay:="this+is+long+text"

++++With+rng.Font
++++++++.ColorIndex+=+xlAutomatic
++++++++.Underline+=+xlUnderlineStyleNone
++++End+With

++++With+rng.Characters(Start:=9,+Length:=4).Font
++++++++.Underline+=+xlUnderlineStyleSingle
++++++++.Color+=+-4165632
++++End+With

End+Sub|code-block|syntax|javascript|544163|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/9bb8f46c19b0db2feaa05ed1119d0369.png|imageAlt^0|0|0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|12|8|@]|9|@$I|13|J|14|1|15]]|A|$]]|$1|K|3|E|5|6|7|16|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|17|8|@]|9|@]|A|$O|P]]|$1|Q|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X|Y|-4]]]]

After creating the hyperlink you could format the text in the cell so that only the words of interest are underlined/blue. The hyperlink will still work, but obviously you can still have only one link per cell, and clicking anywhere in the text will trigger the hyperlink.

For example:

<img src="https://i.stack.imgur.com/yc3BM.png" alt="enter image description here">

<pre><code>Sub Tester()

 Dim rng As Range

 Set rng = ActiveSheet.Range("A1")

 rng.Parent.Hyperlinks.Add Anchor:=rng, Address:="", SubAddress:= _
 "Sheet1!A10", TextToDisplay:="this is long text"

 With rng.Font
 .ColorIndex = xlAutomatic
 .Underline = xlUnderlineStyleNone
 End With

 With rng.Characters(Start:=9, Length:=4).Font
 .Underline = xlUnderlineStyleSingle
 .Color = -4165632
 End With

End Sub
</code></pre>

blocks|key|624249|text|我需要链接到一个显示在单元格中的文件名，下面是对我有用的内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|624250|ActiveSheet.Hyperlinks.Add+Anchor:=Cells(row,+column),+Address:=file.Path,+TextToDisplay:=file.Path|code-block|syntax|javascript|624251|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I needed to link to a filename displayed in a cell, so here is what worked for me:

<pre><code>ActiveSheet.Hyperlinks.Add Anchor:=Cells(row, column), Address:=file.Path, TextToDisplay:=file.Path
</code></pre>

blocks|key|1102971|text|上面的一个班轮非常有用..。因为我是新来的，所以我不能评论。下面是我对以上内容的修改，它将工作表上的每一行都取下来，并从行上的值构建一个URL。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1102972|CHGRow+=+3
Worksheets("Page+1").Select
Cells(CHGRow,+1).Select

Do+Until+Application.CountA(ActiveCell.EntireRow)+=+0

++++URLVal+=+"https://our_url_here?some_parameter="+&+Cells(CHGRow,+cNumber)
++++URLText+=+Cells(CHGRow,+cNumber)
++++ActiveSheet.Hyperlinks.Add+Anchor:=Cells(CHGRow,+cURL),+Address:=URLVal,+TextToDisplay:=URLText

++++CHGRow+=+CHGRow+%2B+1
++++Cells(CHGRow,+1).Select

Loop|code-block|syntax|javascript|1102973|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The above one liner was very helpful... since I'm new, I couldn't comment. So here is my variation of the above that takes each row on a worksheet and builds a URL from a value on the row. 

<pre><code>CHGRow = 3
Worksheets("Page 1").Select
Cells(CHGRow, 1).Select

Do Until Application.CountA(ActiveCell.EntireRow) = 0

 URLVal = "https://our_url_here?some_parameter=" &amp; Cells(CHGRow, cNumber)
 URLText = Cells(CHGRow, cNumber)
 ActiveSheet.Hyperlinks.Add Anchor:=Cells(CHGRow, cURL), Address:=URLVal, TextToDisplay:=URLText

 CHGRow = CHGRow + 1
 Cells(CHGRow, 1).Select

Loop
</code></pre>

blocks|key|544206|text|我会把你的一行变成两行，把你需要的列中的单元格合并成一行，当你到达需要超链接的单元格时，把单词放在顶部的单元格上，然后把链接放在下面的单元格中。作为一种非技术的解决办法，它看起来会很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|544207|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I'd just make your one row into two rows, merge the cells in the columns you need to have it appear to be a single row and when you get to the cell that needs the hyperlink then you put the words on the top cell and the link in the cell below. It will look fine as a non-techy workaround.

blocks|key|624354|text|这里是一个非常好的解决方案，用于在Excel电子表格单元格中的较大文本块中创建超链接字符串。警告--如果工作表有多个编辑器，这是不可取的，因为超链接可能会与其单元格中的文本不对齐，除非您能够提供足够的保护。这个过程中描述了这样做的一种方法，但它可能限制贡献者可以做的事情：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|624355|在Excel电子表格中，假设您不试图保护所有单元格不受编辑，请选择工作表中的所有单元格，然后从“主功能区”中选择“格式单元格”或右键单击弹出菜单。在“保护”选项卡上，选中“锁定”复选框，以确保所有单元格都已解锁。|ordered-list-item|624356|现在选择包含链接的(第一个)单元格。|624357|复制(不要剪切)要显示为剪贴板链接的文本。|624358|单击电子表格中的任何位置(最好是未使用的区域)，然后使用形状图标下拉或文本图标从插入带状处插入文本框。大小和形状还不重要，只是近似于链接文本的大小。|624359|将剪贴板内容粘贴到文本框中。|624360|右键单击文本框并选择Link向其添加超链接，并指定链接目标，无论是当前文档中的位置还是URL。|624361|选择链接文本并格式化您希望链接出现的方式，例如蓝色、下划线等，因为在文本框中，这种情况显然不会像单元格中那样自动发生。|624362|再次右键单击文本框并选择“格式形状”。在“格式形状”面板中，执行以下操作，以使文本周围的形状合适，并消除空白和边框：
(a)在“填充和线”面板(第一个图标)上，选择“无行”选项。
(b)在Size+&+Properties面板(第3个图标)上，将所有4个边距设置为零(0.00")，取消选中"Wrap+in+shape“复选框，并选中”调整大小形状以适合文本“textbox”。
(c)在“财产”项下，确保选择以下内容：
*移动，但不要与细胞大小
*锁定
*锁文本|624363|如果需要在同一单元格内的多个单元格或位置中出现相同的超链接(即使目标不同)，则通过右键选择其(现在不可见)边框(警告--左键现在将带您到链接目标！)，将其复制到剪贴板，并按Ctrl%2BV按需要复制的次数，复制所有这些工作的文本框。|624364|右键单击文本框(如果您复制了文本框，则单击其中之一)并将其拖到要显示链接的单元格中，将其直接定位在与超链接匹配的原始文本上，以便在视觉上覆盖并替换它(原始文本用作为其腾出空间的间隔)。上文第8项所采取的步骤应防止它掩盖或剪裁原文周围的任何文字或标点符号。|624365|选择该单元格，然后从“主功能区”上的“格式”菜单中选择“锁定单元格”，以防止其内容与其隐藏的相应文本无意中更改和对齐文本框。|624366|对您创建的链接文本框的每个附加副本重复步骤10+&+11。如果其中任何一个需要不同的链接目标，只需右键单击文本框的副本，选择“编辑链接”，并更新目标。|624367|从“家庭彩带”的“格式”菜单中，选择“保护工作表”。选中标签为“保护工作表和锁定单元格的内容”的框。|624368|也检查该对话框中的所有其他框(假设您没有试图以任何方式限制用户)，但以下情况除外：
*格式单元格
*格式栏
*格式行
*编辑对象
保留这四个复选框未选中，以保护您的链接文本框不被选中、删除、移动或与其基础文本不对齐。(注意:如果添加、删除或调整行或列的大小，则它们应该已经与其基础单元格一起移动，但是如果没有这种保护，如果调整了它们自己的行或列的大小，它们仍然会受到影响。)|624369|如果您想要添加密码，请立即这样做。完成后，单击“确定”以应用保护。以后可以从“格式”菜单中选择“取消保护工作表”以执行任何必要的编辑，但如果链接单元格、列或行被编辑或调整大小，则如果链接文本框移动，则可能需要将链接文本框(Es)重新定位到基础文本上。|624370|测试您的超链接，如果您尝试编辑包含单元格或调整包含列或行的大小，以确保工作表已准备好共享，还会发生什么！|624371|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1B|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|1C|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|1D|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|1E|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|1F|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|1G|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|1H|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|1I|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|1J|8|@]|9|@]|A|$]]|$1|U|3|V|5|D|7|1K|8|@]|9|@]|A|$]]|$1|W|3|X|5|D|7|1L|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|D|7|1M|8|@]|9|@]|A|$]]|$1|10|3|11|5|D|7|1N|8|@]|9|@]|A|$]]|$1|12|3|13|5|D|7|1O|8|@]|9|@]|A|$]]|$1|14|3|15|5|D|7|1P|8|@]|9|@]|A|$]]|$1|16|3|17|5|D|7|1Q|8|@]|9|@]|A|$]]|$1|18|3|-4|5|6|7|1R|8|@]|9|@]|A|$]]]|19|$]]

Here's a great smoke-and-mirrors solution I've used for creating hyperlinked strings within a larger block of text in an Excel spreadsheet cell. CAUTION -- if there are multiple editors for your worksheet, this is not advisable as hyperlinks can get misaligned with the text in their cells unless you can provide sufficient protection. A means of doing that is described in this procedure though may limit what contributors can do:
<ol>
<li>In your Excel spreadsheet, assuming you are not trying to protect ALL cells from editing, select all cells in the worksheet, then select Format Cells from the Home ribbon or the right-click popup menu. On the Protection tab, check then uncheck the &quot;Locked&quot; checkbox to ensure all cells are unlocked.</li>
<li>Now select the (first) cell that will contain the link.</li>
<li>Copy (don't cut) the text that you want to appear as a link to the clipboard.</li>
<li>Click anywhere in your spreadsheet (an unused area is best) and insert a text box from the Insert ribbon using either the Shape icon dropdown or the Text icon. Size and shape aren't important yet, just approximate the size of the link text.</li>
<li>Paste the clipboard contents into the text box.</li>
<li>Right click the text box and select Link to add a hyperlink to it, and specify the link target, whether a location in the current document or a URL.</li>
<li>Select the link text and format it how you want your links to appear, e.g. blue, underlined, etc., since inside a text box this apparently does not occur automatically as in a cell.</li>
<li>Right click the text box again and select Format Shape. From the Format Shape panel, perform the following in order to properly fit the shape around the text and eliminate white space and border:
 (a) On the Fill &amp; Line panel (1st icon), select the No Line option.
 (b) On the Size &amp; Properties panel (3rd icon), set all 4 margins to zero (0.00&quot;), uncheck the &quot;Wrap text in shape&quot; checkbox, and check the &quot;Resize shape to fit text&quot; textbox.&quot;
 (c) Under Properties, ensure the following are selected:
 * Move but don't size with cells
 * Locked
 * Lock text</li>
<li>If you need the same hyperlink to occur in multiple cells or locations within the same cell (even if targets differ), clone the text box you did all this work on by selecting its (now invisible) border with a right click (warning - a left click will now take you to the link target instead!), copying it to the clipboard, and press Ctrl+V as many times as you need copies.</li>
<li>Right click on the text box (or one of them if you cloned it) and drag it to the cell where you want the link to appear, positioning it directly over the original text that matches your hyperlink, so as to visually cover it up and replace it (the original text serving as a spacer to make room for it). The steps taken in item 8 above should prevent it from covering up or clipping any text or punctuation surrounding the original text.</li>
<li>Select that cell, then from the Format menu on the Home ribbon, select &quot;Lock Cell&quot; to protect its contents from inadvertently changing and misaligning the text box with the corresponding text that its hiding.</li>
<li>Repeat steps 10 &amp; 11 for each additional copy of the linked text box you created. If any of them requires a different link target, simply right click that copy of the text box, select &quot;Edit Link&quot;, and update the target.</li>
<li>From the Format menu on the Home ribbon, select &quot;Protect Sheet&quot;. Check the box labelled &quot;Protect worksheet and contents of locked cells&quot;.</li>
<li>Check all the other boxes in that dialog also (assuming you are not trying to restrict users in any of those ways) except for the following:
 * Format cells
 * Format columns
 * Format rows
 * Edit objects
 Leave these four checkboxes unchecked so as to protect your linked text boxes from being selected, deleted, moved, or misaligned with their underlying text. (Note: They should already move with their underlying cells if rows or columns are added, removed or resized, but without this protection they can still be impacted if their own row or column is resized.)</li>
<li>If you want to add a password, do so now. When finished, click OK to apply protection. You can selected &quot;Unprotect Sheet&quot; from the Format menu later to perform any necessary editing, but if the link cell(s), column(s) or row(s) are edited or resized, you may need to reposition the link text box(es) over the underlying text if it moved.</li>
<li>Test your hyperlink(s) and also what happens if you try editing the containing cell(s) or resizing the containing column(s) or row(s) to be sure the worksheet is ready for sharing!</li>
</ol>

Is it possible to create a hyperlink within an Excel cell which only uses a section of the cell text for the clickable link? I.E. would the below table mockup represent something that can be easily built in Excel 2010?

<a href="http://dl.dropbox.com/u/14119404/misc/Microsoft%20Excel%20-%20Book1_2012-04-16_14-24-47.jpg" rel="nofollow noreferrer">a mock up http://dl.dropbox.com/u/14119404/misc/Microsoft%20Excel%20-%20Book1_2012-04-16_14-24-47.jpg</a>

I know that an entire cell can be made into a hyperlink easily, but not a specific part of the cell as far as I know.

By hyperlink I also refer to either

<ul>
<li>(a)another cell or,</li>
<li>(b)a web URL.</li>
</ul>

Thanks

Create a hyperlink within an Excel cell?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

是否可以在Excel单元格内创建超链接，该单元格仅使用单元格文本的一段作为可单击链接？例如，下表模型是否代表可以在Excel 2010中轻松构建的东西？据我所知，一个完整的细胞可以很容易地变成一个超链接，但据我所知，它并不是细胞的一个特定部分。通过超链接，我也提到了(A)另一间牢房或，(B)网页网址。谢谢

问在Excel单元格中创建超链接？
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Excel单元格中创建超链接？EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Excel单元格中创建超链接？
EN