Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink

Ingirƙirar nassoshi hanya ce da wacce irin kowane mai amfani da tebur na tebur na musamman yake fuskanta. Ana amfani da hanyoyin haɗi don aiwatar da jujjuyawar shafukan yanar gizo, da kuma samun dama a cikin kowane maɓalli na waje ko takardu. A cikin labarin, zamuyi la'akari da cikakken tsarin ƙirƙirar hanyoyin haɗi kuma gano cewa za a iya zaɓar wannan magidanta tare da su.

Irin hanyoyin haɗin yanar gizo

Akwai manyan nau'ikan haɗi guda biyu:

1. Nassoshi da aka yi amfani da su a cikin tsarin computing daban-daban, kazalika da fasali na musamman.
2. Nassoshi da aka yi amfani da su don juyawa zuwa takamaiman abubuwa. Ana kiran su hyperlinks.

Duk hanyoyin haɗi (hanyoyin haɗin yanar gizo) suna daɗa kashi biyu.

• Nau'in waje. Amfani da shi don juyawa zuwa asalin da ke cikin wani takaddar. Misali, a kan wata alama ko shafin yanar gizo.
• Nau'in ciki. Amfani da shi don juyawa zuwa abu wanda yake a cikin wannan littafin. An yi amfani da su daidai da nau'ikan ƙimar ma'aikaci ko kuma abubuwan taimako na tsari. Aiwatar don tantance takamaiman abubuwa a cikin takaddar. Waɗannan hanyoyin suna iya haifar da abubuwa biyu na wannan takarda da kuma abubuwan da sauran zanen gado ɗaya.

Akwai bambance-bambance da yawa don ƙirƙirar hanyoyin haɗi. Dole ne a zaɓi hanyar, la'akari da wane irin hanyoyin haɗin yanar gizon ake buƙata a cikin takardar aiki. Za mu bincika hanyar kowace hanya cikin ƙarin bayani.

Yadda zaka kirkiro hanyoyin haɗi a kan takardar

Hanyar mafi sauki ita ce bayyana adiresoshin tantanin halitta a cikin wannan tsari: = B2.

ɗaya

Alamar "=" ita ce babban wani ɓangare na mahadar. Bayan rubuta wannan alama a cikin layi don shigar da dabara, process processor zai fara fahimtar wannan darajar a matsayin hanyar haɗi. Yana da matukar muhimmanci a shigar da adireshin tantanin halitta domin shirin daidai yake samar da aikin sarrafa bayanai. A cikin misalin misali, darajar "= B2" tana nuna cewa a cikin filin D3 a ciki wanda muka shiga hanyar haɗin yanar gizon da za a miƙa daga sel na B2.

2.

3.

Duk wannan yana ba da damar ayyukan Arithmetic da yawa a cikin shafin Processor. Misali, muna rubuta tsari mai zuwa a filin D3: = A5 + B2. Bayan shigar da wannan dabara, latsa "Shigar". A sakamakon haka, muna samun sakamakon kari na sel B2 da A5.

huɗu

biyar

Ana iya samar da wasu ayyukan ilimin lissafi a irin wannan hanyar. A cikin Tabular Processor Akwai babban hanyar haɗin haɗi guda 2:

1. Standard View - A1.
2. R1C Tsarin mai nuna alama na farko yana nuna adadin layin, da kuma 2nd - yawan shafi.

Matakan daidaitawa-mataki-mataki-canje-canje suna kama da wannan:

1. Matsa zuwa sashin "fayil".

6.

1. Zaɓi sigogi "sigogi", wanda ke cikin ƙananan hagu na taga.

7.

1. Allon yana nuna taga tare da sigogi. Mun koma zuwa wani yanki da ake kira "dabaru". Mun sami "aiki tare da dabaru" kuma mu sanya alama kusa da "salon salon R1C1" kashi. Bayan gudanar da duk duk magudi, danna "Ok".

takwas

Akwai nau'ikan hanyoyin haɗin guda 2:

• Cikakken tunani game da wurin wani abu, ba tare da la'akari da kayan tare da abubuwan da aka kayyade ba.
• Duhun mutane suna nufin wurin abubuwan da ke da alaƙa da tantanin halitta na ƙarshe tare da furcin da aka yi riko.

