Momwe mungagwiritsire ma cell kuti akwaniritse bwino. Njira zitatu zowonjezera maselo mpaka patebulo la evel

Mutha kunena ndi chidaliro kuti ogwiritsa ntchito onse amadziwa momwe angapangire foni yatsopano mu tebulo labwino, koma si aliyense amene amadziwa zovomerezeka zonse za ntchitoyi. Mulimonsemo, njira zitatu zosiyanasiyana zimadziwika kuti ndizotheka kunyamula khungu. Nthawi zambiri njira yothetsera mavuto zimatengera njira yomwe imagwiritsidwa ntchito. Ganizirani mwatsatanetsatane, mothandizidwa ndi njira ziti zomwe zingatheke kuwonjezera maselo kupita pagome la Exel.

Kuwonjezera maselo patebulo

Ogwiritsa ntchito ambiri amakhulupirira kuti nthawi yowonjezera maselo, kuwonjezeka kwawo kwathunthu, popeza chinthu chatsopano chimawonekera. Komabe, izi sizigwirizana ndi zenizeni, chifukwa kuchuluka kwawo kudzafanabe. M'malo mwake, ndikusamutsa chinthucho kuchokera kumapeto kwa tebulo kupita kumalo ofunikira ndikuchotsa deta ya cell. Poganizira izi, ziyenera kumvetsera mukamayenda, chifukwa ndizotheka kutaya zina mwazomwezo.

Njira 1: Kugwiritsa ntchito mndandanda wazomwe zili

Njira yomwe mwayang'aniridwa imagwiritsidwa ntchito pafupipafupi kuposa ena, chifukwa imawerengedwa mosavuta. Kuphatikiza maselo ngati njirayi, muyenera kutsatira zotsatirazi:

1. Timayika cholembera cha mbewa mu gawo linalake lomwe mukufuna kuwonjezera chinthu. Pambuyo poitanitsa mndandanda wazinthu zomwe zasankhidwa ndikukakamizidwa PCM ndi mndandanda wa malamulo, sankhani "phala ...".

Selo kuyika mndandanda wankhani

1. Woyang'anira adzatulutsa zenera ndi magawo. Tsopano muyenera kuyika chizindikiro pafupi ndi "maselo". Pali njira ziwiri zoyika - ndikusintha kumanja kapena pansi. Muyenera kusankha njira yomwe ikufunika munthawi inayake ndikudina bwino.
2. Pambuyo pake, mutha kuwona kuti chinthu chatsopano chidzaonekera m'malo moyambira, chimakhala limodzi ndi ena.

Njira zofananira ndizotheka kuwonjezera maselo angapo:

1. Chiwerengero chomwe mukufuna chimatsimikizika. Menyu wamba amatchedwa ndikukanikiza PCM pazambiri ndikusankha "phala ...".

Ikani maselo angapo kudzera pa menyu

1. Mwa njira zomwe mungasankhe, sankhani imodzi yomwe ikufunika ndikudina "Chabwino".
2. Maselo atsopano adzaonekera m'malo mojambulidwa, anasunthika limodzi ndi ena limodzi.

Njira 2: Kugwiritsa ntchito chida chapadera mumenyu

1. Monga momwe zapitazo, ndiye polemba mbewa ku malo omwe khungu lina lidzalengedwa. Kenako, pamenyu, kusankha tabu yakunyumba, pambuyo pake ndikofunikira kutsegula gawo la "maselo" komwe mungadikire "Ikani".

Kuyika kwa khungu kudzera mndandanda waukulu

1. M'dera lodziwika kuti padzawonjezera maselo. Koma ndi njira yofananira, kuyika kwa kusuntha kumachitika kokha, ndiye kuti, ikani khungu lomwe limasunthira mbali yakumanja la njirayo sichita bwino.

Mwa fanizo ndi njira yoyamba yomwe ili ndi mwayi wowonjezera maselo angapo:

1. Sankhani kuchuluka kwa maselo omwe mukufuna mu chingwe (chofewa). Kenako, dinani pa mawu oti "ikani".

