如何将一列文本 URL 转换为 Excel 中的活动超链接? [英] How do I convert a column of text URLs into active hyperlinks in Excel?

问题描述

我在 excel 中有一个列，其中包含所有网站 url 值.我的问题是我想将 url 值转换为活动链接.该列中大约有 200 个条目，所有单元格中都有不同的 url.有没有一种方法可以在不编写宏的情况下创建指向所有单元格的活动超链接.

I have a column in excel, wherein I have all the website url values. My question is I want to turn the url values to active links. There are about 200 entries in that column with different urls in all cells. Is there a way I can create active hyperlinks to all the cells without writing a macro.

推荐答案

如果您不想制作宏并且不介意额外的列，那么只需在您的列旁边创建一个新列网址.

If you don't want to make a macro and as long as you don't mind an additional column, then just create a new column alongside your column of URLs.

在公式中的新列类型=HYPERLINK(A1)(用您感兴趣的任何单元格替换A1).然后将公式复制到其余 200 个条目中.

In the new column type in the formula =HYPERLINK(A1) (replacing A1 with whatever cell you are interested in). Then copy the formula down the rest of the 200 entries.

注意:如果单元格 A1 包含长度超过 255 个字符的字符串，则此解决方案不起作用.它会导致 #VALUE! 错误

NOTE: This solution does not work if the cell A1 contains a string longer than 255 characters. It results in a #VALUE! error

这篇关于如何将一列文本 URL 转换为 Excel 中的活动超链接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！