Excel
涓殑鎵归噺瓒呴摼鎺ュ垱寤轰笌鎵归噺瓒呴摼鎺ュ垹闄?/p>
鍏抽敭璇嶏細
HyperLink
璇?/p>
娉曪細
HYPERLINK(link_location,
friendly_name)
Friendly_name
鍙互鐪佺暐锛岃繖鏍峰氨鍙樻垚浜?/p>
HYPERLINK(link_location)
銆?/p>
鍏蜂綋濡備笅锛?/p>
瓒呴摼鎺ユ壒閲忓垱寤?/p>
1.
灏嗚〃鏍间腑鐨勫涓崟鍏冩牸閾炬帴鍒扮數鑴戜腑鐨勫悓鍚嶆枃浠?/p>
鐘跺喌
1
锛?/p>
Excel
涓庨摼鎺ョ殑鏂囦欢鍦ㄥ悓涓�鏂囦欢澶广�傚苟鍋囪鏂囦欢澶逛笅鏈?/p>
N
寮犲浘鐗囥�傚湪
Excel
涓緭鍏?/p>
鍥剧墖鍚嶅瓧銆傚
A1:
鍥剧墖
1
锛?/p>
A2
锛氬浘鐗?/p>
2
锛?/p>
A3:
鍥剧墖
3
锛屸�︹�?/p>
鍦?/p>
B1
涓緭鍏ワ細
=HYPERLINK(A1&".JPG")
璇存槑锛?/p>
鈥滐紳鈥濇槸鍏紡鐨勫紑澶达紝
HYPERLINK
鏃㈣秴閾炬帴鍏紡
鍏抽敭灏卞湪鎷彿涓簡銆?/p>
鎷彿涓渷鐣ヤ簡
friendly_name
锛?/p>
浠�涔?/p>
friendly_name
锛燂紝
绛変笅鍐嶄綔浠嬬粛銆?/p>
鎷彿涓殑灏辨槸璇硶涓殑鈥?/p>
link_location
鈥濋」锛屼竴鑸槸鏂囦欢鐨勫湴鍧�鍚嶏紝濡傛灉
Excel
琛ㄦ牸鍜岄摼鎺ョ殑鏂?/p>
浠跺湪涓�涓洰褰曚笅鍙敤鍐欐枃浠跺悕灏卞ソ
(
璺汉鐢诧細鎷彿閲岀殑涓滆タ闀垮緱濂芥�晩锛岀湅涓嶅嚭鏉ユ槸鏂囦欢鍚嶅晩
)
銆?/p>
OK
锛屽埆鎬ャ�傛槸杩欐牱鐨勶紝鍥犱负鏂囦欢鍚嶇敤
A1
鍗曞厓鏍煎幓鍙栦唬浜嗭細
A1
鍏跺疄鏄紩鐢ㄥ崟鍏冩牸
A1
涓殑
鈥滃浘鐗?/p>
1
鈥?/p>
锛岀鍙?/p>
&
鏄繛鎺ョ锛岀敤浜庤繛鎺モ�?/p>
A1
鈥濇墍鎸囦唬鐨勨�滃浘鐗?/p>
1
鈥濅笌鈥?/p>
.JPG
鈥濆瓧绗︿覆銆?/p>
.JPG
鏄?/p>
J
PG
鍥剧墖鐨勫悗缂�
(
鍦扮悆浜洪兘鐭ラ亾
)
锛岀敤浠�涔堣鐢ㄥ弻寮曞彿寮曡捣鏉ュ憿锛熻繖鏄叕寮忕殑鏍煎紡鍟︼紝鍦?/p>
()
涓殑椤圭洰
鐨勪换浣曞瓧绗﹂兘瑕佺敤鑻辨枃鐘舵�佷笅鐨勨�溾�濆紩璧锋潵銆傛垜浠彲浠ユ寜瑙勫垯灞曞紑锛岀敤
A1
鐨勫疄闄呭唴瀹光�斺�斿浘鐗?/p>
1
锛屾浛浠?/p>
A1
锛屽幓鎺夐摼鎺ョ锛屽幓鎺夊弻寮曞彿锛屼綘鐪嬪埌浜嗕粈涔堬紵瀵逛簡锛屽氨鏄枃浠剁湡瀹炵殑鍚嶅瓧锛氬浘鐗?/p>
1.J