這是EXCEL2010版本，請問點選後要如何指定到文字的欄位上?

另以函數解，請於任一儲存格輸入以下公式後，按住CTRL+SHIFT+ENTER鍵後，往右填滿，供參!
=HYPERLINK("#A"&SMALL(IF($A$1:$A$1000<>"",ROW($A$1:$A$1000),4^8),COLUMN(A1)),INDEX($A:$A,SMALL(IF($A$1:$A$1000<>"",ROW($A$1:$A$1000),4^8),COLUMN(A1)))&"")

使用巨集把A欄的標題加到第一列並加上超連結....試試
Sub 超連結()
Rows("1:1").ClearContents
Chs = ActiveSheet.Name
k = 4
For i = 2 To [A1048576].End(3).Row
Rng = Cells(i, 1)
If Rng > "" Then
ActiveSheet.Hyperlinks.Add Anchor:=Cells(1, k), Address:="", SubAddress:= _
Chs & "!A" & i, TextToDisplay:=Rng
k = k + 1
End If
Next
End Sub