Momwe mungapangire ma bele overl: Malangizo atsatanetsatane

Ndi owerengeka omwe adzakonda extly ext munso kapena mtundu womwewo patebulo. Ichi ndi ntchito yotopetsa kwambiri, kutola nthawi yayitali. Pulogalamu ya Excel imatha kuyendetsa ntchito yolowera. Izi zimapereka ntchito ya Autocry wa maselo. Tiyeni tiwone momwe zimagwirira ntchito.

Kugwiritsa Ntchito Autofill Kupambana

Autocomplette mu Microsoft Excel imachitika pogwiritsa ntchito cholembera chapadera chodzaza. Kuti muyitanidwe ndi chida ichi, muyenera kubweretsa cholozera mpaka m'mphepete mwa chipinda chilichonse. Padzakhala mtanda wakuda wakuda. Ichi ndi cholembera. Muyenera kungogwira batani lakumanzere ndikukoka pepalalo pamwamba pomwe mukufuna kudzaza maselo.

Maselo adzathamangitsidwa amatengera mtundu wa deta yomwe ili mu chipinda choyambirira. Mwachitsanzo, ngati pali mawu abwinobwino mu mawu, ndiye kujambula pogwiritsa ntchito cholembera, limakopedwa m'maselo ena a pepalalo.

Kudzaza kwa Auto kwa manambala

Nthawi zambiri autofill imagwiritsidwa ntchito polowa manambala ambiri omwe amatsatira. Mwachitsanzo, mu chipinda china pali nambala 1, ndipo tikufunika kuwerengetsa maselo kuyambira 1 mpaka 100.

1. Yambitsani cholembera ndikuzigwiritsa ntchito pamaselo ofunikira.



2. Koma, monga tikuwona, chiwalo chokhacho chinajambulidwa kumaselo onse. Dinani pa chithunzi, chomwe chimachokera kumanzere kwa malo omalizidwa ndipo amatchedwa "magawo odzaza ndi auto".



3. Pa mndandanda womwe umatseguka, khazikitsani zosinthira ku "Dzazani".

Monga tikuwona, zitachitika izi, mtundu wonse wofunikira udadzazidwa ndi manambala.

Koma zitha kuchitika mosavuta. Simuyenera kuyitanitsa maofesi a Auckhomptte. Kuti muchite izi, zikwangwani ziwonetsero zikakhala pansi, kenako pambali pa batani lakumanzere, muyenera kugwira batani la CTRL pa kiyibodi. Pambuyo pake, kudzazidwa kwa maselo mu dongosolo kumachitika nthawi yomweyo.

Palinso njira yopangira matoocopeter kuchuluka.

1. Timadziwitsa anthu oyandikana nawo oyandikira manambala awiri oyamba.



2. Tikuwatsimikizira. Kugwiritsa ntchito chizindikiro chodzaza timayambitsa deta ku maselo ena.



3. Monga tikuwona, manambala osasinthasintha amapangidwa ndi gawo lopatsidwa.

Chida "Dzazani"

Pulogalamu ya Excel imakhalanso ndi chida chotchedwa "Dzazani". Imapezeka pa riboni "kunyumba" m'zida za chida.

1. Timadziwitsa za khungu lililonse, kenako osasankha ndi maselo osiyanasiyana omwe adzaza.



2. Dinani batani "Dzazani". Pa mndandanda womwe umawonekera, sankhani malangizo omwe maselo ayenera kudzazidwa.



3. Monga momwe tikuonera, izi zitatha izi, zomwe zimachokera ku khungu limodzi zimakopedwa mwa ena onse.

Ndi chida ichi, muthanso kudzaza maselo akumiyala.

1. Timalowetsa nambala mufoni ndikugawa maselo osiyanasiyana omwe adzazidwe ndi deta. Tadina batani "Dzazani", ndipo mndandanda womwe umawonekera, sankhani "zopitilira".



2. Windo la Regiglups Piritsi limatseguka. Apa mukufunika kupanga zingapo zatsoka:
   • Sankhani malo omwe akudutsa (pazingwe kapena mizere);
   • Lembani (geometric, masamu, madeti, autofoll);
   • Khazikitsani sitepe (mwa kusinthika ndi 1);
   • Khazikitsani mtengo wa malire (njira yosankha).

   Kuphatikiza apo, nthawi zina, mayunitsi amakhazikitsidwa.

   Zikhazikiko zonse zikapangidwa, dinani batani la "OK".



3. Monga mukuwonera, zitatha izi, maselo odzipereka onse odzipereka amadzazidwa molingana ndi malamulo omwe mwakhazikitsa.

