答案1
首先正常粘贴。然后选择粘贴的块并运行这个简短的宏:
Sub HyperFixer()
Dim h As Hyperlink
Dim rng As Range
For Each h In ActiveSheet.Hyperlinks
Set rng = h.Range
If Not Intersect(rng, Selection) Is Nothing Then
h.TextToDisplay = h.Address
End If
Next h
End Sub
每个超链接的“友好”名称将被更改以反映实际情况网址。