Momwe Mungadziwire Chiwerengero cha Mizere mu Excel Table - 3 Njira

Si zachilendo kuti wogwiritsa ntchito Excel azitha kudziwa mizere ingati patebulo. Kuti muchite izi, mungagwiritse ntchito njira zina. Pali zambiri, kotero kusankha kwachindunji kumadalira kwathunthu cholinga chomwe wosuta akufuna kukwaniritsa. Lero tifotokoza zina mwa izo. Atha kugwiritsidwa ntchito pazolemba zomwe zili ndi magawo osiyanasiyana, komanso nthawi zina.

Chifukwa chiyani kudziwa kuchuluka kwa mizere mu Excel

Choyamba, bwanji kudziwa kuchuluka kwa mizere mu Excel konse? Pakhoza kukhala njira zambiri. Mwachitsanzo, m'pofunika kulingalira chiwerengero cha katundu, zomwe ziri mu mzere wosiyana ndipo panthawi imodzimodziyo chiwerengero chenicheni sichikugwirizana ndi chiwerengero cha mzere mu chikalata chokha. Kapena muyenera kudziwa kuchuluka kwa mizere yomwe ikufanana ndi muyeso wina. Tiyeni tipitirire molunjika pakuganizira njira zamomwe mungamvetsetsere mizere ingati patebulo la Excel.

Kuzindikira kuchuluka kwa mizere mu tebulo la Excel

Choncho, pali njira zingapo zofunika kudziwa chiwerengero cha mizere:

1. Onani zomwe zili mu sitepe bar.
2. Pogwiritsa ntchito ntchito yapadera yomwe imatha kudziwa kuchuluka kwa mizere payokha kapena kugwiritsidwa ntchito powerengera zina.
3. Pogwiritsa ntchito chida chosinthira chokhazikika ndi zosefera.

Njirazi ziyenera kuganiziridwa mwatsatanetsatane.

Mapangidwe Okhazikika ndi Kusefa

Kodi njira imeneyi ndi yoyenera pa chiyani? Choyamba, ngati tikufuna kudziwa kuchuluka kwa mizere mumtundu wina, womwe umagwirizananso ndi chikhalidwe china. Ndiko kuti, pamenepa, mizere yokhayo yomwe imagwera pansi pa ndondomeko yodziwika ndi wogwiritsa ntchito idzaganiziridwa. Kodi zimagwira ntchito bwanji?

1. Timasankha kuchuluka kwa deta yomwe idzagwiritsidwe ntchito powerengera.
2. Pambuyo pake timapeza pa "Home" tabu gulu la "Styles". Pali chida chotchedwa Conditional Formatting.
3. Tikadina batani loyenera, menyu yowonekera idzawonekera ndi mawu akuti "Malamulo Osankha Ma cell".
4. Kenako, zenera latsopano limawonekera momwe tiyenera kusankha "Zolemba zili". Koma izi ndi zachitsanzo chathu, chifukwa maselo omwe amagwiritsidwa ntchito mwathu ali ndi malemba okhawo. Muyeneranso kusankha chinthu choyenera pazochitika zanu. Timangofotokozera zimango zokha.
5. Pambuyo pake, zenera lidzawonekera momwe ife timayika mwachindunji malamulo a masanjidwe. Choyamba, tiyenera kufotokoza mfundo zomwe maselo adzajambula ndi mtundu wina. M'munda wakumanzere, mwachitsanzo, tidzalemba chilembo A, ndipo m'gawo lakumanja timasankha masanjidwe omwe akhazikitsidwa mwachisawawa. Apanso, mutha kusintha makonda awa monga momwe mukufunira. Mwachitsanzo, sankhani mtundu wosiyana. Tiyenera kusankha maselo onse omwe ali ndi chilembo A ndikuwapanga kukhala ofiira. Tikayika zokonda izi, dinani OK batani.
6. Kenako, timachita cheke. Ngati ma cell onse omwe amakumana ndi izi anali ofiira, ndiye kuti tidachita zonse bwino.
7. Kenako, tiyenera kugwiritsa ntchito Chida Chosefera, chomwe chingatithandize kudziwa kuchuluka kwa mizere yofiira. Kuti tichite izi, sankhaninso mtundu womwe tikufuna. Kenako pitani ku tabu ya "Home" ndikutsegula "Zosefera" pamenepo. Mutha kuwona momwe zikuwonekera pachithunzichi. Timadina pa izo.
8. Chizindikiro chidzawonekera pamwamba pa ndime yomwe yasankhidwa, kusonyeza fyuluta yosagwira ntchito. Zikuwoneka ngati muvi wapansi. Timadina pa izo.
9. Pambuyo pake, timasaka chinthucho "Zosefera ndi mtundu" ndikudina pamtundu womwe tidagwiritsa ntchito kale.
10. Fyuluta ikagwiritsidwa ntchito patebulo, mizere yokhayo yomwe ili ndi maselo ofiira idzawoneka mmenemo. Pambuyo pake, ndikwanira kuwasankha kuti amvetse nambala yomaliza. Kodi kuchita izo? Izi zimachitika kudzera mu bar yoyang'anira. Iwonetsa kuchuluka kwa mizere yomwe tidayenera kuwerengera muvuto lomwe takhazikitsa kumayambiriro kwa gawoli.

Kugwiritsa ntchito LINE

Mbaliyi ili ndi mwayi umodzi waukulu. Zimapangitsa kuti tisamangomvetsetsa kuti ndi mizere ingati yomwe yadzazidwa, komanso kuwonetsa mtengo uwu mu selo. Komabe, mutha kuwongolera mizere yomwe mungaphatikizepo powerengera pogwiritsa ntchito ntchito zina. Zonse zomwe zili ndi zofunikira komanso zomwe zilibe deta zidzaganiziridwa.

Mawu onse a ntchitoyi ndi awa: = STRING(gulu). Tsopano tiyeni tiganizire momwe tingagwiritsire ntchito ntchitoyi. Kuti tichite izi, tifunika kutsegula chida chotchedwa Function Wizard.

1. Sankhani selo iliyonse yomwe ilibe ma values. Ndibwino kuti muwonetsetse kuti ilibe zilembo zosasindikizidwa kapena mafomu ena omwe amapereka mtengo wopanda kanthu. Selo iyi iwonetsa zotsatira za ntchitoyi.
2. Pambuyo pake, dinani batani la "Insert Function", lomwe lili kumanzere kwa kapamwamba kapamwamba.
3. Tsopano tili ndi bokosi la zokambirana momwe tingasankhire gulu la ntchitoyo ndi ntchito yokha. Kuti tifufuze mosavuta, tiyenera kusankha gulu "Full alfabetical list". Pamenepo timasankha ntchito CHSTROK, ikani mndandanda wa data ndikutsimikizira zochita zathu ndi batani la OK.

Mwachikhazikitso, mizere yonse imatengedwa kuti ili ndi chidziwitso ndi yomwe ilibe. Koma ngati aphatikizidwa ndi ogwiritsa ntchito ena, ndiye kuti mutha kusintha mosavuta.

Zambiri mu bar yamasitepe

Ndipo pomaliza, njira yosavuta yowonera kuchuluka kwa mizere yosankhidwa pano ndikugwiritsa ntchito bar. Kuti muchite izi, muyenera kusankha mtundu womwe mukufuna kapena ma cell omwe mukufuna, kenako ndikuwona kuchuluka kwake mu bar (yowonetsedwa ndi rectangle yofiyira pazithunzi).

Chifukwa chake, palibe chovuta kuwona kuchuluka kwa mizere.