Momwe mungasinthire mizere mu Excel

Nthawi zambiri, kusiyana kwa mizere kumakhala kosangalatsa kwa anthu okhawo omwe amagwira ntchito ndi purosesa ya mawu a Microsoft Word. Komabe, nthawi zina, kutha kuchita izi kumakhala kothandiza mu Excel. Mwachitsanzo, ngati mtundu wa tebulo umafuna makonzedwe ophatikizika a zinthu zonse, kapena mosemphanitsa, chokulirapo. Lero tifotokoza mwatsatanetsatane momwe mungasinthire masitayilo a mzere mu Excel. Palibe chovuta pa izi, ingodinani mabatani angapo ndikudina pang'ono mbewa kuti mukwaniritse cholinga chanu. Mutha kuchepetsa ndikuwonjezera mizere yotalikirana, komanso kuphunzira momwe mungasinthire mosasamala pogwiritsa ntchito chida "cholemba".

Momwe mungasinthire kusiyana kwa mizere

Kusintha kagawo ka mizere kumatanthauza kuwonjezera kapena kuchepetsa. Ntchitoyi ikuchitika kudzera pa menyu yankhani. Kenako, zenera la zoikamo lidzatsegulidwa, komwe mungathenso kupanga zosankha zina.

Vutoli likhoza kuchitika ngati khwekhwe idachitika zokha. Monga lamulo, mutatha kuyika malemba molakwika, mizere ikhoza kuikidwa patali kwambiri. Chifukwa chake ndi chophweka - chiwerengero chachikulu cha ma tag opangira omwe ali muzolemba zoyambira. Kuti mupewe vutoli, muyenera kugwiritsa ntchito ntchito zapadera zomwe zimachotsa ma tag osafunika kapena kuchotsa masanjidwe osafunika.

Muthanso kuyeretsa ma cell pogwiritsa ntchito zida zomangidwa mu Excel. Ndiyenera kunena kuti sizinthu zonse zomwe zingatheke zokha. Zina mwa izo, kuphatikizapo kuchepetsa mizere, ziyenera kuchitidwa paokha. Tiyeni tione mwatsatanetsatane mmene tingachitire zimenezi.

Momwe mungachepetsere mizere?

Izi ndizofala kwambiri zomwe wogwiritsa ntchito Excel ayenera kuthana nazo. Choncho tiyeni tione kaye. Kuti mukonze, muyenera kuyatsa njira imodzi yokha. Ndipo ndondomeko ya masitepe ili motere:

1. Dinani kumanja kwa mbewa pa selo lomwe tikufunika kukonza. 
2. Pambuyo pake, menyu imawonekera pomwe tiyenera kupita kugawo la "Format Cells". 
3. Izi zidzatsegula bokosi la zokambirana lomwe lili ndi ma tabo ambiri. Tili ndi chidwi ndi menyu ya "Alignment", kotero timakulitsa njira yofananira. Pambuyo pake, sankhani zosankha zomwe zili pazithunzi. Ndiye kuti, sankhani njira "m'mphepete mwapamwamba" mumenyu yomwe ili ndi rectangle yofiira. 

Pambuyo pake, timatsimikizira zochita zathu ndikutseka zenera. Tidzawona zotsatira zake nthawi yomweyo. Titapeza zotsatira zokhutiritsa, tifunika kuchepetsa mzere woyenerera kuti ukhale wofanana ndi kutalika kwenikweni kwa malemba omwe ali mu selo lathu. 

Momwe mungakulitsire mizere yotalikirana

Zomwe timafunikira kukulitsa mizere yotalikirana ya selo ndipamene tiyenera kutambasula mawu kutalika kwa selo. Kuti muchite izi, muyenera kutsatira njira zomwezo, kupatula magawo ena.

Choyamba, tiyenera kudina kumanja pa selo lomwe tikufuna kusintha. Kenako, sankhani kusankha Maselo a Format kuchokera pamenyu yankhani. Pambuyo pake, sankhani njira yolumikizira yokhazikika "mofanana".

Pambuyo pake, timatsimikizira zochita zathu ndikuyang'ana zotsatira zake. Tikuwona kuti malembawo ali pamtunda wonse wa selo. Pambuyo pake, posintha kukula kwake, mutha kusintha masitayilo a mzere momwe mukufunira. 

Njira imeneyi silola kusinthasintha koteroko kuonjezera katayanidwe ka mizere, koma imalola kugwiritsa ntchito mafomu.

Momwe mungakutire zilembo za cell

Koma bwanji ngati mukufunika kusintha masitayilo a mizere bwino kwambiri? Pankhaniyi, zinthu zapadera ziyenera kuchitidwa. Pankhaniyi, sipadzakhala malemba omangiriza patebulo, ndipo mutha kukhazikitsa magawo aliwonse. Kuti muchite izi, muyenera kumangirira chizindikirocho ku selo. Kutsatira kwa zochita ndi motere:

1. Sankhani selo ndikudula. Kuti muchite izi, mutha kugwiritsa ntchito menyu yankhani, batani lapadera pazida, kapena kuphatikiza kiyi Ctrl + X. 
2. Pambuyo pake, tsegulani tabu ya "Insert", yomwe ili mumenyu yayikulu pamwamba pawindo la pulogalamu. Pambuyo pake, tiyenera kukulitsa bokosi la "Text" kapena kuyang'ana ngati kukula kwawindo kuli kokwanira ndipo sikuyenera kukulitsidwa. 
3. Pambuyo pake, dinani batani "Zolemba" podina chinthu choyenera. 
4. Kenako dinani batani lakumanzere ndikuigwira. Izi ziyenera kuchitika pamalo omwe padzakhala ngodya yakumanzere yakumanzere kwa zolemba zamtsogolo. Pambuyo pake, timapanga chipika cholembera cha kukula komwe tikufuna, pogwiritsa ntchito cholozera, kusuntha diagonally kumanja ndi pansi. Pambuyo pake, chipika chidzapangidwa m'malo mwa selo, momwe tidzafunika kulowamo. 
5. Lowetsani zolemba pogwiritsa ntchito njira iliyonse yomwe ingatheke: kugwiritsa ntchito makiyi a Ctrl + V, chida kapena menyu yankhani. 
6. Kenako timadina kumanja palemba lathu ndikusankha chinthu cha "Ndime". 
7. Kenako, m'bokosi la zokambirana lomwe likuwoneka, muyenera kupeza njira ya "Interval" ndikukhazikitsa kukula kwake kuti zigwirizane ndi vuto lanu. Pambuyo pake, dinani batani "Chabwino". 
8. Kenako, mutha kuwona zotsatira zake. Ngati sichikukhutiritsa, imatha kusinthidwa pogwiritsa ntchito makiyi a Ctrl + Z. 

Njirayi ili ndi vuto limodzi. Miyezo yomwe idzakhale mu selo yoteroyo singagwiritsidwe ntchito m'ma formula, ndipo mafomu sangathe kuyikidwa mu selo ili.

Tikuwona kuti palibe chovuta kusintha mizere mu Excel. Ndikokwanira kukanikiza mabatani angapo, pamene timapeza zotsatira zomwe tikufuna. Tikukulimbikitsani kuti mupange chikalata choyesera ndikuchita malangizo omwe ali pamwambapa. Izi zidzakuthandizani kuti musasocheretse pamene mukufunikira kugwiritsa ntchito mbaliyi pa ntchito yeniyeni. Njira iliyonse yomwe tafotokozayi ili ndi ubwino ndi zovuta zake, zomwe ziyenera kuganiziridwa panthawi yogwiritsira ntchito.