Ta hanyar tsoho, duk hanyoyin haɗi suna ɗaukar dangi. Ka yi la'akari da misalin magudi tare da nassoshi na dangi. Jagorar Mataki na mataki-mataki:

1. Muna zaɓar wayar ka shigar da hanyar haɗi zuwa wani tantanin halitta a ciki. Misali, rubuta: = B1.

tara

1. Bayan shigar da furcin, danna "Shigar" don fitarwa sakamakon ƙarshe.

10

1. Matsar da siginan kwamfuta zuwa madaidaicin ƙananan kusurwar tantanin halitta. Point ɗin zai ɗauki siffar ƙaramin duhu mai duhu. Latsa lkm da shimfiɗa faɗakarwa.

goma sha ɗaya

1. An kwafa dabara a kan ƙananan sel.

12

1. Mun lura cewa a cikin ƙananan sel, hanyar da aka shigar ta canza zuwa matsayi ɗaya tare da ƙaura mataki ɗaya. Wannan sakamakon ya kasance saboda amfani da dangi.

13

Yanzu ka yi la'akari da misalin magunguna tare da cikakken haɗin yanar gizo. Jagorar Mataki na mataki-mataki:

1. Yin amfani da alamar dala "$" muna samar da gyara adireshin wayar kafin sunan shafi da lambar layin.

goma sha huɗu

1. Mun shimfiɗa, kazalika da misalin da aka ambata, da dabara. Mun lura cewa sel da ke ƙasa kasance iri ɗaya alamomi kamar yadda a cikin sel na farko. Babban hanyar haɗin da aka rubuta rikodin ƙimar tantanin halitta, kuma yanzu ba sa canzawa lokacin da aka canja dabara.

goma sha biyar

Duk abin da, a cikin Table Processor, zaku iya aiwatar da hanyar haɗi zuwa kewayon sel. Da farko, adireshin sel na hagu na hagu yana rubuce, sannan kuma mafi ƙasƙanci. Tsakanin daidaitawa shine mallaka ":". Misali, hoton da ke ƙasa, kewayon A1 yana da alama: C6. Tunani ga wannan kewayon shine: = A1: C6.

goma sha shida

Ƙirƙirar hanyar haɗi zuwa wani takarda

Yanzu ka yi la'akari da yadda zaka kirkiri wani bayani game da sauran zanen gado. Anan, ban da daidaitawar tantanin halitta, adireshin takarda mai aiki yana nuna cewa. A takaice dai, bayan alamar "=", sunan mai aiki an rubuta shi, kuma adireshin abin da ake buƙata an ƙara a ƙarshen. Misali, hanyar haɗi a kan sel mai sel, wacce ake kira "Jerin2", kamar haka: = Lissafin2!

17.

Jagorar Mataki na mataki-mataki:

1. Mun koma ga sel mai wajibi, shigar da halin "=". Rufe lkm a kan sunan takardar, wanda yake a kasan processor processor ke dubawa.

goma sha takwas

1. Mun koma zuwa takardar sakin layi na 2 na daftarin. Ta latsa lcm, muna zaɓar tantanin halitta da muke son danganta a cikin dabara.

goma sha tara

1. Bayan gudanar da duk duk magudi, danna "Shigar". Mun sami kansu a kan farkon takardar na asali, wanda aka riga aka cire adadi na ƙarshe.

ashirin

Misalin waje ga wani littafi

Ka yi la'akari da yadda za a aiwatar da hanyar haɗin kai zuwa wani littafi. Misali, muna bukatar mu aiwatar da kirkiro hanyar haɗi zuwa tantanin B5, wanda yake kan takardar aikin bude littafin "links.xlsx".

21.

Jagorar Mataki na mataki-mataki:

1. Mun zabi tantanin halitta wanda muke so mu kara dabara. Mun shiga halin "=".

22.

1. Motsawa a cikin bude littafin da tantanin halitta yake, hanyar hanyar da muke son ƙarawa. Danna kan ganyen da ake buƙata, sannan kuma a kan sel da ake so.

23.

1. Bayan gudanar da duk duk magudi, danna "Shigar". Mun sami kanmu a kan takardar aikin na asali wanda za'a riga an ƙaddamar da sakamako.

24.

Haɗi zuwa fayil akan sabar

Idan aka sanya takaddun, alal misali, a babban babban fayil na uwar garken kamfanonin, to ana iya magana da shi kamar haka:25.

