Ayyukan Excel 30 a cikin kwanaki 30: HYPERLINK

Jiya a gudun marathon 30 Excel yana aiki a cikin kwanaki 30 mun yi maye gurbin rubutu ta amfani da aikin MUSA (MUSA) kuma yayi rahotanni masu sassauƙa da shi.

A ranar 28th na marathon, za mu yi nazarin aikin HYPERLINK (HYPERLINK). Maimakon ƙirƙirar hyperlinks da hannu ta amfani da umarnin Ribbon na Excel na wannan sunan, zaku iya amfani da wannan fasalin.

Don haka bari mu shiga cikin cikakkun bayanai game da aikin HYPERLINK (HYPERLINK) da misalan amfaninsa. Idan kuna da ƙarin bayani ko misalai, da fatan za a raba su a cikin sharhi.

aiki HYPERLINK (HYPERLINK) yana ƙirƙirar hanyar haɗin gwiwa da ke buɗe takaddar da aka adana akan kwamfuta, uwar garken cibiyar sadarwa, cibiyar sadarwar gida, ko Intanet.

aiki HYPERLINK (HYPERLINK) yana ba ku damar buɗe takardu ko kewaya zuwa takamaiman wurare a cikin takaddar. Da shi za ku iya:

  • Ƙirƙiri hanyar haɗin yanar gizon da ke kewaya zuwa takamaiman wuri a cikin fayil iri ɗaya.
  • Ƙirƙiri hanyar haɗi zuwa takaddar Excel a cikin babban fayil guda.
  • Ƙirƙiri hanyar haɗi zuwa gidan yanar gizo.

aiki HYPERLINK (HYPERLINK) yana da ma'ana mai zuwa:

HYPERLINK(link_location,friendly_name)

ГИПЕРССЫЛКА(адрес;имя)

  • mahada_wuri (adireshi) - Rubutun rubutu wanda ke ƙayyade wurin wurin da ake so ko daftarin aiki.
  • suna (suna) shine rubutun da za'a nuna a cikin tantanin halitta.

Idan ba ku da tabbacin za ku iya ƙirƙirar madaidaicin tunani don aiki HYPERLINK (HYPERLINK), saka shi da hannu ta amfani da umarnin hyperlink (Hyperlink), wanda ke kan shafin Saka Ribbons na Excel. Ta wannan hanyar za ku koyi madaidaicin syntax, wanda zaku maimaita don hujja mahada_wuri (adireshi).

Misali 1: Nuna wuri a cikin fayil iri ɗaya

Akwai hanyoyi daban-daban don ƙirƙirar igiyar rubutu don jayayya mahada_wuri (adireshi). A cikin misali na farko, aikin ADDRESS (ADDRESS) yana dawo da adireshi na jere na farko da shafi na farko a cikin takardar aikin wanda sunansa ya kayyade a cikin tantanin halitta B3.

alama # (alamar fam) a farkon adireshin yana nuna cewa wurin yana cikin fayil ɗin yanzu.

=HYPERLINK("#"&ADDRESS(1,1,,,B3),D3)

=ГИПЕРССЫЛКА("#"&АДРЕС(1;1;;;B3);D3)

Ayyukan Excel 30 a cikin kwanaki 30: HYPERLINK

Hakanan, zaku iya amfani da afareta & (concatenation) don makantar da adireshin mahaɗin. Anan sunan takardar yana cikin cell B5 kuma adireshin tantanin halitta yana cikin C5.

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

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

Ayyukan Excel 30 a cikin kwanaki 30: HYPERLINK

Don komawa zuwa kewayon mai suna a cikin littafin aikin Excel iri ɗaya, kawai samar da sunan kewayon azaman hujja mahada_wuri (adireshi).

=HYPERLINK("#"&D7,D7)

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

Ayyukan Excel 30 a cikin kwanaki 30: HYPERLINK

Misali 2: Nuna fayil ɗin Excel a cikin babban fayil guda

Don ƙirƙirar hanyar haɗi zuwa wani fayil na Excel a cikin babban fayil ɗin, kawai yi amfani da sunan fayil azaman hujja mahada_wuri (address) a cikin aiki HYPERLINK (HYPERLINK).

Don ƙididdige hanyar zuwa fayil ɗin da ke da matsayi ɗaya ko fiye a cikin matsayi, yi amfani da lokaci biyu da ja da baya (..) ga kowane matakin.

=HYPERLINK(C3,D3)

=ГИПЕРССЫЛКА(C3;D3)

Ayyukan Excel 30 a cikin kwanaki 30: HYPERLINK

Misali 3: Haɗa zuwa gidan yanar gizo

Amfani da ayyuka HYPERLINK (HYPERLINK) Kuna iya haɗawa zuwa shafuka akan gidajen yanar gizo. A cikin wannan misali, an haɗa haɗin yanar gizon daga igiyoyin rubutu, kuma ana amfani da sunan shafin azaman ƙimar hujja. suna (suna).

=HYPERLINK("http://www." &B3 & ".com",B3)

=ГИПЕРССЫЛКА("http://www."&B3&".com";B3)

Ayyukan Excel 30 a cikin kwanaki 30: HYPERLINK

Leave a Reply