Sau da yawa sau ɗaya, lokacin aiki tare da tebur a Microsoft Excel, halin da ake ciki yana faruwa lokacin da kuke buƙatar haɗa ƙwayoyin da yawa. Aikin bai da wahala sosai idan waɗannan sel ba su da bayani. Amma me za a yi idan an riga an shigar da bayanai a cikinsu? Shin, za a halaka su? Bari mu ga yadda ake hada sel, gami da rashin asarar bayanai, a cikin Microsoft Excel.
Cellirƙirar tantanin halitta mai sauƙi
Kodayake, zamu nuna ƙungiyar sel akan misalin Excel 2010, amma wannan hanyar ta dace da sauran juzu'in wannan aikin.
Domin haɗu da ƙwayoyin cuta da yawa, wanda guda ɗaya kaɗai ke cike da bayanai, ko ma komai sarai, zaɓi mahimman sel tare da siginan kwamfuta. To, a cikin shafin "Excel" shafin, danna kan gunkin a kan kintinkiri "Hada da sanya a cikin cibiyar."
A wannan yanayin, ƙwayoyin za su haɗu, kuma duk bayanan da za su dace da haɗuwar tantanin halitta za a sa su a cibiyar.
Idan kana son sanya bayanai daidai da tsarin tantanin halitta, to akwai buƙatar ka zaɓi abu "Haɗa Kwayoyin" daga jerin abubuwan da aka sauke.
A wannan yanayin, rikodin tsohuwar zai fara ne daga gefen dama daga cikin haɗin wayar.
Hakanan, yana yiwuwa a haɗu da layuka da yawa ta layi. Don yin wannan, zaɓi kewayon da ake so, kuma daga jerin zaɓi, danna kan ƙimar "Hada a cikin layuka."
Kamar yadda kake gani, bayan wannan sel ba'a haɗasu cikin sel ɗaya ba, amma haɗaka ƙungiyoyi-da-jere.
Hada yanayin menu
Zai yuwu a hada sel ta hanyar mahalli. Don yin wannan, zaɓi ƙwayoyin da za a haɗe tare da siginan kwamfuta, danna maballin dama, kuma zaɓi abu "Tsarin Kwayoyin" a menu na mahallin da ya bayyana.
A cikin taga taga wayar, je zuwa shafin "Daidaitawa". Duba akwatin kusa da "Kwayoyin haɗaka". Anan zaka iya saita sauran sigogi: jagora da jan ragamar rubutu, kwance da layi a tsaye, faifai, nisa na magana. Lokacin da aka gama saitunan duka, danna maɓallin "Ok".
Kamar yadda kake gani, akwai haduwar sel.
Rashin haɗuwa mai haɗari
Amma abin da za a yi idan bayanan suna cikin yawancin sel da aka haɗu, saboda lokacin da aka haɗu, duk dabi'un ban da na hagu na sama za a ɓace?
Akwai wata hanyar fita a cikin wannan halin. Zamu yi amfani da aikin "CONNECT". Da farko dai, kuna buƙatar ƙara wani sel tsakanin sel ɗin da zaku haɗu. Don yin wannan, danna sauƙin dama na sel ɗin da za a haɗe. A cikin menu na mahallin da ya bayyana, zaɓi abu "Saka ...".
Wani taga yana buɗewa wanda kuke buƙatar shirya sauyawa zuwa matsayin "columnara shafi". Muna yin wannan, kuma danna maɓallin "Ok".
A cikin tantanin da aka kirkira tsakanin wadannan sel wadanda za mu hade, mun sanya darajar ba tare da ambaton "= CONNECT (X; Y)", inda X da Y sune masu kula da sel da aka hade, bayan da kara shafin. Misali, domin a hada sel A2 da C2 ta wannan hanyar, saka kalmar "= CONNECT (A2; C2)" a cikin sel B2.
Kamar yadda kake gani, bayan wannan, haruffan da ke cikin tantanin halitta "sun makale tare."
Amma yanzu, maimakon sel ɗaya da aka haɗa, muna da guda uku: sel biyu tare da ainihin bayanan, kuma ɗayan aka haɗa. Don yin sel ɗaya, danna kan salula da aka haɗa tare da maɓallin linzamin kwamfuta na dama kuma zaɓi abu "Kwafi" a cikin maɓallin mahallin.
Bayan haka, muna matsawa zuwa madaidaiciyar sel tare da bayanan farko, kuma danna kan shi, zaɓi abu "Dabi'u" a cikin zaɓin shigarwar.
Kamar yadda kake gani, a cikin wannan tantanin halitta bayanai sun bayyana cewa kafin hakan ta kasance a cikin kwayar halittar tare da dabara.
Yanzu, share hagu na gaba mai dauke da tantanin halitta tare da ainihin bayanan, da kuma shafi mai dauke da tantanin halitta tare da tsari na kamawa.
Don haka, mun sami sabon sel da ke ɗauke da bayanan da yakamata a haɗa su, kuma an share duk tsaranin sel ɗin.
Kamar yadda kake gani, idan hadadden sel da ke cikin Microsoft Excel mai sauki ne, to lallai zaka tinker da hada sel ba tare da asara ba. Koyaya, wannan ma aiki ne mai kyau ga wannan shirin.