Haɗi zuwa kewayon kewayon

Tadular Processor yana ba ku damar ƙirƙirar hanyar haɗi zuwa mahaɗan da aka sanya ta hanyar "sunan mai suna". Don yin wannan, kawai shigar da sunan kewayon a cikin hanyar haɗi:

26.

Don bayyana ambaton sunan mai suna a cikin takaddar mai suna, da bukatar bayyana sunan ta, da kuma tantance hanya:

27.

Haɗi zuwa Table Tebur ko abubuwan sa

Yin amfani da mai aikin hysperlob, zaku iya motsa hanyar haɗi zuwa kowane yanki na "Smart" tebur ko a duk farantin gaba ɗaya. Ya yi kama da wannan:

28.

Yin amfani da mai aiki DVSSL

Don aiwatar da ayyuka daban-daban, zaku iya amfani da aiki na musamman na DVSL. Janar na mai aiki: = DVSSL (Link_NAMECHAIR; A1). Zamuyi nazari kan afare a cikin cikakken bayani game da takamaiman misali. Jagorar Mataki na mataki-mataki:

1. Muna samar da zaɓi na tantaninjir na zama dole, sannan ka danna kan "Saka Aikin" Saka ", wanda yake kusa da layi don shigar da dabaru.

29.

1. Tagan nuni yana nuna taga da ake kira "aiki da kaya". Zaɓi na rukuni "Hanyoyi da Arrays".

talatin

1. Latsa wani yanki na dash. Bayan gudanar da duk duk magudi, danna "Ok".

31.

1. Nunin yana nuna taga don shigar da muhawara ta afteraftarin aiki. A cikin layin "Link_name" na gabatar da daidaito na tantanin halitta wanda muke son komawa zuwa. Layi "A1" Ka bar komai. Bayan duk magidano, danna maɓallin "Ok".

32.

1. Shirya! Sakamakon yana nuna sakamakon Amurka.

33.

Menene hyperlink

Kirkirar hyperlink

Hyperlinks ba kawai don "fitar da" fitar da "bayani daga sel, amma kuma zuwa canzawa zuwa ga wani bayanin. Mataki Ta Mataki Jagora don ƙirƙirar hanyar hyperlink:

1. Da farko, ya zama dole a shiga taga na musamman wanda zai ba ku damar ƙirƙirar hanyar hyperlink. Akwai zaɓuɓɓuka da yawa don aiwatar da wannan aikin. Na farko - Latsa PKM a kan sel wajibi da a cikin menu menu Zaɓi kashi "Haɗin ...". Na biyu - Zaɓi tantanin da ake so, matsa zuwa sashin "Saka" kuma zaɓi kashi "mahadar". Na uku - Yi amfani da haɗin maɓallin "Ctrl + K".

34.

35.

1. Allon yana nuna taga wanda ya ba ka damar daidaita hanyar tazara. Akwai zabi na abubuwa da yawa. Bari muyi la'akari da kowane zaɓi daki-daki daki-daki.

Yadda ake ƙirƙirar hanyar haɗi a cikin Forevel zuwa wani takaddar

Jagorar Mataki na mataki-mataki:

1. Muna samar da taga bude don ƙirƙirar hanyar hyperlink.
2. A cikin "ɗaure" layin, zaɓi fayil ɗin "fayil, shafin yanar gizo" abu.
3. A cikin layin "Search B", muna zaɓar babban fayil a cikin abin da fayil ɗin yake wanda muke shirin yin hanyar haɗi.
4. A cikin layin "rubutu, muna shigar da bayanan rubutu, wanda za'a nuna maimakon tunani.
5. Bayan duk magidano, danna "Ok".

36 Yadda ake kirkirar hyperlink a cikin Excel a shafin yanar gizo

Jagorar Mataki na mataki-mataki:

1. Muna samar da taga bude don ƙirƙirar hanyar hyperlink.
2. A cikin "ɗaure" jere, zaɓi "Fayil, page na gidan yanar gizo".
3. Danna maɓallin "Intanet".
4. A cikin "Adireshin", fitar da adireshin shafin yanar gizo.
5. A cikin layin "rubutu, muna shigar da bayanan rubutu, wanda za'a nuna maimakon tunani.
6. Bayan duk magidano, danna "Ok".

37 yadda zaka ƙirƙiri hyperlink a cikin fifita takamaiman yanki a cikin takaddun na yanzu