Ikani maselo angapo kudutsa mndandanda waukulu

1. Pambuyo pake, maselo owonjezera amawonjezeredwa ndi kusamutsidwa kwa zinthu zodzipatulira pamodzi ndi ena onse.

Kenako, lingalirani zomwe zimachitika ngati simusankha mzere wokhala ndi maselo, koma mzere:

1. Ndikofunikira kuwonetsa maselo a mzere wopingasa ndikudina "Ikani" zolemba mu tabu yayikulu.
2. Zikatero, maselowo adzawonjezeredwa kusinthira kumanja ndi zinthu zomwe zinali, zomwe zinali woyamba kuyambira pamenepo.

Ndikofunikanso kutsimikizira momwe mungawonjezere ma cell, omwe amaphatikizapo zinthu zingapo zowongoka komanso zopingasa:

1. Pambuyo posankha mtundu womwe umafunikira, zochitika zomwezo zimachitika, ndiye kuti, mu "kunyumba", dinani pa "zolemba".
2. Tsopano mutha kuwona kuti zinthu zomwe zimawonjezerapo zimasunthidwa.

Nthawi zambiri kuchuluka kwa maselo, gawo lotanthauzira limachita ma mizere ndi zigawo zomwe zili ndi:

• Pakakhala mndandanda wambiri wolunjika m'njira yopingasa, kenako maselo owonjezera adzasunthidwa pansi powonjezera.
• Pakakhala mizere yopanda chopingasa pakati pa ofukula, kenako maselo adzasinthidwa kumanja powonjezera.

Mukafuna kudziwa pasadakhale momwe khungu limayikidwira, ziyenera kuchitidwa motere:

1. Pali malo pomwe foni (kapena ingapo) iikidwe. Kenako muyenera kusankha gawo la "maselo" ndikudina chithunzi cha makona atatu okhazikika ngati "ikani". Mu menyu wa Pop-Up, dinani "ikani ma cell ...".
2. Kenako akuwoneka pawindo ndi magawo. Tsopano muyenera kusankha njira yoyenera ndikudina "Chabwino".

Njira 3: Kuyika maselo pogwiritsa ntchito makiyi otentha

Ogwiritsa ntchito zapamwamba kwambiri pamapulogalamu osiyanasiyana amalimbikitsa njirayi, pogwiritsa ntchito mitundu ya mafuko omwe adapangidwa kuti akwaniritse izi. Excel ilinso ndi mitundu ingapo yofunikira yomwe imakupatsani mwayi wogwira ntchito zambiri kapena kugwiritsa ntchito zida zosiyanasiyana. Mndandandawu umaphatikizapo kuphatikiza makiyi kuti muike maselo owonjezera.

1. Poyamba ndikofunikira kupita kumalo komwe kukhazikitsidwa kwa khungu kumakonzedwa. Kenako, "Ctrl + Shift + =" mabatani amakanikizidwa mwachangu.

Kuyika kwa cell ndi makiyi otentha

1. Khomo lodziwika bwino limawonekera ndi njira. Kenako, muyenera kusankha njira yomwe mukufuna. Pambuyo pake, zidzangotsala kuti dinani "Chabwino" kuwonekera maselo owonjezera.

Mapeto

Nkhaniyi idasanthula mitundu yonse ya njira zomwe zimayika maselo owonjezera patebulo labwino. Iliyonse mwa omwe alembedwawa ndi ofanana ndi ena mwa njira yogwiritsira ntchito ndipo zotsatira zake zidakwaniritsidwa, koma zomwe njira zomwe mungagwiritse ntchito ziyenera kulinganize kusankha pazomwe zachitikazo. Njira yabwino kwambiri ndi yomwe imapereka kuti makiyi omwe amagwiritsidwa ntchito kuti akhazikitse, koma, ogwiritsa ntchito ambiri nthawi zambiri amagwiritsa ntchito menyu.

Mauthenga Momwe mungagwiritsire ma cell kuti akwaniritse bwino. Njira zitatu zowonjezera maselo ku teteri yopambana idawonekera koyamba kwaukadaulo.