Momwe mungagawire cell mu Excel. Njira 4 Zogawanitsa Maselo mu Excel

Kuwonetsedwa kwa chikalata mwachindunji kumadalira momwe deta imapangidwira. Mutha kuthandizira kukonza zidziwitso m'njira yabwino komanso yabwino pozipanga kukhala matebulo mu Excel, zomwe sizingatheke kugwira ntchito popanda ma cell osiyanasiyana. Kusintha kwa maselo, mizere ndi mizati kumathandiza kuti tebulo likhale lowerengeka komanso lokongola, maselo ogawanika ndi njira imodzi yotere. Pali njira zingapo zosavuta zodziwika bwino zogawanitsa maselo, zomwe zidzakambidwe pansipa.

Njira 1: Kuphatikiza Maselo Angapo Oyandikana

Selo patebulo ndi gawo laling'ono kwambiri la kuyeza kotero kuti chinthu chosagawanika. Wogwiritsa ntchito amatha kuyisintha, kuiphatikiza ndi ena oyandikana nawo, koma osawagawa. Komabe, mothandizidwa ndi zidule zina, mutha kupanga kupatukana kowoneka kukhala kowongoka, kopingasa komanso kozungulira. Pogwiritsa ntchito njirayi, mutha kugawa ma cell mu Excel pophatikiza ma cell oyandikana nawo. Algorithm ndi iyi:

• Pezani ma cell oti agawidwe. Mu chitsanzo ichi, kugawidwa mu magawo awiri kudzalingaliridwa.
• Sankhani ma cell awiri oyandikana, dinani "Gwirizanitsani ndi Pakati" mu tabu ya "Kulinganiza".
• Chitaninso chimodzimodzi ndi ma cell ena pamzerewu.

Momwemonso, mutha kugawa magawo osiyanasiyana kupatula awiri. Kupitilira apo, pogwiritsa ntchito machitidwe okhazikika, mutha kusintha kukula kwa ma cell, mizati ndi mizere. Zotsatira zake, mizati yomwe ili pansi pa seloyo idzagawidwa pakati, ndipo chidziwitso cha tebulo chidzapezeka pakati pa selo.

Njira 2: ma cell ophatikizidwa agawanika

Njirayi imagwiritsidwa ntchito kugawa maselo ena patebulo paliponse muzolemba. Muyenera kuchita izi:

• Sankhani mizati kapena mizere mu gulu logwirizanitsa komwe ma cell ogawanika adzakhala. Mu chitsanzo ichi, padzakhala kugawanika ndi mizati.
• Dinani muvi womwe uli pazida pafupi ndi chizindikiro cha Merge and Center ndikusankha Merge By Rows.
• Kuchokera pamizere ya 2 yowoneka bwino imodzi idzatuluka. Kenako, muyenera kupeza zinthu zomwe zidzagawidwe magawo awiri, dinani ndikusankha "Gwirizanitsani ndikuyika pakati."

Momwemonso, mutha kugawa magawo ambiri, koma muyenera kuphatikiza gawo lililonse padera. Ndi njirayi, maselo osankhidwa adzaphatikizidwa kukhala amodzi, ndipo zomwe zili mkati mwake.

Ndikofunika kuzindikira kuti kugawa maselo sikumapindulitsa nthawi zonse. Ndi bwino kugwiritsa ntchito pamene inu muyenera kokha zowoneka kulekanitsa selo. Ngati kusanja ndi ntchito zina zikugwiritsidwa ntchito muzolemba, zinthu zosagwirizana zidzalumphidwa.

Njira 3: Magawo a diagonal cell

Matebulo ambiri angafunike magawano osati vertically ndi yopingasa, koma diagonally. Mutha kupanga magawano a diagonal pogwiritsa ntchito zida zomangidwa mu Excel. Kwa ichi muyenera:

• Dinani kumanja pa chinthu chomwe kugawanika kwa diagonal kumafunika, lowetsani malemba m'mizere iwiri.
• Sankhani "Format Maselo".
• Pazenera lomwe likuwoneka, sankhani tabu "Border". Kenako, zithunzi ziwiri zokhala ndi gawo la diagonal zidzawonekera, muyenera kusankha yoyenera. Mizere ya mzere imatha kusinthidwa ngati pakufunika.
• Dinani kachiwiri pa batani ndi mzere wa diagonal.
• Sungani bwino.

Tcherani khutu! Selo lidzagawidwa mowoneka, koma pulogalamuyo imawona yonse.

Njira 4: Jambulani chogawa ndi chida cha Mawonekedwe

Ntchito yoyika mawonekedwe itha kugwiritsidwanso ntchito pogawanitsa zithunzi pojambula mzere. Algorithm ndi iyi:

• Sankhani chinthu choti mugawe.
• Pitani ku tabu "Ikani" ndikudina "Mawonekedwe".
• Sankhani mtundu wa mzere woyenera kuchokera pamndandanda wazosankha zomwe mukufuna.
• Gwiritsani ntchito batani lakumanzere kuti mujambule cholekanitsa.

Upangiri! Mu tabu ya "Format", mutha kusintha mzere wokokedwa bwino.

Kutsiliza

Kuwerenga ndi chimodzi mwazofunikira pa data iliyonse yokonzedwa. Ngati tebulo liyenera kukhala ndi mawonekedwe ovuta ndi maselo ophatikizidwa kapena ophatikizana, mizere kapena mizati, muyenera kuchita zoyenera. Ngakhale selo ndiye chinthu chaching'ono kwambiri patebulo, zida zomangidwira mu Excel zimakulolani kuti mugawe magawo awiri, 2 kapena kuposerapo paliponse patebulo pogwiritsa ntchito njira zomwe zili pamwambazi.