Foofill Fores

Chimodzi mwa zida zazikuluzikulu ndi njira. Ngati pali chiwerengero chachikulu mu tebulo la mapangidwe omwewo, mutha kugwiritsanso ntchito ntchito yokwanira. Tanthauzo silisintha. Ndikofunikira kukopera formula maselo ena chimodzimodzi. Nthawi yomweyo, ngati formula imakhala ndi malembedwe ena, kenako mosasinthika potengera njirayi imasintha malinga ndi mfundo za kugonana. Chifukwa chake, maulalo oterowo amatchedwa wachibale.

Ngati mukufuna kukhazikitsidwa ndi adilesi, ndiye kuti muyenera kuyika chikwangwani cha madola kutsogolo kwa mizere ndi mizata. Maulalo oterowo amatchedwa mtheradi. Kenako, njira yolowera ku Autofill imachitika pogwiritsa ntchito chikhomo chodzaza. M'maselo onse odzazidwa motere, njirayi idzasinthidwa mwamtheradi.

Phunziro: Maulalo ndi ogwirizana ndi ogwirizana

Autocombresste ndi ena

Kuphatikiza apo, pulogalamu ya Excel imapereka ma autofill ndi zina zomwe zikugwirizana. Mwachitsanzo, ngati mungalowe tsiku lina, kenako ndikugwiritsa ntchito cholembera, sankhani maselo ena, ndiye kuti mitundu yonse yomwe yasankhidwa idzadzaza ndi masiku okhazikika.

Momwemonso, ndizotheka kupanga maphwando pa sabata (Lolemba, Lachiwiri, Lachitatu ...) kapena pofika miyezi (Januware, March ...).

Komanso, ngati pali manambala mu lembalo, ndiye kuti apambana. Mukamagwiritsa ntchito cholembera, padzakhala kuti mulembe mawu ndi kusintha kwa zomwe zinachitika. Mwachitsanzo, ngati mukulemba mawu akuti "Miss" mu khungu, kenako m'maselo ena odzaza ndi cholembera, dzinali lidzasinthidwa kukhala "Nyumba 5", "7 mlandu", etc.

Kuwonjezera mndandanda wanu

Mphamvu ya Autofill ntchito ku Excel sizingokhala ndi ma algorithms ena kapena mndandanda wokhazikitsidwa, monga, mwachitsanzo, masiku sabata. Ngati mukufuna, wogwiritsa ntchitoyo akhoza kuwonjezera mndandanda wa pulogalamuyo. Kenako, polembera ku khungu la mawu aliwonse ochokera ku zinthu zomwe ali mndandandandawo, mutatha kugwiritsa ntchito cholembera, maselo angapo osankhidwa adzazidwa ndi mndandandawu. Kuti muwonjezere mndandanda wanu, muyenera kuchita zinthu zingapo.

1. Timasinthira ku "fayilo" tabu.



2. Pitani ku "magawo".



3. Kenako, timasamukira ku gawo "lakutsogolo".



4. Mu "General" zosintha mu chapakati pazenera timadina pa "kusintha kwamindandanda ..." batani.



5. Mndandanda wa mindandanda amatsegulidwa. M'gulu lamanzere pali mndandanda womwe ulipo kale. Kuti muwonjezere mndandanda watsopano, lembani mawu omwe mukufuna mu "mndandanda" womwe ulipo ". Chilichonse chomwe chimayenera kuyamba ndi mzere watsopano. Pambuyo pa mawu onse alembedwa, dinani pa batani la "Onjezani".



6. Pambuyo pake, zenera lamelo limatseka, ndipo zikatsegulira, wogwiritsa ntchito adzatha kuwona zinthu zomwe zidawonjezera kale mu zenera logwira.



7. Tsopano, mutatha kupanga liwu mu seloni iliyonse ya pepalalo, lomwe linali la mndandanda wa mndandanda wowonjezerapo, ndipo gwiritsani ntchito chizindikiro chokwanira, maselo osankhidwa adzazidwa ndi zilembo zofananira.

Monga mukuwonera, kutola kwambiri ndi chida chothandiza kwambiri komanso chosavuta chomwe chimakupatsani mwayi wosunga nthawi yowonjezera nthawi yowonjezera yomwe ili ndi ndalama zofananira, etc. Ubwino wa chida ichi ndikuti ndichikhalidwe. Mutha kupanga mindandanda yatsopano kapena kusintha zakale. Kuphatikiza apo, mothandizidwa ndi Autofill, ndizotheka kudzaza maselo okhala ndi njira zosiyanasiyana zamatumbo.