Lokacin aiki tare da tebur na Excel, wani lokaci kuna buƙatar karya wata kwayar zuwa sassa biyu. Amma, ba abu mai sauƙi ba kamar yadda ake gani da farko. Bari mu ga yadda za mu raba sel zuwa sassa biyu a Microsoft Excel, da kuma yadda za mu raba shi da kasa-kasa.
Rarraba sel
Ya kamata a sani yanzun cewa sel a Microsoft Excel sune abubuwan farko na tsarin, kuma ba za a iya rarrabu su zuwa kananan bangarorin ba idan ba'a hada su da farko ba. Amma menene idan mu, alal misali, muna buƙatar ƙirƙirar taken tebur mai rikitarwa, ɗayan ɓangarorin wanda aka kasu kashi biyu? A wannan yanayin, zaku iya amfani da ƙananan dabaru.
Hanyar 1: Haɗa Kwayoyin
Domin wasu sel su bayyana rarrabuwar, dole ne a haɗa sauran sel a tebur.
- Wajibi ne a yi tunani a kan dukkan tsarin tebur nan gaba da kyau.
- A saman wannan wurin akan takardar inda ake buƙatar samun kashi raba, zaɓi sel guda kusa. Kasancewa a cikin shafin "Gida", bincika toshe kayan aiki Jeri maballin kintinkiri "Hada da tsakiya". Danna shi.
- Don tsinkaye, don ganin mafi kyawun abin da muka yi, mun sanya iyakoki. Zaɓi duk kewayon sel waɗanda muke shirin rarraba don teburin. A cikin wannan shafin "Gida" a cikin akwatin kayan aiki Harafi danna alamar "Iyakokin". A jeri wanda ya bayyana, zaɓi "Dukkan Iyakoki".
Kamar yadda kake gani, duk da cewa bamu raba komai ba, amma a hade, yana haifar da mafarki a cikin sel da aka raba.
Darasi: Yadda ake haɗa ƙwayoyin sel a cikin Excel
Hanyar 2: raba sel da aka haɗu
Idan muna buƙatar rarraba tantanin halitta ba a cikin kan kai ba, amma a tsakiyar teburin, to, a wannan yanayin, ya fi sauƙi mu haɗaka dukkanin sel na ginshiƙai guda biyu, sannan kawai sai a raba tantanin da ake so.
- Zaɓi ginshiƙai biyu kusa. Danna kan kibiya kusa da maballin "Hada da tsakiya". A lissafin da ya bayyana, danna abu Hada Row.
- Danna kan wayar da aka haɗa da kake son raba. Har yanzu, danna kan kibiya kusa da maballin "Hada da tsakiya". Wannan lokacin zaɓi abu Celungiyar Cire.
Don haka mun sami sel tsage. Amma, kuna buƙatar la'akari da cewa Excel yana ɗaukar wannan hanyar rarraba sel azaman kashi ɗaya.
Hanyar 3: tsagewa ta hanyar tsarawa
Amma, a cikin diagonally, zaku iya raba kwayar halitta.
- Mun danna-dama akan kwayar da ake so, kuma a cikin mahallin abinda ya bayyana, zaɓi abu "Tsarin kwayar halitta ...". Ko kuma, buga wani gajeren rubutu a maballin Ctrl + 1.
- A cikin taga taga wayar, je zuwa shafin "Iyakokin".
- Kusa da tsakiyar taga "Rubutun" Mun danna ɗayan maballin biyun da aka zana layin oblique, ana karkatar daga dama zuwa hagu, ko daga hagu zuwa dama. Zaɓi zaɓin da kuke buƙata. Zaka iya zaɓar nau'in da launi iri kai tsaye. Lokacin da aka yi zabi, danna maɓallin "Ok".
Bayan haka, za a rabu da tantanin. Amma, kuna buƙatar la'akari da cewa Excel yana ɗaukar wannan hanyar rarraba sel azaman kashi ɗaya.
Hanyar 4: tsagewa ta hanyar shigarwar sifar
Hanyar da ta biyo baya ta dace don tantance tantanin halitta kawai idan ya kasance babba, ko an ƙirƙira shi ta hanyar haɗa ƙwayoyin da yawa.
- Kasancewa a cikin shafin Saka bayanai, a cikin kayan aiki "Misalai", danna maballin "Shafuna".
- A cikin menu wanda yake buɗewa, a cikin toshe "Lines", danna babban adadi na farko.
- Zana layi kan layi daga kusurwa zuwa kusurwar sel a cikin hanyar da kake buƙata.
Kamar yadda kake gani, duk da cewa a Microsoft Excel babu ingantattun hanyoyin raba sel na farko zuwa sassa, amfani da hanyoyi da yawa zaka iya cimma sakamakon da ake so.
