Sinthani zilembo zonse kukhala zapamwamba mu Microsoft Excel

Nthawi zina, malembedwe onse a zilembo za Excel amafunika kulembedwa koyamba, ndiye kuti, ndi kalata yayikulu. Nthawi zambiri, mwachitsanzo, izi ndizofunikira popereka mafomu kapena mafotokozedwe ku mabungwe osiyanasiyana aboma. Kulemba zolemba zazikulu zilembo pa kiyibodi, pali batani la Caps Lock. Ikakanikizidwa, njira imakhazikitsidwa yomwe zilembo zonse zomwe zidalowetsedwa zimakhala zazikulu kapena, monga akunena mosiyana, zimakulitsidwa.

Koma bwanji ngati wogwiritsa ntchito angaiwale kusinthanitsa ndi zikuluzikulu kapena atazindikira kuti zilembozo zinayenera kukhala zazikulu m'malemba pokhapokha atangoazilemba? Kodi mukuyeneranso kulembanso kachiwiri? Osati kwenikweni. Ku Excel pali mwayi wothetsa vutoli mwachangu komanso mosavuta. Tiyeni tiwone momwe angachitire.

Chokwera kuti chikhale chaching'ono

Ngati mu Dongosolo la Mawu lotembenuzira zilembo kukhala zikuluzikulu (zikwama zazing'ono) ndikokwanira kusankha zomwe mukufuna, gwiritsani batani Shift ndikudina kawiri pa batani la ntchito F3, ndiye ku Excel sizovuta kuthana ndi vutoli. Kuti mutembenuzire kabuku kakang'ono, muyenera kugwiritsa ntchito ntchito ina yotchedwa CHITSANZO, kapena gwiritsani ntchito zazikulu.

Njira 1: UPRESS ntchito

Choyamba, tiyeni tiwone ntchito ya wothandizira CHITSANZO. Zimamveka kale kuchokera ku dzinali kuti cholinga chake chachikulu ndikusintha zilembo m'mawuwo kukhala zapamwamba. Ntchito CHITSANZO Ili m'gulu la ogwiritsa ntchito zolemba za Excel. Mapikidwe ake ndi osavuta ndipo akuwoneka motere:

= KULUMIRA (zolemba)

Monga mukuwonera, wopangirayo ali ndi lingaliro limodzi - "Zolemba". Kutsutsana kumatha kukhala mawu kapena, nthawi zambiri, kumakhala kwa foni yomwe imakhala ndi lembalo. Njira iyi imasinthira zolemba zomwe zapatsidwa kuti zikhale zolowa m'mwamba.

Tsopano tiyeni tiwone chitsanzo cha konkire momwe opareshoni amagwirira ntchito CHITSANZO. Tili ndi tebulo lomwe lili ndi dzina la ogwira nawo ntchito. Maina adalembedwa mwachizolowezi, ndiye kuti, kalata yoyamba ndi yapamwamba, ndipo inayo yonseyo ndi yamunsi. Ntchito yake ndikupanga zilembo zonse kukhala zapamwamba.

1. Sankhani selo iliyonse yopanda pepala. Koma ndiwosavuta kwambiri ngati ili mgulu lofanana ndi lomwe mayina omaliza alembedwa. Kenako dinani batani "Ikani ntchito", yomwe ili kumanzere kwa baramu yamu formula.



2. Zenera limayamba Ogwira Ntchito. Timasunthira ku gululi "Zolemba". Pezani ndikuwonetsa dzinalo CHITSANZOkenako dinani batani "Zabwino".



3. Windo la wotsutsana likuyambitsidwa CHITSANZO. Monga mukuwonera, pazenera ili pali gawo limodzi lokha lomwe likufanana ndi lingaliro lokhalo la ntchitoyi - "Zolemba". Tiyenera kulowa adilesi ya foni yoyamba mu mzere womwe uli ndi mayina ogwira nawo ntchito. Izi zitha kuchitika pamanja. Kuyendetsa magwirizano kuchokera pa kiyibodi pamenepo. Palinso njira yachiwiri, yomwe ndiyosavuta. Khazikitsani chotembezera m'munda "Zolemba", kenako dinani khungu lomwe lili patebulo pomwe pali dzina loyamba la wantchito. Monga mukuwonera, adilesiyo imawonetsedwa m'munda. Tsopano tiyenera kungogwira komaliza pawindo ili - dinani batani "Zabwino".



4. Pambuyo pa izi, zomwe zili patsamba loyamba la mzati wokhala ndi mayina omaliza zimawonetsedwa mu chinthu chomwe chidasankhidwa kale, chomwe chili ndi kachitidwe CHITSANZO. Koma, monga momwe tikuwonera, mawu onse omwe akuwonetsedwa mu foni iyi amakhala ndi zilembo zazikulu.



5. Tsopano tifunika kusintha kutembenuka kwa maselo ena onse a kholilo ndi mayina ogwira nawo ntchito. Mwachilengedwe, sitigwiritsa ntchito formula iliyonse wogwira ntchito, koma kungokopera yomwe ili kale pogwiritsa ntchito chikhomo. Kuti muchite izi, ikani cholozera mu ngodya ya kumunsi kwa chidutswa cha pepalacho. Pambuyo pake, cholozera chizisinthidwa kukhala cholembera, chomwe chimawoneka ngati mtanda wawung'ono. Tili ndi batani lakumanzere ndikusuntha chodzaza ndi kuchuluka kwa maselo omwe ali ofanana ndi kuchuluka kwawo masanjidwewo ndi mayina a ogwira nawo ntchito.



6. Monga mukuwonera, utatha kuchita, mayina onse adawonetsedwa pamakope ndipo nthawi yomweyo amakhala ndi zilembo zazikulu.



7. Koma tsopano zofunikira zonse mu renti zomwe timafunikira zili kunja kwa tebulo. Tiyenera kuziyika pagome. Kuti muchite izi, sankhani maselo onse omwe ali ndi mawonekedwe CHITSANZO. Pambuyo pake, dinani kusankha ndi batani loyenera la mbewa. Pazosankha zomwe zikutsegulidwa, sankhani Copy.



8. Pambuyo pake, sankhani mzere wokhala ndi dzina lonse la ogwira nawo bizinesi pagome. Timadina pamzere wosankhidwa ndi batani loyenera la mbewa. Zosintha zamakambirano zayambitsidwa. Mu block Ikani Zosankha sankhani chizindikirocho "Makhalidwe", yomwe imawonetsedwa ngati lalikulu lomwe lili ndi manambala.



9. Pambuyo pa izi, monga mukuwonera, mtundu womwe wasinthidwa wa matchulidwe mu zilembo zazikulu udzayikidwa pa tebulo loyambirira. Tsopano mutha kuchotsera pamitundu yonse yodzazidwa ndi njira, chifukwa sitifunanso. Sankhani ndikudina kumanja. Pazosankha zofanizira, sankhani Chotsani Zolemba.

Pambuyo pake, gwiritsani ntchito patebulo lotembenuza zilembo mu mayina a antchito kukhala zilembo zazikulu zitha kuonedwa kuti zatha.

Phunziro: Excel Feature Wizard

Njira 2: ikani ma macro

Mutha kuthetsanso ntchito yotembenuza timapepala tating'onoting'ono ku zilembo zazikulu za Excel pogwiritsa ntchito macro. Koma m'mbuyomu, ngati ma macro sanaphatikizidwe ndi pulogalamu yanuyi, muyenera kuyambitsa ntchitoyi.

1. Mukayika ntchito ya macros, sankhani mtundu womwe mukufuna kusintha zilembo kukhala zikuluzikulu. Kenako timalemba njira yachidule Alt + F11.



2. Tsamba limayamba Microsoft Visual Basic. Izi, kwenikweni, ndi mkonzi waukulu. Timaphatikizanso kuphatikiza Ctrl + G. Monga mukuwonera, pambuyo pake chowunikira chimapita kumunda wapansi.



3. Lowetsani zotsatirazi code iyi:

   pa c iliyonse posankha: c.value = ucase (c): lotsatira

   Kenako dinani fungulo ENG ndikatseka zenera Zowoneka zoyambira mwa njira yokhayo, ndiye kuti, ndikudina batani loyandikira mwanjira ya mtanda pamakona ake akumanja akumanja.



4. Monga mukuwonera, mukatha kuchita zowonera pamwambapa, zosankha zomwe zidasinthidwa zimasinthidwa. Tsopano ndiwokhazikika.

Phunziro: Momwe mungapangire zazikulu mu Excel

Pofuna kutembenuza mwachangu zilembo zonse zomwe zalembedwazo kuchokera pa pepala laling'ono kupita ku topset, komanso osataya nthawi ndikulowetsanso kuchokera ku kiyibodi, ku Excel pali njira ziwiri. Loyamba limaphatikizapo kugwiritsa ntchito CHITSANZO. Njira yachiwiri ndiyosavuta komanso yachangu. Koma zachokera pantchito za ma macros, chifukwa chake chida ichi chiyenera kukhazikitsidwa mwainu pulogalamuyo. Koma kuphatikiza kwa ma macros ndiko kupanga kwina kowonjezera pangozi ya chida chogwiritsa ntchito kwa omwe akuukira. Chifukwa chake aliyense wosankha wasankha njira yanji yomwe ndi yabwino kuti angagwiritsire ntchito.