Share via

Excel cell hyperlink cannot be clicked

shen he 0 Reputation points
2026-04-04T03:36:06.4466667+00:00

我复制黏贴到excel表格上的一些超链接，，有些可以，有些不可以，怎么办，我的记录行数比较多，无法实现一个个去重新复制

Microsoft 365 and Office | Excel | Other | Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. EmilyS726 234.5K Reputation points Independent Advisor
    2026-04-04T15:00:25.9333333+00:00

    在另一列中，使用 HYPERLINK() 公式，将这些 URL 转换为可点击的链接。例如，如果 URL 位于单元格 A1，则可以使用 =HYPERLINK(A1)。

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.