Contents
Gabatar da takarda kai tsaye ya dogara da yadda aka tsara bayanan. Kuna iya taimakawa wajen tsara bayanan ta hanya mai kyau da dacewa ta hanyar tsara su cikin tebur a cikin Excel, wanda ba shi yiwuwa a yi aiki tare ba tare da ayyuka daban-daban tare da sel ba. Canje-canje ga sel, layuka da ginshiƙai suna taimakawa wajen sa tebur ya fi karantawa da kyau, rarrabuwar sel ɗaya ce irin wannan zaɓi. Akwai hanyoyi masu sauƙi da yawa don raba sel, waɗanda za a tattauna a ƙasa.
Hanyar 1: Haɗa Maɗaukakin Ƙwayoyin Maƙwabta
Tantanin halitta a cikin tebur shine mafi ƙanƙanta naúrar ma'auni don haka kashi mara ganuwa. Mai amfani zai iya canza girmansa, haɗa shi da maƙwabta, amma ba raba shi ba. Koyaya, tare da taimakon wasu dabaru, zaku iya sanya rabuwar gani a tsaye, a kwance da layin diagonal. Ta amfani da wannan hanyar, zaku iya raba sel a cikin Excel ta hanyar haɗa sel masu kusa. Algorithm shine kamar haka:
- Nemo sel da za a raba. A cikin wannan misali, za a yi la'akari da rarraba zuwa sassa 2.
- Zaɓi sel guda biyu masu kusa, danna "Haɗa da Cibiyar" a cikin shafin "daidaitacce".
- Yi haka don sauran sel a jere.
Hakazalika, za ku iya yin rarrabuwa zuwa nau'i daban-daban na sassa daban-daban fiye da biyu. Bugu da ari, ta amfani da daidaitattun ayyuka, zaku iya daidaita girman sel, ginshiƙai da layuka. A sakamakon haka, ginshiƙan da ke ƙarƙashin tantanin halitta za a raba su a gani cikin rabi, kuma bayanan da ke cikin tebur za su kasance a tsakiyar tantanin halitta.
Hanyar 2: tsaga sel masu hade
Ana amfani da hanyar don rarraba wasu sel a cikin tebur a ko'ina cikin takaddar. Kuna buƙatar yin matakai masu zuwa:
- Zaɓi ginshiƙai ko layuka a cikin rukunin haɗin kai inda sel masu tsaga zasu kasance. A cikin wannan misali, za a sami rabo ta ginshiƙai.
- Danna kibiya a cikin kayan aiki kusa da gunkin Haɗa da Cibiyar kuma zaɓi Haɗa Ta Layuka.
- Daga ginshiƙai 2 na gani ɗaya zai fito. Bayan haka, za ku sami abubuwan da za su rabu gida biyu, danna su kuma zaɓi "Haɗa da sanya a tsakiya."
Hakazalika, zaku iya rarraba zuwa ƙarin sassa, amma kuna buƙatar haɗa kowane shafi daban. Tare da wannan hanyar, zaɓaɓɓun sel za a haɗa su cikin ɗaya, kuma abun ciki zai kasance a tsakiya.
Yana da mahimmanci a lura cewa rarrabuwar sel ba koyaushe ke da fa'ida ba. Zai fi kyau a yi amfani da shi lokacin da kawai kuna buƙatar raba tantanin halitta ta gani. Idan an yi amfani da rarrabuwa da sauran ayyuka a cikin takaddar, za a tsallake abubuwan da suka rabu.
Hanyar 3: Diagonal cell division
Yawancin teburi na iya buƙatar rarraba ba a tsaye da a kwance ba, amma a tsaye. Kuna iya yin rabon diagonal ta amfani da ginanniyar kayan aikin Excel. Don wannan kuna buƙatar:
- Danna-dama akan kashi inda ake buƙatar rarraba diagonal, shigar da rubutu a ciki cikin layi biyu.
- Zaɓi "Format Cells".
- A cikin taga da ya bayyana, zaɓi shafin "Border". Na gaba, gumaka biyu tare da rabon diagonal zasu bayyana, kuna buƙatar zaɓar wanda ya dace. Ana iya daidaita sigogin layi kamar yadda ake buƙata.
- Danna sake kan maɓallin tare da layin diagonal.
- Latsa Ok.
Kula! Za a raba tantanin halitta a gani, amma shirin yana gane shi gaba ɗaya.
Hanyar 4: Zana mai rarrabawa tare da kayan aikin Siffofin
Hakanan za'a iya amfani da aikin saka siffa don rarraba hoto ta hanyar zana layi. Algorithm shine kamar haka:
- Zaɓi wani abu don raba.
- Je zuwa shafin "Saka" kuma danna "Shapes".
- Zaɓi nau'in layin da ya dace daga jerin zaɓuɓɓukan da aka ba da shawara.
- Yi amfani da maɓallin linzamin kwamfuta na hagu don zana mai raba.
Shawara! A cikin "Format" tab, za ka iya kyau-tune da zana layin.
Kammalawa
Iya karantawa ɗaya ne daga cikin mahimman buƙatun kowane tsarin bayanai. Idan tebur yana da ƙayyadaddun kamanni tare da sel masu hade ko hade, layuka ko ginshiƙai, kuna buƙatar yin ayyukan da suka dace. Ko da yake tantanin halitta ita ce mafi ƙanƙanta na tebur, kayan aikin da aka gina a cikin Excel suna ba ku damar raba shi a gani zuwa sassa 2, 3 ko fiye a ko'ina cikin tebur ta amfani da hanyoyin da ke sama.