假设您的工作表中有多个网址，但它们没有链接，现在您需要将所有未链接的网址转换为可点击的超链接，如下图所示。 当然，您可以一个一个地点击它们以使它们可点击，但是如果有很多网址，这将非常耗时。 你怎么能在Excel中自动将多个未链接的URL转换为可点击的超链接？
您订购的 Kutools for Excel“ 转换超链接 实用程序可以帮助您快速从超链接中提取实际的url地址，并将多个纯文本转换为超链接。
Kutools for Excel：比200方便的Excel加载项，可以在60天免费试用。 下载并免费试用现在！
2。 按住 ALT + F11 键打开 Microsoft Visual Basic for Applications 窗口。
3。 点击 插页 > 模块，并将以下代码粘贴到模块窗口中。
Sub ConvertToHyperlinks() 'Updateby20140318 Dim Rng As Range Dim WorkRng As Range On Error Resume Next xTitleId = "KutoolsforExcel" Set WorkRng = Application.Selection Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8) For Each Rng In WorkRng Application.ActiveSheet.Hyperlinks.Add Rng, Rng.Value Next End Sub
4。 然后按 F5 键运行代码，弹出对话框供您选择范围，然后单击 OK，并且选定的未链接的网址已转换为可点击的超链接。 查看屏幕截图：
您订购的 Kutools for Excel's 删除超链接 功能，您可以根据需要从所选范围，工作表或整个工作簿中删除所有超链接。
也许，VBA代码对你来说有些困难，在这里，我可以向你介绍一个多功能工具 - Kutools for Excel，其 转换超链接 功能，您可以快速处理以下操作：
|Kutools for Excel : 与超过300方便的Excel加载项，在60天免费试用没有限制.|
如果你已经安装 Kutools for Excel请按照以下步骤进行：
2。 点击 Kutools > 链接 > 转换超链接，看截图：
3。 在 转换超链接 对话框中选择 单元格内容替换超链接地址和点击 按钮 结果范围 指定一个单元格来放置结果。
4。 然后点击 OK，所有选定的纯文本链接都已转换为可点击的超链接。 看截图：
1。 如果你想把实际地址放在原来的范围内，请检查 转换源范围.
2。 如果超链接与当前文档链接，请检查 超链接是本文档中的一个地方 选项。
点击 转换超链接 了解更多关于这个功能。
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 months agoOh crap.... it broke my Excel. By mistake I selected entire column and it forze for... ages!!
To post as a guest, your comment is unpublished.· 10 months agohi
when i click on the hyperlink .. it wont take to me to email page ( as an Outlook or Gmail) Please support
To post as a guest, your comment is unpublished.· 10 months agoHello, Babu,
May be the below article can help you for solving your problem, please view it:
Hope it can help you!
To post as a guest, your comment is unpublished.· 10 months agoI had to switch nearly 55,000 cells from plain text to hyperlinks. This helped me cut the time down from "the rest of my natural life" to five minutes. Thank you!
To post as a guest, your comment is unpublished.· 11 months agoThis is very helpful...Thanks
To post as a guest, your comment is unpublished.· 1 years agoThis is Great! Worked like a charm
To post as a guest, your comment is unpublished.· 3 years agoMan! This is so awesome, I've spent so long trying to find an easy way and this took seconds! Works great!!!
To post as a guest, your comment is unpublished.· 3 years agoThanks a lot my friend! it worked! :lol:
To post as a guest, your comment is unpublished.· 3 years agoThe code almost works, but author has left a small copy-paste error.
You need to remove "" from the first line, and "" from the last line, and then it will work.
To post as a guest, your comment is unpublished.· 4 years agoI wanted to do something slightly different - create words with hyperlinks to add into a website via a WYSIWYG (rather than HTML coding the whole thing)
If you have good typing hands try:
Command "C" the hyperlink > click to cell you want to link...
Command "K" & paste Command "V" with text you want to hyperlink
Repeat x n
To post as a guest, your comment is unpublished.· 4 years agoI do not know if it's just me or if perhaps everyone else experiencing problems with your website.
It appears as if some of the text within your posts are running
off the screen. Can someone else please comment and let me know
if this is happening to them as well? This could be a issue with my web browser
because I've had this happen previously. Kudos
Feel free to visit my web site [url=http://culinotests.fr/news/vider-un-poulet-pour-la-premiere-fois]http://culinotests.fr/news/vider-un-poulet-pour-la-premiere-fois[/url]
To post as a guest, your comment is unpublished.· 4 years agogreat job my friend!!!!!!! too good
To post as a guest, your comment is unpublished.· 5 years agoWhy did you change it? This was a simple easy routine that worked every time. Now it is much larger and crashes Excel.
To post as a guest, your comment is unpublished.· 5 years agoyou are great!!!
Thanks a lot thank you thank you thank you!!!!! :lol: :D :-)