Momwe mungapangire zilembo zonse mu likulu mu Excel

Nthawi zina, lembalo lonse la zikalata zaposachedwa limafunikira kuti lilembe kumapeto kwapamwamba, ndiye kuti, kuchokera ku kalata yayikulu. Mwachitsanzo, mwachitsanzo, ndikofunikira pogonjera mapulogalamu kapena zigawenga zosiyanasiyana za mabungwe osiyanasiyana aboma. Kulemba mawu m'makalata akulu pa kiyibodi pali batani la Caps Lock. Ikakanikizidwa, makinawo amayambitsidwa, pomwe zilembo zonse zomwe zalowetsedwa zidzakhala likulu kapena, monga momwe amanenera mosiyanasiyana, likulu.

Koma choti ndichite ngati wogwiritsa ntchitoyo aiwala kuti asinthidwe kuti asinthidwe kapena atazindikira kuti zilembo zofunika kuti zichitike mu lembalo mutatha kulemba? Kodi simuyenera kulembanso zonse? Sichofunikira. Kupambana, pali mwayi wothetsa vutoli mwachangu komanso kosavuta. Tiyeni tiwone momwe mungachitire.

Wonenaninso: Momwe Mawu Amapangira Malembo Akulu

Kusintha kwa zilembo zochepa

Ngati mu pulogalamu ya mawu kuti musinthe zilembo ku mutu (kulembetsa), ndikokwanira kuwunikira mawu omwe mukufuna, ndikudina batani la F3 . Kuti musinthe zilembo zotsika ku mutuwo, muyenera kugwiritsa ntchito ntchito yapadera yomwe imatchedwa olembetsedwa, kapena gwiritsani ntchito macro.

Njira 1: Ntchito Kukula

Choyamba, tiyeni tiwone ntchito ya wogwiritsa ntchito adalembetsedwa. Kuchokera pamutuwu nthawi yomweyo ndikudziwitsani kuti cholinga chake chachikulu ndikusintha makalata m'mawu omwe ali ndi ndalama. Ntchitoyi imatchulidwa m'gulu la zolemba zapamwamba. Syntax yake ndi yosavuta ndipo imawoneka ngati iyi:

= Zotchulidwa (zolemba)

Monga mukuwonera, wothandizirayo ali ndi mkangano umodzi wokha - "mawu". Kutsutsa kumeneku kungakhale mawu kapena, nthawi zambiri, amatanthauza chilankhulo chomwe chili ndi mawu. Lembali ndi fomula iyi ndikutembenuza kujambulidwa pampando wapamwamba.

Tsopano tiyeni tidziwe mwachitsanzo, momwe wothandizira akugwirira ntchito yoyenera. Tili ndi tebulo ndi zowona za ogwira ntchito mu bizinesi. Dzinalo lalembedwa mwachizolowezi, ndiye kuti, kalata yoyamba ya mutuwo, ndi zotsalazo. Ntchitoyi ndi zilembo zonse zopanga likulu (likulu).

1. Tikuwonetsa khungu lililonse lopanda kanthu. Koma ndizosavuta ngati zili pamalo ofanana ndi omwe mayina alembedwa. Chotsatira, dinani pa batani la "phala ntchito", lomwe limayikidwa kumanzere kwa chingwe.



2. Zenera la Wizard limayamba. Timasunthira ku "zolemba". Tikupeza ndikuwonetsa dzinalo lidalembetsedwa, kenako dinani batani la "OK".



3. Kuchita kwa Windo la Ogwiritsa ntchito kumayambitsidwa. Monga tikuwona, pawindo ili gawo limodzi lokha lomwe limafanana ndi lingaliro lokhalo la ntchito - "mawu". Tiyenera kulowa adilesi yoyamba m'chipinda choyambirira ndi mayina a ogwira ntchito m'munda uno. Izi zitha kuchitika pamanja. Atathamangitsidwa kuchokera pa kiyibodi. Palinso njira yachiwiri yomwe ili yosavuta. Timakhazikitsa cholozera m'munda wa "mawu", kenako dinani khungu la tebulo, momwe dzina loyamba la wogwira ntchito limapezeka. Monga mukuwonera, adilesi yomwe itawonetsedwa m'munda. Tsopano tiyenera kupanga barcode yomaliza pazenera ili - dinani batani la "Ok".



4. Pambuyo pa izi, zomwe zili mu chipinda choyambirira cha mzati zomwe zili ndi mayina zimawonetsedwa mu chinthu chomwe chisindikizo chidakonzedwa moyenera. Koma, monga tikuwona, mawu onse omwe akuwonetsedwa mu khungu ili limakhala ndi zilembo zazikulu.



