Kukula kwa Ma cell ku Microsoft Excel

Nthawi zambiri, zomwe zili mu tebulo sizikhala mgawo lomwe limakhazikitsidwa mwachangu. Potere, nkhani yakukula kwawo imakhala yofunika kuti chidziwitso chonse chikwanire ndipo chiri pamaso pa wogwiritsa ntchito. Tiyeni tiwone momwe mungachitire izi mu Excel.

Njira yowonjezera

Pali njira zingapo zokulitsira maselo. Zina mwazomwe zimapereka kuwunikira kwa malire ndi ogwiritsa ntchito, ndipo mothandizidwa ndi ena ndizotheka kukhazikitsa machitidwewa kutengera kutengera kutalika kwake.

Njira 1: ingokokerani ndikugwetsa malire

Chophweka chosavuta komanso chofunikira kwambiri kukulitsa kukula kwa khungu ndikukoka malire pamanja. Izi zitha kuchitika pamilingo yolunjika komanso yopingasa ya mizere ndi mizati.

1. Timayika cholowera kumalire am'magawo pamlingo woyanjanitsa wolumikizana womwe tikufuna kukulitsa. Mtanda umawonekera mbali ziwiri. Gwirani batani lakumanzere ndikusunthira malire kudzanja lamanja, ndiye kuti, kutali ndi pakati pa selo lomwe mungakulitseko.



2. Ngati ndi kotheka, njira yofananira imatha kuchitika ndi zingwe. Kuti muchite izi, ikani cholozera pamalire akumunsi a mzere womwe muti mukulitse. Momwemonso, gwiritsani batani lakumanzere ndikukokera malire.

Yang'anani! Ngati mukuyika cholozera kumanzere kumanzere kwa chingwe cholumikizidwa pamlingo wolumikizana wolumikizana, ndi pamalire a mzere kumtunda, kugwiritsa ntchito kukokera ndikugwetsa, kukula kwa maselo omwe akulimbana sikukukula. Amangoyenda kumbali posintha kukula kwa zinthu zina za pepalalo.

Njira 2: kukulitsa mizati ndi mizere yambiri

Palinso mwayi wowonjezera mizati yambiri kapena mizere nthawi imodzi.

1. Timasankha magawo angapo nthawi imodzi pamlingo woyendetsedwa komanso wolunjika pamgwirizano.



2. Timayika cholowera kumalire am'manja a khungu lamanja lamanja (kwa mulingo wopingasa) kapena kumalire am'munsi a khungu lotsika kwambiri (pamakona ofikira). Gwirani batani lakumanzere ndikukoka muvi womwe umawonekera, motero, kumanja kapena pansi.



3. Chifukwa chake, sikuti malo okhawo owonjezera amakulitsidwa, komanso maselo a malo osankhidwa onse.

Njira 3: ikani pamanja kukula pamasamba omwe mukuwunika

Mutha kuyikanso pamanja kukula kwamaselo, oyeza mu manambala. Pokhapokha, kutalika kwake ndi magawo 12.75 ndipo m'lifupi ndi magawo 8.43. Mutha kuwonjezera kutalika mpaka kufika pamlingo 409, ndipo m'lifupi kufika 255.

1. Kuti musinthe magawo onse a khungu, sankhani mawonekedwe ofunikira pamlingo wopingasa. Timadulira pomwepo ndi batani la mbewa. Pazosankha zomwe zikuwoneka, sankhani M'lifupi.



2. Iwindo laling'ono limatseguka pomwe mukufuna kukhazikitsa gawo lolingana lachigawo mu mayunitsi. Lowetsani kukula kofunikira kuchokera pa kiyibodi ndikudina batani Chabwino.

Momwemonso, kutalika kwa mzere kumasinthidwa.

1. Sankhani gawo kapena mulingo wofanana wolumikizana. Timadulira gawo ili ndi batani loyenera la mbewa. Pazosankha zofanizira, sankhani "Kutalika kwa mzere ...".



2. A zenera limatseguka pomwe muyenera kuyendetsa maselo ofunikira amtundu wosankhidwa mumayunitsi. Timachita izi ndikudina batani "Zabwino".

Zomwe zili pamwambazi zimakupatsani mwayi kuti muwonjezere kutalika ndi kutalika kwa maselo m'magawo a muyeso.

Njira 4: lowetsani kukula kwa khungu kudzera pabatani

Kuphatikiza apo, ndikotheka kukhazikitsa kukula kwakutali kwa khungu kudzera pa batani la riboni.

1. Sankhani maselo omwe kukula kwake akufuna kukhala pa pepalalo.



