Momwe mungasinthire zilembo zonse mu Excel. Njira ziwiri Zosinthira Malembo Aang'ono ndi Malembo Aakulu mu Excel

Anthu omwe amagwira ntchito mwakhama ku Excel nthawi zambiri amakonzekera malipoti a mabungwe osiyanasiyana a boma, nthawi zonse amakumana ndi zochitika zomwe malemba onse a chikalata, olembedwa m'malembo wamba, amafunika kusinthidwa ndi zilembo zazikulu. Mutha kuchita izi pasadakhale ngati mawuwo sanalembedwe. Ingodinani "CapsLock" ndikudzaza ma cell onse ofunikira m'zilembo zazikulu. Komabe, tebulo litakonzeka kale, kusintha chilichonse pamanja ndizovuta, pali chiopsezo chachikulu chopanga zolakwika. Kuti izi zitheke, mutha kugwiritsa ntchito imodzi mwa njira ziwiri zomwe zilipo za Excel.

Njira yosinthira zilembo zazing'ono kukhala zazikulu

Ngati tifanizira kuchitidwa kwa njirayi mu Mawu ndi Excel, muzolemba zolemba, ndikokwanira kungodina pang'ono kuti musinthe zilembo zonse wamba ndi zilembo zazikulu. Ngati tilankhula za kusintha deta patebulo, chirichonse chiri chovuta kwambiri apa. Pali njira ziwiri zosinthira zilembo zazing'ono kukhala zazikulu:

1. Kudzera mwapadera zazikulu zazikulu.
2. Kugwiritsa ntchito - UPPER.

Pofuna kupewa mavuto aliwonse posintha chidziwitso, njira zonsezi ziyenera kuganiziridwa mwatsatanetsatane.

Ndi macro

Macro ndi chinthu chimodzi kapena kuphatikiza komwe kumatha kuchitika kangapo. Pankhaniyi, zochita zingapo zimachitika ndikukanikiza kiyi imodzi.. Popanga ma macros, makiyi a kiyibodi ndi mbewa amawerengedwa.

Zofunika! Kuti ma macro asinthe zilembo zazing'ono ndi zilembo zazikulu kuti zigwire ntchito, muyenera kuyang'ana kaye ngati ntchito yayikulu yatsegulidwa mu pulogalamuyi kapena ayi. Apo ayi, njirayo idzakhala yopanda ntchito.

Ndondomeko:

1. Poyamba, muyenera kuyika chizindikiro pa tsambalo, mawu omwe mukufuna kusintha. Kuti muchite izi, mutha kugwiritsa ntchito mbewa kapena kiyibodi.

2. Mukamaliza kusankha, muyenera kukanikiza kuphatikiza kiyi "Alt + F11".
3. Mkonzi wa macro ayenera kuwonekera pazenera. Pambuyo pake, muyenera kukanikiza makiyi otsatirawa "Ctrl + G".
4. Pamalo aulere otsegulidwa "mwamsanga" ndikofunikira kulemba chiganizo chogwira ntchito "pa c aliyense mukusankha:c.value=ucase(c):chotsatira".

Chochita chomaliza ndikukanikiza batani la "Enter". Ngati mawuwo adalowetsedwa bwino komanso popanda zolakwika, zilembo zing'onozing'ono zomwe zasankhidwa zidzasinthidwa kukhala zilembo zazikulu.

Kugwiritsa ntchito UPPER

Cholinga cha UPPER ntchito ndikusintha zilembo wamba ndi zilembo zazikulu. Ili ndi njira yakeyake: = UPPER (Malemba osinthika). Pamkangano wokhawo wa ntchitoyi, mutha kutchula zikhalidwe ziwiri:

• kugwirizana kwa selo ndi malemba oti asinthe;
• zilembo ziyenera kusinthidwa kukhala zilembo zazikulu.

