Kawirikawiri, mukamagwira ntchito ndi Excel spreadsheets, muyenera kusintha kukula kwa maselo. Zikupezeka kuti pali zinthu zosiyana siyana pa pepala. Zoonadi, izi sizili zolondola ndi zolinga zenizeni ndipo nthawi zambiri sizosangalatsa kwa wogwiritsa ntchito. Choncho, funso limayambira momwe angapangire maselo ofanana kukula. Tiyeni tione momwe angagwirizane ndi Excel.
Kugwirizana kwa kukula kwake
Kuti ngakhale kukula kwa maselo pa pepala, muyenera kupanga njira ziwiri: kusintha kukula kwa zipilala ndi mizere.
Kuphatikiza kwa chigawocho kumatha kusiyana pakati pa 0 ndi 255 unit (8.43 mfundo ndi osasinthika), kutalika mzere ndi kuyambira 0 mpaka 409 mfundo (mwaiwo 12.75 maunite). Mbali imodzi ya kutalika ndi pafupifupi masentimita 0.035.
Ngati mukufuna, ma unit of height ndi width akhoza m'malo ndi zina.
- Kukhala mu tab "Foni"dinani pa chinthu "Zosankha".
- Muwindo la Excel zosankha zomwe zimatsegula, pitani ku chinthucho "Zapamwamba". Pakatikati pawindo timapeza choyimira "Screen". Timatsegula mndandanda wa parameter "Units pa mzere" ndipo sankhani chimodzi mwa njira zinayi zomwe mungathe kuchita:
- Centimeters;
- Inchi;
- Milimita;
- Zogwirizana (zosasinthika).
Mutasankha phindu, dinani pa batani "Chabwino".
Choncho, n'zotheka kukhazikitsa mlingo umene wogwiritsira ntchito ali woyenera. Ndilo dongosolo la dongosolo lomwe lidzasinthidwa poyang'ana kutalika kwa mizera ndi m'lifupi la zipilala za chikalatacho.
Njira 1: Kugwirizanitsa maselo m'masankhidwe osiyanasiyana
Choyamba, tiyeni tione momwe angagwirizanitse maselo a mtundu wina, mwachitsanzo, tebulo.
- Sankhani mapepala omwe timakonzekera kuti maselo a selo akhale ofanana.
- Kukhala mu tab "Kunyumba", dinani pa kaboni pa chithunzi "Format"yomwe ili mu chida chogwiritsa ntchito "Maselo". Mndandanda wa zolemba zimatsegulidwa. Mu chipika "Cell Size" sankhani chinthu "Kutalika kwa mzere ...".
- Dindo laling'ono limatsegulidwa. "Kutalika kwa mzere". Timalowa mu munda wokha umene uli nawo, kukula kwake mu maunite omwe amafunidwa kuti asungidwe pa mizere yonse yasankhidwa. Kenaka dinani pa batani "Chabwino".
- Monga mukuonera, kukula kwa maselo omwe ali osankhidwawo ndi ofanana mu msinkhu. Tsopano tifunika kuikamo m'lifupi. Kuti muchite izi, popanda kuchotsa kusankha, kambilani zam'mbuyo pogwiritsa ntchito batani "Format" pa tepi. Nthawi ino mu chipika "Cell Size" sankhani chinthu "Kutalika kwa pulogalamu ...".
- Zenera zimayambira ndendende mofanana ndi momwe zinalili pogawa kutalika kwa mzere. Lowani chigawo chachindunji mu mayunitsi omwe ali mmunda, omwe angagwiritsidwe ntchito pazithunzi zosankhidwa. Timakanikiza batani "Chabwino".
Monga momwe mukuonera, atatha kuchitidwa, magulu a malo omwe anasankhidwa anakhala ofanana mofanana.
Pali njira ina ya njira iyi. Mukhoza kusankha pazowonongeka zojambulazo mazenera awo omwe m'lifupi mwake azikhala ofanana. Kenaka dinani pazenerali ndi batani lamanja la mouse. Mu menyu yomwe imatsegula, sankhani chinthucho "Kutalika kwa pulogalamu ...". Pambuyo pake, zenera zimatsegulira kulowa m'mizere yazithunzi zosankhidwa, zomwe tinakambirana zapamwamba kwambiri.
Mofananamo, pambali yowonongeka, sankhani mizera ya momwe tikufunira. Dinani pomwepo pa gululo, pamasamba otsegulidwa timasankha chinthucho "Kutalika kwa mzere ...". Zitatha izi, zenera zikutsegulira momwe parameter yapamwamba iyenera kulowetsedwa.
Njira 2: ikani maselo a pepala lonse
Koma pali zifukwa pamene kuli kofunikira kulumikiza maselo osati kokha kaunikira, koma pepala lonselonthu. Kuzisankha zonsezo ndizitali, koma pali mwayi wosankha ndi kokha kokha.
- Dinani pamakona omwe ali pakati pa mapepala osakanikirana ndi ofunjika a makonzedwe. Monga momwe mukuonera, patatha izi, pepala lonseli likuperekedwa kwathunthu. Pali njira ina yosankhira pepala lonse. Kuti muchite izi, ingofanizani njira yokhayo yachinsinsi Ctrl + A.
- Pambuyo pa gawo lonse la pepalali tasankhidwa, timasintha m'katikati mwa zipilala ndi kutalika kwa mizera ku kukula kwa yunifolomu pogwiritsa ntchito ndondomeko yomweyi yomwe inafotokozedwa powerenga njira yoyamba.
Njira 3: Kugwedeza
Kuphatikizanso, mungathe kulumikiza mwapang'ono mphamvu ya selo pokoka mizere.
- Sankhani pepala lonse kapena maselo angapo pamphindi wosakanikirana ogwiritsira ntchito njira zomwe tazitchula pamwambapa. Ikani cholozera pamalire a zipilala pazithunzi zosakanikirana. Pachifukwa ichi, mmalo mwa chithunzithunzi chiyenera kuoneka mtanda, pomwe pamakhala mivi iwiri yomwe imayendetsedwa m'njira zosiyanasiyana. Lembani bokosi lamanzere la mouse ndi kukokera malire kupita kumanja kapena kumanzere malingana ndi momwe tikufunikira kuwonjezera kapena kuwachepetsa. Izi zimasintha m'lifupi osati maselo okhawo omwe ali ndi malire omwe mukuwongolera, komanso a maselo ena onse omwe asankhidwa.
Mukamaliza kukoka ndi kumasula bulu la mbewa, maselo osankhidwa adzakhala ndi chiwerengero chofanana ndi chiwerengero chomwecho chomwe mumagwiritsa ntchito.
- Ngati simunasankhe pepala lonselo, sankhani maselo pazowunikira. Mofananamo ndi chinthu chapitalo, gwedeza malire a limodzi la mzere ndi batani la ndondomeko yomwe imagwiritsidwa ntchito mpaka maselo omwe ali mumzerewu akufikira kutalika komwe kumakukhutitsani. Kenaka kumasula batani la mbewa.
Pambuyo pazigawozi, zinthu zonse zadasankhidwa zidzakhala zofanana ndi selo limene munachita kupusitsa.
Njira 4: onjezani tebulo
Ngati mumaphatikiza tebulo lokopera pa pepala mwachizoloŵezi, ndiye kuti kawirikawiri zipilala zazowonjezera zidzakhala zosiyana. Koma pali chinyengo kuti mupewe izi.
- Sankhani tebulo yomwe mukufuna kufotokozera. Dinani pazithunzi "Kopani"yomwe imayikidwa pa mpiru mu tab "Kunyumba" mu chigawo cha zipangizo "Zokongoletsera". Mwinanso mungathe kuchita izi pambuyo poti musankhe kuti muyimire pa njira yachinsinsi Ctrl + C.
- Sankhani selo pa pepala limodzi, pa pepala lina kapena mu bukhu lina. Selo ili liyenera kukhala pamwamba kumanzere gawo la tebulo lolowetsedwa. Dinani botani lamanja la mouse pa chinthu chosankhidwa. Menyu yamakono ikuwonekera. Mmenemo timapita pa chinthucho "Kuika Mwapadera ...". Mu menyu owonjezera omwe akuwoneka pambuyo pa izi, dinani, kachiwiri, pa chinthucho ndi dzina lomwelo.
- Zowonjezera zowonjezera zenera zikutsegula. Mu bokosi lokhalamo Sakanizani kusinthitsa kusinthana ku malo "Kuphatikizana kwazomwe ". Timakanikiza batani "Chabwino".
- Pambuyo pake, pa ndege ya pepala, maselo ofanana nawo adzaikidwa pamodzi ndi a tebulo lapachiyambi.
Monga momwe mukuonera, mu Excel, pali njira zingapo zomwe zimayanjanitsana kuti zikhazikitse maselo ofanana ndi selo, monga mndandanda wapadera kapena tebulo, ndi pepala lonse. Chinthu chofunikira kwambiri pakuchita njirayi ndi kusankha bwino mtundu, kukula kwake komwe mukufuna kusintha ndi kubweretsa mtengo umodzi. Zowonjezera magawo a kutalika ndi kupingasa kwa maselo akhoza kugawidwa mu mitundu iwiri: kukhazikitsa mtengo wapadera mu mayunitsi omwe amasonyezedwa mu manambala ndi zolemba zokoka zolemba. Wogwiritsa ntchito mwiniwakeyo amasankha njira yowonjezera yowonjezera, muzitsulo zomwe zili bwino.
