Excel小技巧
如果有Excel中既提供有网站名称，也提供有网址，如何快速的、批量的创建超级链接呢？
用hyperlink函数就可以了。
C:\Documents and Settings\Shane Devenshire\My Documents\
You could enter that in A1 for example and then if you had a list of all the filenames in B1:B5000 you could enter the formula
=HYPERLINK(A$1&B1,B1)
in C1 and copy it down.
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024