Kumaliza ma cell mu Excel

Maselo a Autocomplete mu Excel amakupatsani mwayi wofulumizitsa kulowa kwa data patsamba lantchito. Zochita zina mu Microsoft Excel ziyenera kubwerezedwa kangapo, zomwe zimatenga nthawi yambiri. Ndi kupanga ntchito zotere kuti ntchito ya autocomplete idapangidwa. Mu phunziro ili, tiwona njira zodziwika bwino zodzaza zokha: kugwiritsa ntchito chikhomo ndi kudzaza kwa flash, zomwe zidawonekera koyamba mu Excel 2013.

Kugwiritsa ntchito chizindikiro cha autofill mu Excel

Nthawi zina mumayenera kukopera zomwe zili m'maselo angapo oyandikana nawo patsamba. Mutha kukopera ndi kumata deta mu selo iliyonse payekha, koma pali njira yosavuta. Kuti muchite izi, muyenera kugwiritsa ntchito chogwirira cha autocomplete, chomwe chimakupatsani mwayi wokopera ndikumata mwachangu.

1. Sankhani foni yomwe mukufuna kubwereza. Malo ang'onoang'ono adzawonekera kumunsi kumanja kwa selo losankhidwa - ichi ndi chizindikiro cha autofill.
2. Dinani ndikugwira batani lakumanzere la mbewa ndikukokera chogwirizira chodzaza zokha mpaka ma cell onse ofunikira awonetsedwa. Nthawi yomweyo, mutha kudzaza ma cell a mzere kapena mzere.
3. Tulutsani batani la mbewa kuti mudzaze ma cell osankhidwa.

Kudzaza Ma Sequential Data Series mu Excel

Chizindikiro cha autocomplete chingagwiritsidwe ntchito nthawi iliyonse yomwe mukufuna kudzaza deta yomwe ili ndi dongosolo lotsatizana. Mwachitsanzo, kutsatizana kwa manambala (1, 2, 3) kapena masiku (Lolemba, Lachiwiri, Lachitatu). Nthawi zambiri, mudzafuna kusankha ma cell angapo musanagwiritse ntchito cholembera kuti muthandizire Excel kudziwa momwe amayendera.

Chitsanzo chomwe chili pansipa chimagwiritsa ntchito chizindikiro cha autocomplete kuti mupitilize kutsatizana kwa masiku pamndandanda.

Instant Lembani mu Excel

Excel 2013 ili ndi njira yatsopano ya Flash Fill yomwe ingalowetse deta mumasamba, ndikukupulumutsirani nthawi ndi khama. Monga AutoComplete, njirayi imayang'anira mtundu wanji wazomwe mumalemba patsamba lantchito.

Muchitsanzo chomwe chili pansipa, timagwiritsa ntchito Flash Fill kupanga mndandanda wa mayina kuchokera pamndandanda womwe ulipo wama imelo.

1. Yambani kulowetsa deta pamasamba. Pamene Flash Fill ipeza pateni, chithunzithunzi chazosankhacho chimawonekera pansi pa cell yomwe yawonetsedwa.
2. Dinani Enter. Zambiri zidzawonjezedwa papepala.

Kuti musinthe kapena kusintha zotsatira za Flash Fill, dinani chizindikiro chanzeru chomwe chikuwoneka pafupi ndi mfundo zomwe zangowonjezeredwa kumene.