30 Excel imagwira ntchito m'masiku 30: HYPERLINK

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.

ntchito HYPERLINK (HYPERLINK) imapanga ulalo womwe umatsegula chikalata chosungidwa pakompyuta, seva ya netiweki, netiweki yapafupi, kapena intaneti.

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.

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.

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)

30 Excel imagwira ntchito m'masiku 30: HYPERLINK

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)

30 Excel imagwira ntchito m'masiku 30: HYPERLINK

Kuti mutchule mtundu womwe watchulidwa mu buku lomwelo la Excel, ingoperekani dzina lamtunduwu ngati mkangano link_location (adilesi).

=HYPERLINK("#"&D7,D7)

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

30 Excel imagwira ntchito m'masiku 30: HYPERLINK

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)

30 Excel imagwira ntchito m'masiku 30: HYPERLINK

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)

30 Excel imagwira ntchito m'masiku 30: HYPERLINK

Siyani Mumakonda