Sau da yawa lokacin aiki tare da tebur a cikin Microsoft Excel, akwai halin da ake ciki lokacin da kake buƙatar haɗuwa da kwayoyin da dama. Ayyukan bazai da wahala sosai idan waɗannan kwayoyin ba su ƙunshi bayani ba. Amma abin da za a yi idan sun riga sun shiga bayanai? Za a hallaka su? Bari mu ga yadda za a hada sassan, ciki har da ba tare da asarar data ba, a Microsoft Excel.
Sauƙaƙe ƙunshi sel
Kodayake, zamu nuna jigilar sel ta amfani da misalin Excel 2010, amma wannan hanya ta dace da sauran sifofin wannan aikace-aikacen.
Domin haɗuwa da yawancin kwayoyin, wanda kawai aka cika da bayanai, ko kuma komai a duk komai, zaɓi sel da ake so tare da siginan kwamfuta. Sa'an nan, a cikin shafin "Excel" na Excel, danna kan gunkin a kan "Hanya da Sanya a cikin Cibiyar" rubutun.
A wannan yanayin, kwayoyin za su haɗu, kuma dukkanin bayanai da zasu dace cikin tantanin halitta za a sanya su a tsakiyar.
Idan kana so a sanya bayanai a kan tsarin tsarawar tantanin halitta, sannan ka zaɓa "Abubuwan Hada Kwayoyin" daga jerin abubuwan da aka sauke.
A wannan yanayin, shigarwar shigarwa zata fara daga gefen dama na tantanin halitta.
Har ila yau, yana yiwuwa a hada rayuka da yawa ta layi. Don yin wannan, zaɓi zaɓin da ake buƙata, kuma daga jerin jeri, danna kan darajar "Haɗa layi ta layi".
Kamar yadda muka gani, bayan wannan, kwayoyin ba su shiga cikin kwayar halitta guda ɗaya ba, amma sun yarda da haɗin layi.
Ƙungiyar ta hanyar mahallin menu
Zai yiwu a hade Kwayoyin ta hanyar menu mahallin. Don yin wannan, zaɓi sassan da kake so ka haɗu tare da siginan kwamfuta, danna dama a kan su, da kuma a cikin mahallin menu wanda ya bayyana, zaɓi "Siffofin Tsarin".
A cikin maɓallin tsarin sararin samaniya, je zuwa shafin "Alignment". Duba akwatin "Hada Kwayoyin". A nan za ka iya saita wasu sigogi: jagorancin da kuma daidaitawar rubutun, a kwance da daidaitaccen zane, zaɓi na atomatik na nisa, rufe kalmar. Lokacin da aka gama saitunan, danna maballin "Ok".
Kamar yadda kake gani, akwai haɗin sel.
Ƙungiya mara kyau
Amma, abin da za a yi idan akwai bayanai a yawancin kwayoyin da suke haɗuwa, saboda lokacin da ka haɗu da dukan dabi'u sai dai hagu na hagu za a rasa?
Akwai hanya a cikin wannan halin da ake ciki. Za mu yi amfani da aikin "CLUTCH". Da farko, kana buƙatar ƙara ƙarin tantanin halitta tsakanin sel da za ku haɗa. Don yin wannan, danna-dama a kan mafi kyawun ɗaya daga cikin sassan da aka haɗa. A cikin mahallin menu wanda ya bayyana, zaɓi "Saka ..." abu.
Gila yana buɗe inda kake buƙatar motsa canjin zuwa matsayin "Ƙara shafi". Muna yin wannan, kuma danna maballin "Ok".
A cikin tantanin halitta da aka kafa a tsakanin waɗannan kwayoyin da za mu hade, sanya darajar ba tare da fadi "= CHAIN (X; Y)", inda X da Y su ne haɗin ƙwayoyin da aka haɗa, bayan daɗa ginshiƙan. Alal misali, don hada salula A2 da C2 ta wannan hanya, saka kalmar "= CLUTCH (A2; C2)" zuwa cikin cell B2.
Kamar yadda ka gani, bayan wannan, haruffa a cikin kwayoyin halitta suna "makale tare."
Amma a yanzu a maimakon ɗayan tantanin halitta wanda aka haɗaka muna da uku: kwayoyin biyu tare da asalin asalin, kuma wanda ya haɗu. Don yin tantanin tantanin halitta, danna kan tantanin halitta tare da maɓallin linzamin maɓallin dama, sa'annan ka zaɓi abu "Kwafi" a cikin mahallin menu.
Sa'an nan kuma, muna matsawa zuwa tantanin halitta mai kyau tare da asalin asalin, kuma ta danna kan shi, zaɓi "Ƙimar" abu a cikin siginar sakawa.
Kamar yadda kake gani, bayanan da aka bayyana a cikin kwayar halitta ta bayyana a wannan tantanin halitta.
Yanzu, share gefen hagu wanda ya ƙunshi tantanin halitta tare da bayanan farko, da shafi wanda ke ƙunshe da tantanin halitta tare da haɗin ƙari guda ɗaya.
Sabili da haka, muna samun sabon cell dauke da bayanan da ya kamata a hade, kuma an share dukkanin kwayoyin tsaka-tsaki.
Kamar yadda kake gani, idan sabacen haɗuwa da sel a cikin Microsoft Excel ya zama mai sauƙi, to, dole ne ka gwada tare da hada kwayoyin halitta ba tare da asara ba. Duk da haka, wannan abu ne mai mahimmanci na wannan shirin.