2. Pitani ku tabu "Pofikira"ngati tili wina. Dinani pa batani la "Fomati", lomwe lili pa riboni mu gulu la zida "" Cell ". Mndandanda wa zochita umatseguka. Sankhani zinthu m'malo mwake "Kutalika kwa mzere ..." ndi "M'lifupi mwake". Mukadina chilichonse mwazinthu izi, mawindo ang'ono adzatsegulidwa, omwe amafotokozedwa mwanjira yapita. Adzafunika kulowa mulifupi ndi kutalika kwa maselo osankhidwa. Kuti maselo azikula, mtengo watsopano wa magawoli uyenera kukhala waukulu kuposa womwe udalipo kale.

Njira 5: kukulitsa kukula kwa maselo onse mu pepala kapena buku

Pali nthawi zina pamene muyenera kuwonjezera mwamtheradi maselo onse a pepala kapena buku. Tiyeni tiwone momwe angachitire.

1. Kuti amalize kugwira ntchitoyi, ndikofunikira, choyamba, kuti muwunikire zinthu zofunika. Kuti musankhe zinthu zonse za pepalali, mutha kungodinikiza njira yaying'ono pa kiyibodi Ctrl + A. Pali njira yachiwiri yosankhira. Zimaphatikizapo kuwonekera pa batani mu mawonekedwe a rectangle, lomwe lili pakati pamlingo wokhazikika komanso wolondola wa ma Excel organistates.



2. Mukasankha pepala mwanjira iliyonse mwa izi, dinani batani lomwe tikudziwa kale "Fomu" pa tepiyo ndikuchita zinthu zina monga momwe tafotokozera kale ndi momwe zinthuzo ziriri "M'lifupi mwake" ndi "Kutalika kwa mzere ...".

Timachitanso zofanana kuti tiwonjezere kukula kwa maselo a buku lonse. Kungosankha ma sheet onse omwe timagwiritsa ntchito njira ina.

1. Timadina pomwe pamndandanda wa masamba aliwonse, omwe amakhala pansi pazenera pomwe pamwamba pa bar. Pazosankha zomwe zimapezeka, sankhani "Sankhani ma sheet onse".



2. Mapepala atasankhidwa, timachita pa tepi pogwiritsa ntchito batani "Fomu"omwe amafotokozedwa munjira yachinayi.

Phunziro: Momwe mungapangire maselo ofanana mu Excel

Njira 6: Kukula kwa Auto Fit

Njirayi singatchulidwe kuwonjezereka kokwanira mu kukula kwa maselo, komabe, zimathandizanso kuti malembawo agwirizane bwino ndi malire. Ndi chithandizo chake, zilembo zimasinthidwa zokha kuti zigwirizane. Chifukwa chake, titha kunena kuti kukula kwake kogwirizana ndi lembalo kukukulira.

1. Sankhani mtundu womwe tikufuna kugwiritsa ntchito upangiri wamagalimoto ofanana. Dinani pa kusankha ndi batani la mbewa yoyenera. Zosankha zam'mawu zimatsegulidwa. Sankhani zomwe zili mmenemo "Mtundu wamtundu ...".



2. Tsamba losintha likutsegulidwa. Pitani ku tabu Kuphatikiza. Mu makatani "Onetsani" onani bokosi pafupi ndi paramayo "Kukula Kwazoyenda". Dinani batani "Zabwino" pansi pazenera.

Pambuyo pa izi, ziribe kanthu kuti mbiriyo imakhala yayitali bwanji, koma imayenerana ndi selo. Zowona, muyenera kulingalira kuti ngati pali zilembo zambirimbiri papepala, ndipo wosuta sazikulitsa mu imodzi mwanjira zapita, ndiye kuti mbiriyi ikhoza kukhala yaying'ono kwambiri, ngakhale yosawerengeka. Chifukwa chake, kukhala wokhutira ndi izi mwanjira imeneyi kuti mukwaniritse deta m'malire sikuvomerezeka nthawi zonse. Kuphatikiza apo, ziyenera kunenedwa kuti njirayi imagwira ntchito ndi zolemba zokha, koma osati ndi manambala.

Monga mukuwonera, pali njira zingapo zokulitsira kukula kwa maselo amodzi ndi magulu athunthu, mpaka kukulitsa zinthu zonse za pepala kapena buku. Wogwiritsa ntchito aliyense amasankha njira yabwino kwambiri yopangira njirayi m'njira zina. Kuphatikiza apo, pali njira ina yowonjezeramo zokwanira mkati mwa foni pogwiritsa ntchito mulifupi woyenerera. Zowona, njira yotsirizirayi ili ndi malire ake.