5. Tsopano tifunika kusintha komanso kwa maselo ena onse ndi mayina a ogwira ntchito. Mwachilengedwe, sitingagwiritse ntchito njira ina ya wogwira ntchito aliyense, koma kungokonzera chizindikiro chodzaza ndi chikhomo. Kuti muchite izi, khazikitsani cholozera kumanzere kwa tsamba la masamba, lomwe lili ndi formula. Pambuyo pake, cholozerachi chiyenera kutembenuka ku cholembera, chomwe chikuwoneka ngati mtanda wamng'ono. Timatulutsa chsite yosiyidwa ndikukoka chikhomo chazodzaza maselo ofanana ndi nambala yawo yomwe ili pafupi ndi mayina a olemba ntchito.



6. Monga mukuwonera, pambuyo poti achitire, mayina onse adawonetsedwa munthawi yomweyo ndipo nthawi yomweyo amakhala ndi zilembo zazikulu.



7. Koma tsopano malingaliro onse mu diuni yomwe timafunikira kuti ili kunja kwa tebulo. Tiyenera kuwayika pagome. Kuti tichite izi, timagawa maselo onse omwe ali ndi mapangidwe omwe amalembetsedwa. Pambuyo pake, dinani powunikira batani lamanja. Munkhani yankhani yomwe imatsegula, sankhani "kope".



8. Pambuyo pake, timatsindika za mzerewu ndi dzina la kampaniyo patebulo. Dinani pa mzere wodzipereka ndi batani lamanja mbewa. Zosankha zamitunduyo zayambitsidwa. Mu "kuyikapo magawo", sankhani "mtengo", womwe umawonetsedwa ngati lalikulu lomwe lili ndi manambala.



9. Pambuyo pa izi, monga tikuwona, mtundu wosinthika wolemba mayina m'makalata akuluakulu adzaikidwa mu tebulo la gwero. Tsopano mutha kufufuta kuti mudzazenthe ntchito, chifukwa sizifunikiranso. Tikuunikira ndikudina batani la mbewa lamanja. Mu menyu, sankhani "zoyera".

Pambuyo pake, gwiritsani ntchito patebulo posinthira zilembo mu mayina a ogwira ntchito ku likulu atha kuwerengedwa.

Phunziro: Master of Nurctions

Njira 2: Kugwiritsa Ntchito Macro

Sinthani ntchito yosinthira zilembo zotsika ku likulu lapamwamba lingagwiritsidwenso ntchito ndi Macro. Koma musanaphatikize ntchito ndi macros mu mtundu wanu wa pulogalamuyi, muyenera kuyambitsa izi.

1. Mukamaliza ntchito ya macros, tikuwonetsa kuchuluka komwe muyenera kusintha makalata mpaka kulembetsa. Kenako lembani batani la kiyibodi + F11.



2. Zenera la Microsoft Vieal iyambira. Izi, kwenikweni, mkonzi wa macros. Timalemba Ctrl + g. Monga mukuwonera, ndiye kuti zolosera zimasunthira kumunda wapansi.



3. Timalemba nambala yotsatirayi mu gawo ili:

   Pamtundu uliwonse wosankhidwa: C.Vue = ubaketi (c): Kenako

   Kenako dinani batani la Enter ndikutseka zenera lowoneka ndi njira yodziwika, ndiye kuti, podina batani lotseka mu mawonekedwe a mtanda wake wapamwamba.



4. Monga tikuwonera, ndikatha kuchitapo kanthu pamwambapa, zomwe zili m'malo odzipereka zimatembenuka. Tsopano ali ndi zilembo zazikulu.

Phunziro: Momwe Mungapangire Macro pa Excel

Kuti musinthe makalata onse mulemba kuchokera pamzerewu, m'malo mwanu mukutaya nthawi pa mawu oyamba, pali njira ziwiri zokhalire. Oyamba a iwo amaphatikizapo kugwiritsa ntchito ntchitoyo amalembetsedwa. Njira yachiwiri ndi yosavuta komanso yosavuta. Koma zimakhazikitsidwa pa Macros, kotero chida ichi chiyenera kukhazikitsidwa munthawi yanu. Koma kuphatikizika kwa macros ndiko kulenga kwa malo owonjezera omwe akugwira ntchito yoyendetsera. Chifukwa chake wogwiritsa ntchito aliyense amadzisankha, ndi njira ziti zomwe zili bwino kugwiritsa ntchito.