Momwe mungapangire mwachangu mndandanda wowerengeka mu Excel

Popanga matebulo ndikugwira ntchito mosalekeza ku Excel, posakhalitsa timakumana ndi vuto lopanga mndandanda wa manambala. Pali njira zingapo zopangira, iliyonse yomwe idzakambidwe mwatsatanetsatane m'nkhaniyi.

Njira nambala 1: Mndandanda wa manambala mu Excel pa selo imodzi

Nthawi zambiri pamakhala nthawi yomwe imayenera kukwanira cholembera ndi kuwerengera mndandanda mu selo limodzi. Chosowa choterocho chingabwere chifukwa cha malo ochepa oti mudzaze zambiri. Njira yoyika zipolopolo kapena mndandanda wa manambala mu selo lomwelo ndi mzere wodziwitsa:

1. Lembani mndandanda umene udzawerengedwe. Ngati idapangidwa kale, ndiye kuti timapitiliza kuchita zina.

Chidziwitso kuchokera kwa katswiri! Choyipa cha njirayi ndikuti manambala kapena zolembera zimayikidwa mu selo lililonse padera.

2. Yambitsani mzere womwe ukufunika kusinthidwa ndikukhazikitsa chotsitsa patsogolo pa mawu.
3. Pitani ku tabu ya "Insert" yomwe ili pamutu wa pulogalamu.

4. Pezani gulu la zida "Zizindikiro" ndipo podina muvi, pitani pawindo lomwe limatsegula. M'menemo, dinani "Symbol" chida.

5. Kenako, pamndandanda womwe waperekedwa, muyenera kusankha manambala kapena chikhomo chomwe mukufuna, yambitsani chizindikirocho, ndikudina batani la "Insert".

Njira #2: Mndandanda wa Nambala Wamagulu Angapo

Mndandanda woterewu udzawoneka wachilengedwe, koma ndi woyenera ngati malo omwe ali patebulo amakulolani kuyika mizati ingapo.

1. Mugawo loyamba ndi selo loyamba, lembani nambala "1".
2. Yendani pamwamba pa chogwirira chodzaza ndikuchikokera kumapeto kwa mndandanda.
3. Kuti muwongolere ntchito yodzaza, mutha kudina kawiri pa cholembera. Idzadzaza zokha.

4. Pamndandanda wa manambala, mutha kuwona kuti cholemberacho chinabwereza mtengo wa digito "1" m'mizere yonse. Zotani pankhaniyi? Kuchita izi, mu m'munsi pomwe ngodya, mungapeze Autofill Mungasankhe chida. Mwa kuwonekera pa chithunzi chomwe chili pakona ya chipika, mndandanda wotsitsa udzatsegulidwa, pomwe muyenera kusankha "Dzazani".

5. Zotsatira zake, mndandanda wa manambala udzadzazidwa ndi manambala olondola.

Kuti musavutike kulemba mndandanda wa manambala, mutha kugwiritsa ntchito njira ina:

1. Lowetsani manambala 1 ndi 2 m'maselo awiri oyambirira a gawoli, motsatira.
2. Sankhani maselo onse okhala ndi cholembera ndipo mizere yotsalayo idzadzazidwa yokha.

Chidziwitso cha akatswiri! Musaiwale kuti polowetsa manambala, muyenera kugwiritsa ntchito chipika cha nambala kumanja kwa kiyibodi. Manambala omwe ali pamwamba si oyenera kulowetsamo.

Mukhozanso kuchita ntchito yomweyo pogwiritsa ntchito autocomplete ntchito: =STRING(). Taganizirani chitsanzo cha kudzaza mizere ndi mndandanda wolamulidwa pogwiritsa ntchito ntchitoyi:

1. Yambitsani selo pamwamba pomwe mndandanda wa manambala uyambira.
2. Mu bar ya formula, ikani chizindikiro chofanana "=" ndikulemba "ROW" ntchito nokha kapena muipeze mu chida cha "Insert Function".
3. Pamapeto pa chilinganizo, ikani mabatani otsegulira ndi kutseka kuti muzindikire chingwecho.

4. Ikani cholozera pa chotengera chodzaza selo ndikuchikokera pansi. Kapena lembani ma cell podina kawiri. Mosasamala kanthu za njira yolowera, zotsatira zake zidzakhala zofanana ndipo zidzadzaza mndandanda wonse ndi nambala yoyikidwa bwino.

Njira nambala 3: gwiritsani ntchito kupitilira

Njira yabwino kwambiri yodzaza matebulo akulu ndi mizere yochititsa chidwi:

1. Kuti muwerenge, gwiritsani ntchito chipika cha manambala chomwe chili kumanja kwa kiyibodi. Lowetsani mtengo "1" mu selo yoyamba.

2. Mu tabu "Home" timapeza chipika "Kusintha". Kuwonekera pa makona atatu adzatsegula dontho-pansi mndandanda. Kumeneko timasiya kusankha kwathu pamzere "Kupititsa patsogolo".
3. Zenera lidzatsegulidwa pomwe, mu gawo la "Location", ikani cholembera ku "By columns".
4. Pazenera lomwelo, pagawo la "Mtundu", siyani chikhomo pamalo a "Arithmetic". Nthawi zambiri, malowa amakhazikitsidwa mwachisawawa.
5. M'munda waulere "Step" timalemba mtengo "1".
6. Kuti mudziwe kuchuluka kwa malire, muyenera kuyika m'munda wofananira nambala ya mizere yomwe imayenera kudzazidwa ndi mndandanda wowerengeka.

Chidziwitso kuchokera kwa katswiri! Ngati simumaliza gawo lomaliza, ndikusiya gawo la "Limit value" lopanda kanthu, ndiye kuti manambala odziwikiratu sangachitike, chifukwa pulogalamuyo sadziwa mizere ingati yoyang'ana.

Kutsiliza

Nkhaniyi idapereka njira zazikulu zitatu zopangira mndandanda wa manambala. Njira 1 ndi 2 zimatengedwa kuti ndizodziwika kwambiri. Pa nthawi yomweyo, aliyense wa iwo ndi yabwino kuthetsa mtundu wina wa ntchito.