Ofayan fasali mai ban sha'awa da amfani a cikin Excel shine ikon haɗu da sel biyu ko fiye zuwa ɗaya. Wannan yanayin yana cikin buƙatu musamman lokacin ƙirƙirar shugabannin tebur da shugabannin kai. Kodayake, wani lokacin ana amfani dashi koda a cikin tebur. A lokaci guda, kuna buƙatar yin la'akari da cewa lokacin da kuke haɗa abubuwa, wasu ayyuka sun daina aiki daidai, kamar rarrabewa. Hakanan akwai wasu dalilai da yawa waɗanda mai amfani ya yanke shawarar cire haɗin sel don gina tsarin tebur ta wata hanya daban. Zamu tabbatar ta waɗanne hanyoyi wannan za'a iya bi.
Rarraba Jiki
Hanyar rarrabe sel shine ƙarshen hada su. Saboda haka, a cikin kalmomi masu sauƙi, don kammala shi, kuna buƙatar soke ayyukan da aka yi a lokacin haɗewar. Babban abin da zaka fahimta shine kawai zaka iya katse tantanin halitta wanda ya kunshi abubuwa da yawa da aka hade a baya.
Hanyar 1: taga tsarawa
Ana amfani da yawancin masu amfani don aiwatar da hadawa a cikin taga tsara tare da miƙa mulki a can ta hanyar menu. Saboda haka, za su kuma cire haɗin.
- Zaɓi gidan da aka haɗe. Danna-dama don buɗe menu na mahallin. Cikin jeri dake buɗe, zaɓi "Tsarin kwayar halitta ...". Madadin waɗannan ayyuka, bayan zaɓar wani kashi, zaka iya rubuta haɗakar maɓallan kan keyboard Ctrl + 1.
- Bayan haka, taga tsara bayanai zai fara. Matsa zuwa shafin Jeri. A cikin toshe saitin "Nuna" Cire alamar zaɓi Kungiyar Hadin Gwiwa. Don aiwatar da aiki, danna maɓallin "Ok" a kasan taga.
Bayan waɗannan ayyuka masu sauƙi, tantanin da aka yi wa aikin za'a rarraba shi zuwa abubuwan da ke ciki. Haka kuma, idan an adana bayanai a ciki, to dukkansu zasu kasance a hagu na sama.
Darasi: Tsarin tebur a cikin Excel
Hanyar 2: Bututun Ribbon
Amma da sauri da sauƙi, a zahiri dannawa ɗaya, zaku iya cire haɗin abubuwa ta maɓallin akan kintinkiri.
- Kamar yadda a cikin hanyar da ta gabata, da farko, kuna buƙatar zaɓar tantanin halitta da aka haɗa. Sannan a rukunin kayan aiki Jeri a kan tef danna kan maɓallin "Hada da tsakiya".
- A wannan yanayin, duk da suna, kawai ɗayan matakin zai faru bayan danna maɓallin: abubuwan zasu yanke.
A zahiri akan wannan, duk zaɓuɓɓukan don raba sel ƙare. Kamar yadda kake gani, yan biyu ne kawai: window ɗin tsarawa da maballin akan kintinkiri. Amma waɗannan hanyoyin sun isa sosai don kammalawa da sauri wanda ya dace da tsarin da ke sama.
