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:- Nassoshi da aka yi amfani da su a cikin tsarin computing daban-daban, kazalika da fasali na musamman.
- 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.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_1](/userfiles/21/20388_1.webp)
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.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_2](/userfiles/21/20388_2.webp)
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_3](/userfiles/21/20388_3.webp)
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.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_4](/userfiles/21/20388_4.webp)
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_5](/userfiles/21/20388_5.webp)
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:
- Standard View - A1.
- 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:
- Matsa zuwa sashin "fayil".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_6](/userfiles/21/20388_6.webp)
- Zaɓi sigogi "sigogi", wanda ke cikin ƙananan hagu na taga.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_7](/userfiles/21/20388_7.webp)
- 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".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_8](/userfiles/21/20388_8.webp)
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:
- Muna zaɓar wayar ka shigar da hanyar haɗi zuwa wani tantanin halitta a ciki. Misali, rubuta: = B1.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_9](/userfiles/21/20388_9.webp)
- Bayan shigar da furcin, danna "Shigar" don fitarwa sakamakon ƙarshe.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_10](/userfiles/21/20388_10.webp)
- 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.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_11](/userfiles/21/20388_11.webp)
- An kwafa dabara a kan ƙananan sel.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_12](/userfiles/21/20388_12.webp)
- 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.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_13](/userfiles/21/20388_13.webp)
Yanzu ka yi la'akari da misalin magunguna tare da cikakken haɗin yanar gizo. Jagorar Mataki na mataki-mataki:
- Yin amfani da alamar dala "$" muna samar da gyara adireshin wayar kafin sunan shafi da lambar layin.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_14](/userfiles/21/20388_14.webp)
- 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.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_15](/userfiles/21/20388_15.webp)
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.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_16](/userfiles/21/20388_16.webp)
Ƙ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!
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_17](/userfiles/21/20388_17.webp)
Jagorar Mataki na mataki-mataki:
- Mun koma ga sel mai wajibi, shigar da halin "=". Rufe lkm a kan sunan takardar, wanda yake a kasan processor processor ke dubawa.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_18](/userfiles/21/20388_18.webp)
- 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.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_19](/userfiles/21/20388_19.webp)
- 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.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_20](/userfiles/21/20388_20.webp)
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".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_21](/userfiles/21/20388_21.webp)
Jagorar Mataki na mataki-mataki:
- Mun zabi tantanin halitta wanda muke so mu kara dabara. Mun shiga halin "=".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_22](/userfiles/21/20388_22.webp)
- 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.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_23](/userfiles/21/20388_23.webp)
- 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.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_24](/userfiles/21/20388_24.webp)
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:
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_25](/userfiles/21/20388_25.webp)
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:
- 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.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_26](/userfiles/21/20388_26.webp)
- Tagan nuni yana nuna taga da ake kira "aiki da kaya". Zaɓi na rukuni "Hanyoyi da Arrays".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_27](/userfiles/21/20388_27.webp)
- Latsa wani yanki na dash. Bayan gudanar da duk duk magudi, danna "Ok".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_28](/userfiles/21/20388_28.webp)
- 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".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_29](/userfiles/21/20388_29.webp)
- Shirya! Sakamakon yana nuna sakamakon Amurka.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_30](/userfiles/21/20388_30.webp)
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:
- 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".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_31](/userfiles/21/20388_31.webp)
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_32](/userfiles/21/20388_32.webp)
- 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.
Jagorar Mataki na mataki-mataki:
- Muna samar da taga bude don ƙirƙirar hanyar hyperlink.
- A cikin "ɗaure" layin, zaɓi fayil ɗin "fayil, shafin yanar gizo" abu.
- A cikin layin "Search B", muna zaɓar babban fayil a cikin abin da fayil ɗin yake wanda muke shirin yin hanyar haɗi.
- A cikin layin "rubutu, muna shigar da bayanan rubutu, wanda za'a nuna maimakon tunani.
- Bayan duk magidano, danna "Ok".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_33](/userfiles/21/20388_33.webp)
Jagorar Mataki na mataki-mataki:
- Muna samar da taga bude don ƙirƙirar hanyar hyperlink.
- A cikin "ɗaure" jere, zaɓi "Fayil, page na gidan yanar gizo".
- Danna maɓallin "Intanet".
- A cikin "Adireshin", fitar da adireshin shafin yanar gizo.
- A cikin layin "rubutu, muna shigar da bayanan rubutu, wanda za'a nuna maimakon tunani.
- Bayan duk magidano, danna "Ok".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_34](/userfiles/21/20388_34.webp)
Jagorar Mataki na mataki-mataki:
- Muna samar da taga bude don ƙirƙirar hanyar hyperlink.
- A cikin "ɗaure" layin, zaɓi fayil ɗin "fayil, shafin yanar gizo" abu.
- Danna kan "shafin ... kuma zaɓi takardar aikin don ƙirƙirar hanyar haɗi.
- Bayan duk magidano, danna "Ok".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_35](/userfiles/21/20388_35.webp)
Jagorar Mataki na mataki-mataki:
- Muna samar da taga bude don ƙirƙirar hanyar hyperlink.
- A cikin "ɗaure" layin, zaɓi bayanan "sabon takaddar".
- A cikin layin "rubutu, muna shigar da bayanan rubutu, wanda za'a nuna maimakon tunani.
- A cikin "sabon takaddun takardu" Strit, shigar da sunan sabon takaddar TABARULE.
- A cikin layin "hanya", nuna wurin don adana sabon takaddar.
- A cikin layi "lokacin da za a yi gyara zuwa sabon takaddar" zaɓi mafi girman sigari don kanku.
- Bayan duk magidano, danna "Ok".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_36](/userfiles/21/20388_36.webp)
Jagorar Mataki na mataki-mataki:
- Muna samar da taga bude don ƙirƙirar hanyar hyperlink.
- A cikin "ɗaure" jere, zaɓi Email Emon.
- A cikin layin "rubutu, muna shigar da bayanan rubutu, wanda za'a nuna maimakon tunani.
- A cikin layi "el. Mail "nuna imel na mai karɓa.
- A cikin layin "Jerin", shigar da sunan harafin
- Bayan duk magidano, danna "Ok".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_37](/userfiles/21/20388_37.webp)
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:
- Mun sami tantanin halitta tare da an gama hyperlink.
- Danna shi Pkm. An saukar da menu na mahallin, wanda ka zabi kashi "Canja hanyar hyperlink ...".
- A cikin taga wanda ya bayyana, muna samar da dukkanin canje-canje da suka dace.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_38](/userfiles/21/20388_38.webp)
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:
- Mun koma zuwa "gida" kuma mu zabi wani abu na "salon kwali".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_39](/userfiles/21/20388_39.webp)
- Danna kan rubutun "Hyperlink" ta pkm kuma danna kan "canjin".
- A cikin taga da aka nuna, danna maɓallin tsarin "Tsarin".
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_40](/userfiles/21/20388_40.webp)
- A cikin "font" da "cika" sassan, zaku iya canza tsarawa.
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_41](/userfiles/21/20388_41.webp)
Yadda za a Cire Hyperlink a Excel
Mataki na-mataki Jagora don cire hyperlinks:
- Danna PCM akan tantanin, inda yake.
- A menu na watsa menu, zaɓi "Share hyperlink" abu. Shirya!
![Yadda ake yin hanyar haɗi don fice. Ingirƙirar hanyoyin da aka fi dacewa da wani takarda, a wani littafin, hyperlink 20388_42](/userfiles/21/20388_42.webp)
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.