Jagorar Mataki na mataki-mataki:

1. Muna samar da taga bude don ƙirƙirar hanyar hyperlink.
2. A cikin "ɗaure" layin, zaɓi fayil ɗin "fayil, shafin yanar gizo" abu.
3. Danna kan "shafin ... kuma zaɓi takardar aikin don ƙirƙirar hanyar haɗi.
4. Bayan duk magidano, danna "Ok".

38 Ta yaya Don ƙirƙirar Hyperlink a cikin Fodel zuwa sabon littafin aiki

Jagorar Mataki na mataki-mataki:

1. Muna samar da taga bude don ƙirƙirar hanyar hyperlink.
2. A cikin "ɗaure" layin, zaɓi bayanan "sabon takaddar".
3. A cikin layin "rubutu, muna shigar da bayanan rubutu, wanda za'a nuna maimakon tunani.
4. A cikin "sabon takaddun takardu" Strit, shigar da sunan sabon takaddar TABARULE.
5. A cikin layin "hanya", nuna wurin don adana sabon takaddar.
6. A cikin layi "lokacin da za a yi gyara zuwa sabon takaddar" zaɓi mafi girman sigari don kanku.
7. Bayan duk magidano, danna "Ok".

39 Ta yaya zaka ƙirƙiri hyperlink a cikin Excel don ƙirƙirar imel

Jagorar Mataki na mataki-mataki:

1. Muna samar da taga bude don ƙirƙirar hanyar hyperlink.
2. A cikin "ɗaure" jere, zaɓi Email Emon.
3. A cikin layin "rubutu, muna shigar da bayanan rubutu, wanda za'a nuna maimakon tunani.
4. A cikin layi "el. Mail "nuna imel na mai karɓa.
5. A cikin layin "Jerin", shigar da sunan harafin
6. Bayan duk magidano, danna "Ok".

40.

Yadda za a shirya hyperlink a ficelf

Zai sau da yawa yakan faru cewa dole ne a gyara tsarin hyperlink. Sanya sauki sosai. Jagorar Mataki na mataki-mataki:

1. Mun sami tantanin halitta tare da an gama hyperlink.
2. Danna shi Pkm. An saukar da menu na mahallin, wanda ka zabi kashi "Canja hanyar hyperlink ...".
3. A cikin taga wanda ya bayyana, muna samar da dukkanin canje-canje da suka dace.

41.

Yadda za a tsara tsarin hyperlink a Forevie

A zahiri, duk nassoshi a cikin teburin sarrafawa a matsayin rubutun da aka ja layi a cikin shuɗi inuwa. Za a iya canza tsarin. Jagorar Mataki na mataki-mataki:

1. Mun koma zuwa "gida" kuma mu zabi wani abu na "salon kwali".

42.

1. Danna kan rubutun "Hyperlink" ta pkm kuma danna kan "canjin".
2. A cikin taga da aka nuna, danna maɓallin tsarin "Tsarin".

43.

1. A cikin "font" da "cika" sassan, zaku iya canza tsarawa.

44.

Yadda za a Cire Hyperlink a Excel

Mataki na-mataki Jagora don cire hyperlinks:

1. Danna PCM akan tantanin, inda yake.
2. A menu na watsa menu, zaɓi "Share hyperlink" abu. Shirya!

45.

Amfani da alamun da ba daidai ba

Akwai matsaloli lokacin da za'a iya haɗe hyplink na atomatik tare da aikin fitarwa na alamar haruffan marasa daidaituwa. Hanyar aikin tana aiwatar da sauyawa na hanyar haɗin rubutu na yau da kullun zuwa kowane alama mara daidaituwa.46.

Ƙarshe

Mun gano cewa a cikin tebur procece frefor da akwai manyan hanyoyi da zasu baka damar ƙirƙirar hanyar haɗi. Bugu da ƙari, mun sami masaniya game da yadda ake ƙirƙirar hanyar haɗi zuwa abubuwa daban-daban. Yana da mahimmanci a lura cewa dangane da kallon da aka zaɓa, hanyar aiwatar da canje-canjen haɗin da ake buƙata.

Saƙo Yadda ake yin hanyar haɗi don Excel. Ingirƙirar nassoshi zuwa wani ganye, a kan wani littafi, hyperlink ya bayyana da farko ga fasaha.