Okuqukethwe
Izolo kumarathon 30 Excel isebenza ngezinsuku ezingama-30 senze umbhalo esikhundleni sisebenzisa umsebenzi I-SUBSTITUTE (SUBSTITUTE) futhi wenza imibiko eguquguqukayo ngayo.
Ngosuku lwama-28 lwemarathon, sizofunda umsebenzi I-HYPERLINK (HYPERLINK). Esikhundleni sokuzenzela ama-hyperlink usebenzisa umyalo we-Excel Ribbon wegama elifanayo, ungasebenzisa lesi sici.
Ngakho ake singene emininingwaneni yomsebenzi I-HYPERLINK (HYPERLINK) nezibonelo zokusetshenziswa kwayo. Uma unolwazi olwengeziwe noma izibonelo, sicela wabelane ngazo kumazwana.
Isici 28: HYPERLINK
Umsebenzi I-HYPERLINK (HYPERLINK) idala isixhumanisi esivula idokhumenti egcinwe kukhompuyutha, iseva yenethiwekhi, inethiwekhi yendawo, noma i-inthanethi.
Ngingawusebenzisa kanjani umsebenzi we-HYPERLINK?
Umsebenzi I-HYPERLINK (HYPERLINK) ikuvumela ukuthi uvule amadokhumenti noma uzulazule uye ezindaweni ezithile kudokhumenti. Ngayo ungakwazi:
- Dala isixhumanisi esizulazulela endaweni ethile kufayela elifanayo.
- Dala isixhumanisi kudokhumenti ye-Excel kufolda efanayo.
- Dala isixhumanisi kuwebhusayithi.
I-syntax HYPERLINK
Umsebenzi I-HYPERLINK (HYPERLINK) ine-syntax elandelayo:
HYPERLINK(link_location,friendly_name)
ГИПЕРССЫЛКА(адрес;имя)
- indawo_yesixhumanisi (ikheli) – Uchungechunge lombhalo olucacisa indawo yendawo oyifunayo noma idokhumenti.
- igama_elinobungane (igama) umbhalo ozovezwa kuseli.
I-HYPERLINK Izingibe
Uma ungenaso isiqiniseko sokuthi ungakha ireferensi efanele yomsebenzi I-HYPERLINK (HYPERLINK), ifake ngesandla usebenzisa umyalo I-Hyperlink (Hyperlink), etholakala kuthebhu Faka Amaribhoni e-Excel. Ngale ndlela uzofunda i-syntax efanele, oyiphindayo lapho uphikisana khona indawo_yesixhumanisi (ikheli).
Isibonelo 1: Ibhekisela ngendawo kufayela elifanayo
Kunezindlela eziningana ezihlukene zokwenza iyunithi yezinhlamvu yombhalo yengxabano indawo_yesixhumanisi (ikheli). Esibonelweni sokuqala, umsebenzi ADDRESS (ADDRESS) ibuyisela ikheli lomugqa wokuqala nekholomu yokuqala ekhasini lokusebenzela eligama lalo lishiwo kuseli B3.
uphawu # (uphawu lwephawundi) ekuqaleni kwekheli kukhombisa ukuthi indawo ikufayela lamanje.
=HYPERLINK("#"&ADDRESS(1,1,,,B3),D3)
=ГИПЕРССЫЛКА("#"&АДРЕС(1;1;;;B3);D3)
Futhi, ungasebenzisa opharetha & (ukuhlanganisa) ukuvala ikheli lesixhumanisi. Lapha igama leshidi likuseli B5 futhi ikheli leseli liku-C5.
=HYPERLINK("#"&"'"&B5&"'!"&C5,D5)
=ГИПЕРССЫЛКА("#"&"'"&B5&"'!"&C5;D5)
Ukuze ubhekisele kububanzi obuqanjiwe encwadini yokusebenzela ye-Excel efanayo, vele unikeze igama lobubanzi njengempikiswano indawo_yesixhumanisi (ikheli).
=HYPERLINK("#"&D7,D7)
=ГИПЕРССЫЛКА("#"&D7;D7)
Isibonelo sesi-2: Ireferensi yefayela le-Excel kufolda efanayo
Ukwakha isixhumanisi kwelinye ifayela le-Excel kufolda efanayo, vele usebenzise igama lefayela njengengxabano indawo_yesixhumanisi (ikheli) emsebenzini I-HYPERLINK (HYPERLINK).
Ukuze ucacise indlela eya efayelini enezinga elilodwa noma ngaphezulu ngaphezulu kuhlelo, sebenzisa ongqi kanye ne-backslash (..) kuleveli ngayinye.
=HYPERLINK(C3,D3)
=ГИПЕРССЫЛКА(C3;D3)
Isibonelo sesi-3: Ukuxhumanisa newebhusayithi
Ukusebenzisa imisebenzi I-HYPERLINK (HYPERLINK) Ungaxhuma emakhasini kumawebhusayithi. Kulesi sibonelo, isixhumanisi sesayithi sihlanganiswa kusukela kuyunithi yezinhlamvu zombhalo, futhi igama lesayithi lisetshenziswa njengevelu ye-agumenti. igama_elinobungane (igama).
=HYPERLINK("http://www." &B3 & ".com",B3)
=ГИПЕРССЫЛКА("http://www."&B3&".com";B3)