Zamkatimu
Dzulo pa marathon 30 Excel imagwira ntchito m'masiku 30 tinasintha malemba pogwiritsa ntchito ntchitoyi WOLEMBEDWA (SUBSTITUTE) ndipo adapanga malipoti osinthika nawo.
Pa tsiku la 28 la marathon, tidzaphunzira ntchitoyi HYPERLINK (HYPERLINK). M'malo mopanga ma hyperlink pogwiritsa ntchito lamulo la Excel Ribbon la dzina lomwelo, mutha kugwiritsa ntchito izi.
Ndiye tiyeni tilowe mu tsatanetsatane wa ntchitoyi HYPERLINK (HYPERLINK) ndi zitsanzo zamagwiritsidwe ake. Ngati muli ndi zina zowonjezera kapena zitsanzo, chonde gawanani nawo mu ndemanga.
Gawo 28: HYPERLINK
ntchito HYPERLINK (HYPERLINK) imapanga ulalo womwe umatsegula chikalata chosungidwa pakompyuta, seva ya netiweki, netiweki yapafupi, kapena intaneti.
Kodi ndingagwiritse ntchito bwanji ntchito ya HYPERLINK?
ntchito HYPERLINK (HYPERLINK) imakulolani kuti mutsegule zikalata kapena kupita kumalo enaake mu chikalata. Ndi izo mukhoza:
- Pangani ulalo womwe umalowera kumalo enaake mufayilo yomweyi.
- Pangani ulalo ku chikalata cha Excel mufoda yomweyo.
- Pangani ulalo watsamba lanu.
Syntax HYPERLINK
ntchito HYPERLINK (HYPERLINK) ili ndi mawu awa:
HYPERLINK(link_location,friendly_name)
ГИПЕРССЫЛКА(адрес;имя)
- link_location (adiresi) - Chingwe cholemba chomwe chimafotokoza malo omwe mukufuna kapena chikalata.
- friendly_name (dzina) ndiye mawu omwe aziwonetsedwa mu cell.
HYPERLINK Zowopsa
Ngati simukutsimikiza kuti mutha kupanga zolemba zolondola za ntchito HYPERLINK (HYPERLINK), ikani pamanja pogwiritsa ntchito lamulo Hyperlink (Hyperlink), yomwe ili pa tabu Ikani Ma riboni a Excel. Mwanjira iyi muphunzira mawu olondola, omwe mumabwereza mkanganowo link_location (adilesi).
Chitsanzo 1: Kulozera malo omwe ali mufayilo yomweyo
Pali njira zingapo zopangira chingwe chamawu kuti mkangano link_location (adilesi). Mu chitsanzo choyamba, ntchito ADDRESS (ADDRESS) imabweretsanso adilesi ya mzere woyamba ndi gawo loyamba latsamba lomwe dzina lake latchulidwa mu selo B3.
chizindikiro # (chizindikiro cha mapaundi) kumayambiriro kwa adilesi ikuwonetsa kuti malo ali mufayilo yomwe ilipo.
=HYPERLINK("#"&ADDRESS(1,1,,,B3),D3)
=ГИПЕРССЫЛКА("#"&АДРЕС(1;1;;;B3);D3)
Komanso, mungagwiritse ntchito opareshoni & (concatenation) kuchititsa khungu ulalo adilesi. Apa dzina lachitsamba lili mu selo B5 ndipo adilesi ya selo ili mu C5.
=HYPERLINK("#"&"'"&B5&"'!"&C5,D5)
=ГИПЕРССЫЛКА("#"&"'"&B5&"'!"&C5;D5)
Kuti mutchule mtundu womwe watchulidwa mu buku lomwelo la Excel, ingoperekani dzina lamtunduwu ngati mkangano link_location (adilesi).
=HYPERLINK("#"&D7,D7)
=ГИПЕРССЫЛКА("#"&D7;D7)
Chitsanzo 2: Kuwonetsa fayilo ya Excel mufoda yomweyo
Kuti mupange ulalo ku fayilo ina ya Excel mufoda yomweyo, ingogwiritsani ntchito dzina la fayilo ngati mkangano link_location (adilesi) mu ntchito HYPERLINK (HYPERLINK).
Kuti mufotokoze njira yopita ku fayilo yomwe ili mulingo umodzi kapena kuposerapo mu utsogoleri, gwiritsani ntchito nthawi ziwiri ndi kubwereranso (..) pamlingo uliwonse.
=HYPERLINK(C3,D3)
=ГИПЕРССЫЛКА(C3;D3)
Chitsanzo 3: Kulumikizana ndi tsamba la webusayiti
Kugwiritsa ntchito HYPERLINK (HYPERLINK) Mutha kulumikiza masamba pamasamba. Muchitsanzo ichi, ulalo watsamba umasonkhanitsidwa kuchokera ku zingwe zolembedwa, ndipo dzina latsambalo limagwiritsidwa ntchito ngati mtengo wotsutsana. friendly_name (dzina).
=HYPERLINK("http://www." &B3 & ".com",B3)
=ГИПЕРССЫЛКА("http://www."&B3&".com";B3)