Excel中的自动超链接 [英] Automatic hyperlinking in Excel

问题描述

我正在生成一个csv文件，该文件具有指向特定文件的链接.看起来像:

I am generating a csv file which has the link to specific files. It looks like:

D:\ abc，D:\ xxx ..
D:\ fgt \ a.txt，D:\ yxz ..
.

D:\abc,D:\xxx..
D:\fgt\a.txt, D:\yxz..
.
.

现在在excel中打开此文件时，我想将它们转换为超链接，以便用户单击它们，并打开相应的文件或文件夹. 有什么办法可以使Excel将其标识为链接并使它们可单击的链接.在excel中执行一个简单的一两个步骤就可以做到这一点?

Now when opening this in excel I want to make these get converted into hyperlinks so that the user clicks them and the corresponding file or folder opens up. Is there any way I can make the excel identify it as links and make them clickable links. A simple one or two steps in excel which would do this?

谢谢...

推荐答案

在Excel中使用HYPERLINK()工作表功能.如果您生成的链接在A列中，请插入新列(B列)，并将以下公式放在单元格B1中:

Use the HYPERLINK() worksheet function in Excel. If your generated links are in column A, insert a new column (column B) and place the following formula in cell B1:

=HYPERLINK(A1)

然后只需在B列中填写该公式即可.

Then simply fill down that formula in column B.

这篇关于Excel中的自动超链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！