30 Excel i nā lā 30: HYPERLINK

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.

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.

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.

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.

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)

30 Excel i nā lā 30: HYPERLINK

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)

30 Excel i nā lā 30: HYPERLINK

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)

30 Excel i nā lā 30: HYPERLINK

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)

30 Excel i nā lā 30: HYPERLINK

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)

30 Excel i nā lā 30: HYPERLINK

Waiho i ka Reply