Imisebenzi engama-30 ye-Excel ezinsukwini ezingama-30: HYPERLINK

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.

Umsebenzi I-HYPERLINK (HYPERLINK) idala isixhumanisi esivula idokhumenti egcinwe kukhompuyutha, iseva yenethiwekhi, inethiwekhi yendawo, noma i-inthanethi.

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.

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.

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)

Imisebenzi engama-30 ye-Excel ezinsukwini ezingama-30: HYPERLINK

Futhi, ungasebenzisa opharetha & (ukuhlanganisa) ukuvala ikheli lesixhumanisi. Lapha igama leshidi likuseli B5 futhi ikheli leseli liku-C5.

=HYPERLINK("#"&"'"&B5&"'!"&C5,D5)

=ГИПЕРССЫЛКА("#"&"'"&B5&"'!"&C5;D5)

Imisebenzi engama-30 ye-Excel ezinsukwini ezingama-30: HYPERLINK

Ukuze ubhekisele kububanzi obuqanjiwe encwadini yokusebenzela ye-Excel efanayo, vele unikeze igama lobubanzi njengempikiswano indawo_yesixhumanisi (ikheli).

=HYPERLINK("#"&D7,D7)

=ГИПЕРССЫЛКА("#"&D7;D7)

Imisebenzi engama-30 ye-Excel ezinsukwini ezingama-30: HYPERLINK

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)

Imisebenzi engama-30 ye-Excel ezinsukwini ezingama-30: HYPERLINK

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)

Imisebenzi engama-30 ye-Excel ezinsukwini ezingama-30: HYPERLINK

shiya impendulo