Contents
I nehinei i ka marathon 30 mau hana Excel i 30 mau lā Ua hana mākou i ka hoʻololi kikokikona me ka hoʻohana ʻana i ka hana PALAPALA (SUBSTITUTE) a hana i nā hōʻike maʻalahi me ia.
Ma ka lā 28 o ka marathon, e aʻo mākou i ka hana HYPERLINK (HYPERLINK). Ma kahi o ka hana lima ʻana i nā loulou me ka hoʻohana ʻana i ke kauoha Ribbon Excel o ka inoa like, hiki iā ʻoe ke hoʻohana i kēia hiʻohiʻona.
No laila, e komo kākou i nā kiko'ī o ka hana HYPERLINK (HYPERLINK) a me nā laʻana o kona hoʻohana. Inā loaʻa iā ʻoe nā ʻike hou a i ʻole nā hiʻohiʻona, e ʻoluʻolu e kaʻana iā lākou i nā manaʻo.
Hiʻona 28: HYPERLINK
Launch HYPERLINK (HYPERLINK) hana i kahi loulou e wehe i kahi palapala i mālama ʻia ma kahi kamepiula, kikowaena pūnaewele, pūnaewele kūloko, a i ʻole ka Pūnaewele.
Pehea e hiki ai iaʻu ke hoʻohana i ka hana HYPERLINK?
Launch HYPERLINK (HYPERLINK) hiki iā ʻoe ke wehe i nā palapala a i ʻole ke hoʻokele i nā wahi kikoʻī ma kahi palapala. Me ia hiki iā ʻoe ke:
- E hana i loulou e hoʻokele ana i kahi kikoʻī ma ka faila hoʻokahi.
- E hana i loulou i kahi palapala Excel ma ka waihona like.
- E hana i loulou i kahi pūnaewele.
Hua'ōlelo HYPERLINK
Launch HYPERLINK (HYPERLINK) loaʻa kēia syntax:
HYPERLINK(link_location,friendly_name)
ГИПЕРССЫЛКА(адрес;имя)
- loulou_wahi (address) – He kaula kikokikona e kuhikuhi ana i kahi o ka wahi a i ole palapala paha.
- inoa_aloha ʻO (inoa) ka kikokikona e hōʻike ʻia ma ke kelepona.
HYPERLINK Piha
Inā ʻaʻole maopopo ʻoe hiki iā ʻoe ke hana i ka kuhikuhi kūpono no kahi hana HYPERLINK (HYPERLINK), e hookomo me ka lima me ke kauoha Hynithon (Hyperlink), aia ma ka pā hookomo Nā lipine Excel. Ma kēia ala e aʻo ai ʻoe i ka syntax kūpono, a laila e hana hou no ka hoʻopaʻapaʻa loulou_wahi (heluhelu).
Laʻana 1: Ke kuhikuhi ʻana i kahi wahi ma ka faila hoʻokahi
Nui nā ala like ʻole e hana ai i ke kaula kikokikona no ka hoʻopaʻapaʻa loulou_wahi (heluhelu). I ka laʻana mua, ka hana ADDRESS (ADDRESS) hoʻihoʻi i ka helu wahi no ka lālani mua a me ke kolamu mua ma ka pepa haʻawina nona ka inoa i kuhikuhi ʻia ma ke kelepona B3.
hōʻailona # (hōʻailona paona) ma ka hoʻomaka o ka helu wahi e hōʻike ana aia ka wahi i ka faila o kēia manawa.
=HYPERLINK("#"&ADDRESS(1,1,,,B3),D3)
=ГИПЕРССЫЛКА("#"&АДРЕС(1;1;;;B3);D3)
Eia kekahi, hiki iā ʻoe ke hoʻohana i ka mea hoʻohana & (concatenation) e makapō i ka helu loulou. Aia ka inoa pepa ma ke kelepona B5 a aia ka helu kelepona ma C5.
=HYPERLINK("#"&"'"&B5&"'!"&C5,D5)
=ГИПЕРССЫЛКА("#"&"'"&B5&"'!"&C5;D5)
No ke kuhikuhi ʻana i kahi ʻano i kapa ʻia i loko o ka puke haʻawina Excel hoʻokahi, e hāʻawi wale i ka inoa laulā ma ke ʻano he hoʻopaʻapaʻa loulou_wahi (heluhelu).
=HYPERLINK("#"&D7,D7)
=ГИПЕРССЫЛКА("#"&D7;D7)
Laʻana 2: Ke kuhikuhi ʻana i kahi faila Excel ma ka waihona like
No ka hana ʻana i kahi loulou i kahi faila Excel ʻē aʻe i loko o ka waihona like, e hoʻohana wale i ka inoa file ma ke ʻano he hoʻopaʻapaʻa loulou_wahi (address) in function HYPERLINK (HYPERLINK).
No ke kuhikuhi ʻana i ke ala i kahi faila i hoʻokahi a ʻoi aʻe paha nā pae kiʻekiʻe ma ka hierarchy, e hoʻohana i ʻelua manawa a me kahi kī hope (..) no kēlā me kēia pae.
=HYPERLINK(C3,D3)
=ГИПЕРССЫЛКА(C3;D3)
Laʻana 3: Hoʻopili i kahi pūnaewele
Ke hoʻohana nei i nā hana HYPERLINK (HYPERLINK) Hiki iā ʻoe ke loulou i nā ʻaoʻao ma nā pūnaewele. Ma kēia laʻana, ua ʻākoakoa ʻia ka loulou pūnaewele mai nā kaula kikokikona, a ua hoʻohana ʻia ka inoa pūnaewele ma ke ʻano he kumu hoʻopaʻapaʻa. inoa_aloha (inoa).
=HYPERLINK("http://www." &B3 & ".com",B3)
=ГИПЕРССЫЛКА("http://www."&B3&".com";B3)