Momwe mungagawire cell kukhala ma cell angapo mu Excel

Mwachikhazikitso, palibe chida chomwe chingathandize kugawa ma cell mu Excel. Chifukwa chake, ngati pakufunika kupanga mutu wovuta wa tebulo, muyenera kugwiritsa ntchito zidule zingapo. Athandiza kulekanitsa ma cell a Excel popanda kusokoneza zomwe zili pamatebulo. Pachifukwa ichi, timagwiritsa ntchito njira zingapo.

Njira yoyamba: kuphatikiza kotsatiridwa ndi kusiyanitsa

Tisanayambe ndondomekoyi, tiyeni tiganizire mozama za dongosolo la tebulo. Ndikoyenera ngakhale kujambula papepala. Tsopano tiyeni titembenukire ku kusintha kwapang'onopang'ono kwa pepala la Excel:

1. Sankhani maselo awiri kapena atatu pamzere woyamba m'dera lomwe tebulo lidzakhala.

2. Pitani ku "Home" tabu, yang'anani chipika cha "Malumikizidwe", dinani pa "Merge and Center" chida.

3. Tikuwona kuti magawo omwe adasankhidwa asowa. Choncho, zenera limodzi lolimba linatulukira. Kuti tiwone bwino, tiyeni tipange malire omveka bwino. Kuti muchite izi, mu block "Font", gwiritsani ntchito chida cha "All Borders".

4. Tsopano sankhani mizati pansi pa maselo ophatikizidwa ndikuyika mizere m'mphepete mwa maselo mofanana. Monga mukuonera, maselo ogawanika amapezeka, ndipo gawo lapamwamba, losankhidwa pansi pamutu, silisintha kukhulupirika kwake.

Mofananamo, mukhoza kupanga mutu wamitundu yambiri ndi chiwerengero chopanda malire cha maselo ophatikizidwa m'malo osiyanasiyana pa tsamba.

Njira Yachiwiri: Kugawa Maselo Ophatikizidwa Kale

Tiyerekeze kuti tebulo lathu lalowa kale m'mawindo a Microsoft Excel. Koma tidzawaphatikiza atangotsala pang'ono kugawanika kuti timvetse bwino chitsanzo cha malangizo omwe aperekedwa. Pambuyo pake, zidzakhala zotheka kuwalekanitsa kuti apange mutu wamapangidwe a tebulo. Tiyeni tiwone momwe izi zimachitikira muzochita:

1. Sankhani mizati iwiri yopanda kanthu mu Excel. (Iwo akhoza kukhala ochulukirapo, malinga ndi zosowa). Kenako dinani chida "Gwirizanitsani ndikuyika pakati", chili mu chipika cha "Malumikizidwe". Dinani "Phatikizani Maselo".

2. Tikayika malire mwachizolowezi kwa ife (monga gawo lapitalo). Tiyenera kupeza mtundu wa tabular. Momwe zidzawonekere pafupifupi, mutha kuwona pazithunzi:

3. Kuti tigawane zenera lalikulu lomwe limakhala m'maselo, tidzagwiritsa ntchito chida chomwecho cha Merge ndi Center. Pokhapokha, podutsa pa bokosi loyang'ana, timasankha "Onjezani Maselo" - omwe ali otsiriza pamndandanda wa zida. Musaiwale kusankhatu mtundu wa e-book womwe uyenera kusankhidwa.

4. Gome litenga mawonekedwe omwe tikufuna. Magawo osankhidwa okha ndi omwe agawidwa ndi kuchuluka kwa ma cell omwe anali asanaphatikizidwe. Simungathe kuwonjezera chiwerengero chawo.

Zolemba! Zikuwonekeratu kuti tikamagawa, sitipeza zenera limodzi, koma ziwiri zosiyana. Choncho, polowetsa deta kapena, makamaka, njira zowerengera, ganizirani izi.

Njira yachitatu: kugawa ma cell diagonally

Kugawanika kwa diagonal kumachitika ndi masanjidwe. Mfundo imeneyi imaphatikizapo kulekanitsa maselo wamba, mogwirizana ndi zomwe masanjidwe sanagwiritsidwe.

1. Sankhani cell yomwe mukufuna m'munda wa Excel sheet, kenako dinani pomwepa kuti mubweretse menyu yankhaniyo. Mmenemo timapeza chida cha "Format Cells".

2. Pazenera lomwe limatsegulidwa, pitani ku tabu "Border". Kumanzere, sankhani mzere wa diagonal, ndiyeno dinani OK batani. Kumanja mungapeze mzere womwewo, koma mosiyana.

3. Kumanzere, pali zida zosinthira momwe tingasankhire mtundu wa mzere kapena kusintha mthunzi wa malire.

4. Zida izi zimathandizira kupanga makonda.

Komabe, selo logawidwa motere likadali chida chimodzi, choncho, kuti mulowetse deta kuchokera pansi ndi pamwamba pake, muyenera kutambasula selo ndikusankha font yoyenera kuti igwirizane bwino ndi zolembazo.

Zolemba! Ngati mutenga selo ndikulikokera pansi, ndiye kuti mazenera ena m'mizere kapena mizati amatenga mawonekedwe omwewo. Zonse zimatengera komwe kusesa kudzachitikire (pansi kapena mbali).

Njira XNUMX: kugawanika kwa diagonal polowetsa

Mwanjira iyi, tikupangira kugwiritsa ntchito njira yomwe imayenera kuyikapo mawonekedwe a geometric. Momwe zimagwirira ntchito, tikufuna kuti tiganizire m'bukuli.

1. Sankhani selo limodzi lomwe mukufuna kuyika cholekanitsa, kenako pitani ku tabu "Ikani", kenako pezani gawo la "Zithunzi", dinani "Mawonekedwe".

2. Mndandanda wamawonekedwe omwe angagwiritsidwe ntchito amatsegula. Mmenemo timapeza gawo la "Mizere" ndikudina pa mzere wa diagonal.

3. Kenako timajambula mzerewu mu cell yomwe tikufuna. Mogwirizana ndi izi, titha kugwiritsa ntchito njira zosiyanasiyana zosinthira: sinthani mthunzi, makulidwe, mtundu wa mzere, lowetsani zotsatira.

Pambuyo pojambula mizere, sikutheka kulemba malemba kumbali zonse za mzere wozungulira. Chifukwa chake, kulowetsa zolemba kapena manambala ndikofunikira musanajambule. Kuti mzerewo ugwirizane pambuyo pake osati "kudula" malembawo, m'pofunika kugwiritsa ntchito bwino malo ndi "Lowani".

Zolemba! Njira yabwino ndikupanga tebulo ndi mitundu yofunidwa yamaselo mu Mawu, kenako ndikusintha kukhala Excel.

Mwachidule

Kugawanitsa ma cell mu Microsoft Excel eBook ndi njira yosavuta komanso yothandiza, koma muyenera kuganizira kuti ndizovuta kusintha mu mtundu womalizidwa. Choncho, ife mwamphamvu amalangiza kuti kulowa deta pamaso siteji ya akatembenuka zenera awiri kapena kuposa. Komanso, mutha kungosintha mtundu womwe mukufuna ngati tebulo, mutayiyika mugawo loyenera. Njira yabwinoko komanso yabwino ndikujambula malire pamanja.