Kuwerengera mizere yokhazikika mu Excel: njira zitatu

Pamene mukugwira ntchito ku Excel, si zachilendo kusowa manambala a mizere mugawo lapadera. Izi zitha kuchitika polowetsa manambala pamanja, mwa kuyankhula kwina, polemba pa kiyibodi. Komabe, pogwira ntchito ndi chidziwitso chochuluka, kulowetsa manambala pamanja si njira yosangalatsa komanso yofulumira, yomwe, komanso, zolakwika ndi typos zikhoza kupangidwa. Mwamwayi, Excel imakupatsani mwayi wosinthira izi, ndipo pansipa tiwona momwe izi zingachitikire m'njira zosiyanasiyana.

Njira 1: Kuwerengera Pambuyo Kudzaza Mzere Woyamba

Njira imeneyi mwina ndiyo yosavuta. Mukakhazikitsa, mumangofunika kudzaza mizere iwiri yoyambirira, kenako mutha kutambasula manambala ku mizere yotsalayo. Komabe, ndizothandiza pokhapokha mukugwira ntchito ndi matebulo ang'onoang'ono.

1. Choyamba, pangani mzere watsopano wa manambala a mzere. Mu selo loyamba (osawerengera mutu) timalemba nambala 1, kenako kupita yachiwiri, momwe timayika nambala 2.
2. Tsopano muyenera kusankha ma cell awiriwa, kenako timayendetsa cholozera cha mbewa pakona yakumanja ya malo omwe mwasankha. Cholozeracho chikangosintha mawonekedwe ake kukhala mtanda, gwirani batani lakumanzere ndikulikokera pamzere womaliza wagawo.
3. Timamasula batani lakumanzere la mbewa, ndipo manambala amtundu wa mizere adzawonekera nthawi yomweyo m'mizere yomwe tidaphimba potambasula.

Njira 2: STRING wogwiritsa ntchito

Njira iyi yowerengera mizere yokha imaphatikizapo kugwiritsa ntchito ntchitoyi "IMENEYO".

1. Timayimirira mu selo loyamba la gawolo, lomwe tikufuna kugawa nambala ya 1. Kenako timalemba ndondomeko yotsatirayi mmenemo: =СТРОКА(A1).
2. Tikangodina Lowani, nambala ya seriyo idzawonekera mu selo yosankhidwa. Zimakhalabe, mofanana ndi njira yoyamba, kutambasula chilinganizo ku mizere yapansi. Koma tsopano muyenera kusuntha cholozera cha mbewa kukona yakumanja kwa selo ndi fomula.
3. Chilichonse chakonzeka, tawerengera mizere yonse ya tebulo, yomwe idafunikira.

M'malo molowetsa pamanja fomula, mutha kugwiritsa ntchito Function Wizard.

1. Timasankhanso selo loyamba la gawo lomwe tikufuna kuyika nambala. Kenako dinani batani "Isert ntchito" (kumanzere kwa formula bar).
2. Zenera la Function Wizard limatsegulidwa. Dinani pa gulu lamakono la ntchito ndikusankha kuchokera pamndandanda womwe umatsegulidwa "References ndi Arrays".
3. Tsopano, kuchokera pamndandanda wa omwe akufunsidwa, sankhani ntchitoyo "IMENEYO", kenako panikizani OK.
4. A zenera adzaoneka pa zenera ndi mikangano ntchito kudzaza. Dinani pa lolowera munda kwa parameter "Mzere" ndipo tchulani adiresi ya selo yoyamba mu ndime yomwe tikufuna kugawira nambala. Adilesi ikhoza kulowetsedwa pamanja kapena kungodinanso pa cell yomwe mukufuna. Kenako dinani OK.
5. Nambala ya mzere imayikidwa mu selo losankhidwa. Momwe mungatambasulire manambala ku mizere yonseyo, takambirana pamwambapa.

Njira 3: kugwiritsa ntchito kuwonjezera

Choyipa cha njira yoyamba ndi yachiwiri ndikuti muyenera kutambasula manambala ku mizere ina, yomwe siili yabwino kwambiri pamiyeso yayikulu yowongoka. Choncho, tiyeni tione njira ina imene imachotseratu kufunika kochita zimenezi.

1. Tikuwonetsa mu cell yoyamba yachigawo nambala yake ya seriyo, yofanana ndi nambala 1.
2. Sinthani ku tabu "Pofikira", dinani batani Dzazani (gawo la "Kusintha") ndipo pamndandanda womwe ukutsegulidwa, dinani kusankha “Chitukuko…”.
3. Zenera lidzawonekera patsogolo pathu ndi magawo omwe akuyenera kukonzedwa, kenako timakanikiza. OK.
   • sankhani makonzedwe "ndi mizati";
   • tchulani mtundu wa "masamu";
   • mu mtengo wapatali timalemba nambala "1";
   • m'gawo la "Limit value", onetsani kuchuluka kwa mizere ya tebulo yomwe ikufunika kuwerengedwa.
4. Kuwerengera mzere wokha kwachitika, ndipo tapeza zotsatira zomwe tikufuna.

Njirayi ingagwiritsidwe ntchito m'njira zosiyanasiyana.

1. Timabwereza sitepe yoyamba, mwachitsanzo, Lembani nambala 1 mu selo yoyamba ya ndime.
2. Timasankha mitundu yomwe ili ndi ma cell onse omwe tikufuna kuyikamo manambala.
3. Kutsegula zenera kachiwiri "Zowonjezera". Magawowo amangokhazikitsidwa molingana ndi mtundu womwe tasankha, chifukwa chake timangodina OK.
4. Ndipo kachiwiri, chifukwa cha zochita zosavuta izi, timapeza manambala a mizere mumtundu wosankhidwa.

Ubwino wa njirayi ndikuti simuyenera kuwerengera ndikulemba kuchuluka kwa mizere yomwe mukufuna kuyikamo manambala. Ndipo kuipa kwake ndikuti, monga njira yoyamba ndi yachiwiri, muyenera kusankha ma cell angapo pasadakhale, zomwe sizothandiza kwambiri mukamagwira ntchito ndi matebulo akulu.

Kutsiliza

Kuwerengera mizere kungapangitse kukhala kosavuta kugwira ntchito ku Excel mukamagwira ntchito ndi data yambiri. Zitha kuchitika m'njira zambiri, kuyambira kudzaza pamanja kupita ku njira yokhazikika yomwe ingathetse zolakwika zilizonse zomwe zingatheke ndi typos.