Kuti mumvetse momwe mungagwiritsire ntchito ntchitoyi, m'pofunika kulingalira chimodzi mwa zitsanzo zothandiza. Gwero lidzakhala tebulo ndi zinthu zomwe mayina awo amalembedwa m'malembo ang'onoang'ono, kupatulapo zilembo zazikulu zoyambirira. Kachitidwe:

1. Chongani ndi LMB malo omwe ali patebulo pomwe ntchitoyo idzayambitsidwe.
2. Kenako, muyenera dinani batani kuwonjezera "fx" ntchito.

3. Kuchokera pa menyu ya Function Wizard, sankhani mndandanda wa "Text".
4. Mndandanda wa zolemba zidzawoneka, zomwe muyenera kusankha UPPER. Tsimikizirani kusankha ndi batani "Chabwino".

5. Pazenera lomwe limatsegulira, payenera kukhala gawo laulere lotchedwa "Text". Mmenemo, muyenera kulemba zogwirizanitsa za selo yoyamba kuchokera pamtundu wosankhidwa, kumene muyenera kusintha zilembo wamba ndi zilembo zazikulu. Ngati ma cell amwazikana mozungulira tebulo, muyenera kufotokoza makonzedwe a aliyense wa iwo. Dinani pa "Chabwino" batani.
6. Mawu osinthidwa kale kuchokera mu selo, ma coordinates omwe adatchulidwa mu mkangano wa ntchito, adzawonetsedwa mu selo losankhidwa kale. Zilembo zonse zazing'ono ziyenera kusinthidwa kukhala zilembo zazikulu.
7. Kenako, muyenera kugwiritsa ntchito ntchitoyo ku selo iliyonse kuchokera pagulu losankhidwa. Kuti muchite izi, muyenera kuloza cholozera pa selo ndi malemba osinthidwa, dikirani mpaka mtanda wakuda uwoneke kumanzere kwake kumanzere. Dinani pa izo ndi LMB, kokerani pang'onopang'ono maselo ambiri momwe mungafunire kusintha deta.

8. Pambuyo pake, ndime yosiyana yokhala ndi zidziwitso zosinthidwa kale iyenera kuwonekera.

Gawo lomaliza la ntchito ndikulowa m'malo mwa maselo oyambilira ndi omwe adachitika zonse zitatha.

1. Kuti muchite izi, sankhani ma cell omwe ali ndi chidziwitso chosinthidwa.
2. Dinani kumanja pamndandanda womwe wasankhidwa, sankhani ntchito ya "Copy" kuchokera pamenyu yankhani.
3. Chotsatira ndikusankha ndime yokhala ndi chidziwitso choyambirira.
4. Dinani batani lakumanja la mbewa kuti muyitane menyu yankhaniyo.
5. Pamndandanda womwe umawonekera, pezani gawo la "Paste Options", sankhani njira - "Makhalidwe".
6. Mayina onse azinthu omwe adawonetsedwa poyambilira adzasinthidwa ndi mayina olembedwa ndi zilembo zazikulu.

Pambuyo pa zonse zomwe tafotokozazi, tisaiwale za kuchotsa ndime kumene ndondomeko inalowetsedwa, yomwe idagwiritsidwa ntchito popanga chidziwitso chatsopano. Apo ayi, zidzasokoneza chidwi, kutenga malo aulere. Kuti muchite izi, muyenera kusankha malo owonjezera pogwira batani lakumanzere, dinani kumanja pagawo lomwe mwasankha. Sankhani "Chotsani" kuchokera ku menyu yankhani.

Kutsiliza

Posankha pakati pa kugwiritsa ntchito macro kapena UPPER ntchito, oyamba kumene amakonda ma macros. Izi ndichifukwa chosavuta kugwiritsa ntchito. Komabe, ma macros si otetezeka kugwiritsa ntchito. Mukatsegulidwa, chikalatacho chimakhala pachiwopsezo cha owononga, chifukwa cha izi, tikulimbikitsidwa kuphunzira momwe mungagwiritsire ntchito UPPER ntchito.