Bandicam 4.1.3.1400

Nthawi zina, malemba onse mu zolemba za Excel amayenera kulembedwa pampingo waukulu, ndiko kuti, ndi kalata yaikulu. Kawirikawiri, izi ndizofunikira pakuperekera mapulogalamu kapena mauthenga ku matupi osiyanasiyana a boma. Kulemba malembo akuluakulu pa khibhodi pali batani Woponya Chophimba. Pamene ikanikizidwa, machitidwe amayamba, momwe makalata onse omwe amalowa adzakhala aakulu kapena, monga akunena mwanjira yina, yaikulu.

Koma choyenera kuchita ngati wogwiritsa ntchito akuiwala kusinthana kumbuyo kapena kupeza kuti makalata amayenera kupangidwa mwapatali pokhapokha atalemba? Kodi muyenera kulembanso kachiwiri? Osati kwenikweni. Mu Excel, n'zotheka kuthetsa vutoli mofulumira komanso mosavuta. Tiyeni tione m'mene tingachitire.

Onaninso: Momwe mungapangire malemba mu Mawu mumakalata akuluakulu

Kusinthidwa kwa zilembo zochepetsetsa kuti zikhale zosavuta

Ngati pulogalamu ya Mawu yosandutsa makalata kukhala ochulukitsa (yovuta) ndi yokwanira kusankha malemba omwe mukufuna, tanizani batani ONANI ndipo dinani kawiri pafungulo la ntchito F3ndiye sizovuta kuthetsa vutoli mu Excel. Kuti mutembenuzire makalata otsika m'munsi kuti mukhale ochuluka, muyenera kugwiritsa ntchito ntchito yapadera yotchedwa UPPERkapena gwiritsani ntchito macro.

Njira 1: ntchito ya UPPER

Choyamba, tiyeni tiyang'ane ntchito ya wogwira ntchitoyo UPPER. Kuchokera pamutuwu kumatsimikiziranso kuti cholinga chake chachikulu ndicho kutembenuza makalata m'ndandanda. Ntchito UPPER ndi a gulu la olemba mauthenga a Excel. Mawu ake omasulira ndi abwino kwambiri ndipo amawoneka ngati awa:

= UPPER (zolemba)

Monga mukuonera, wogwiritsa ntchito ali ndi kukangana kokha - "Malembo". Mtsutso uwu ukhoza kuwonetsera malemba kapena, mobwerezabwereza, kutanthauza selo yomwe ili ndi malemba. Lembali likutsatirani izi ndikutembenuziranso kulowera.

Tsopano tiyeni titenge chitsanzo cha konkire kuti tiwone momwe operekera amagwirira ntchito. UPPER. Tili ndi tebulo limodzi ndi antchito a kampani. Dzina lachibadwidwe lidalembedwa kalembedwe, ndiko kuti, kalata yoyamba ndi yaikulu ndipo ena onse ali ochepa. Ntchitoyi ndi kupanga makalata onse (capital).

1. Sankhani selo iliyonse yopanda kanthu pa pepala. Koma ndizosavuta ngati zili mu ndime yofanana ndi imene mainawo alembedwa. Kenako, dinani pakani "Ikani ntchito"yomwe ili kumanzere kwa bar.



2. Zenera likuyamba. Oyang'anira ntchito. Pitani ku gawo "Malembo". Pezani ndi kusankha dzina UPPERkenako dinani pa batani "Chabwino".



3. Kugwiritsa ntchito zenera zotsutsana ndiwindo UPPER. Monga mukuonera, pazenera ili pali munda umodzi wokha womwe umagwirizana ndi ndondomeko imodzi ya ntchito - "Malembo". Tiyenera kulowa adiresi ya selo yoyamba mu gawo ili muzamuli ndi maina a antchito. Izi zikhoza kuchitidwa pamanja. Kumenya kuchokera ku kiyibodi kumeneko kumakonza. Palinso njira yachiwiri, yomwe ili yabwino kwambiri. Ikani cholozera mmunda "Malembo", ndiyeno tifika pa sebulo la gome limene dzina loyamba la antchito likuyikidwa. Monga momwe mukuonera, adiresi imawonetsedwa m'munda. Tsopano tikuyenera kuti tigwire kotsiriza pazenera - dinani pa batani. "Chabwino".



4. Pambuyo pachithunzichi, zomwe zili mu selo yoyamba ya mndandanda ndi mayina otsiriza amasonyezedwa mu chinthu choyankhidwa kale, chomwe chiri ndi mayendedwe UPPER. Koma, monga momwe tikuonera, mawu onse omwe ali mu selo ili amakhala ndi makalata akuluakulu.



5. Tsopano tikufunikira kusintha maselo ena onse m'ndandanda ndi maina a antchito. Mwachibadwa, sitingagwiritse ntchito fomu yosiyana ya wogwira ntchito aliyense, koma kungokopera kale lomwe lilipo pogwiritsa ntchito chizindikiro chodzaza. Kuti muchite izi, ikani cholozeracho kumbali ya kumanja ya pepala, yomwe ili ndi chiganizo. Pambuyo pake, thumbalo liyenera kutembenuzidwa kukhala chizindikiro chodzaza, chomwe chikuwoneka ngati mtanda wawung'ono. Timapanga pulogalamu ya batani lamanzere ndikutenga chizindikiro chodzaza chiwerengero cha maselo ofanana ndi chiwerengero chawo m'ndandanda ndi mayina a antchito a kampaniyo.



6. Monga momwe mukuonera, mutatha izi, mayina onse adasamutsidwa ku zokopazo ndipo nthawi yomweyo iwo amakhala ndi makalata akuluakulu.



7. Koma tsopano malingaliro onse mu bukhu limene tikusowa ali kunja kwa tebulo. Tiyenera kuziika mu tebulo. Kuti muchite izi, sankhani maselo onse omwe ali ndi ma fomu UPPER. Pambuyo pake, dinani pakasankhidwe ndi batani labwino la mouse. Muzitsegulo zotseguka, sankhani chinthucho "Kopani".



8. Pambuyo pake, sankhani ndimeyi ndi dzina la antchito a kampaniyo patebulo. Dinani pa tsamba losankhidwa ndi batani lamanja la mouse. Yayambitsa mndandanda wamakono. Mu chipika "Njira Zowonjezera" sankhani chizindikiro "Makhalidwe"zomwe zikuwonetsedwa ngati malola okhala ndi manambala.



9. Pambuyo pachitachi, monga momwe mukuonera, kusintha kotanthauzira kwa malembo a mayina akuluakulu adzaikidwa mu tebulo lapachiyambi. Tsopano mutha kuchotsa mazenera omwe ali ndi ma formula, popeza sitikusowa. Sankhani ndipo dinani ndi batani labwino la mouse. Mu menyu yachidule, sankhani chinthucho "Chotsani Chokhutira".

Pambuyo pake, ntchito yomwe ili patebulo pakutembenuka kwa makalata m'maina a antchito m'makalata akuluakulu akhoza kulingalira kuti yatha.

Phunziro: Excel ntchito wizara

Njira 2: Gwiritsani ntchito Macro

Pofuna kuthetsa ntchito yotembenuza makalata otsika m'munsi ku Excel, mukhoza kugwiritsa ntchito macro. Koma pasanakhale, ngati mapulogalamu anu sakuphatikizapo ntchito ndi macros, muyenera kuyambitsa ntchitoyi.

1. Mukasintha macro, sankhani mtundu umene mukufuna kusintha makalatawo. Kenako lembani njirayo Alt + F11.



2. Foda ikuyamba Microsoft Visual Basic. Izi ndizo, mkonzi wamkulu. Kulemba limodzi Ctrl + G. Monga mukuonera, patatha izi, thumba likupita kumtunda.



3. Lowetsani ma code otsatirawa m'munda uwu:

   pa c iliyonse yosankhidwa: c.value = ucase (c): yotsatira

   Kenaka dinani pafungulo ENTER ndi kutseka zenera Zojambula zofunikira mu njira yeniyeni, ndiko, podindira pa batani omaliza mu mawonekedwe a mtanda m'makona ake akumanja.



4. Monga momwe mukuonera, mutatha kuchita zochitika pamwambapa, deta yanuyi yasinthidwa. Tsopano iwo amakhala ndi makalata akuluakulu.

Phunziro: Momwe mungapangire macro ku Excel

Kuti mwamsanga mutembenuzire malembo onse mu malemba kuchokera pansi mpaka pansi, komanso kuti musamawononge nthawi mwakabwereza kuti mubwererenso kuchokera kubokosilo, pali njira ziwiri mu Excel. Choyamba chimaphatikizapo kugwiritsa ntchito ntchitoyi UPPER. Njira yachiwiri ndi yophweka komanso yofulumira. Koma zimachokera ku ntchito ya macros, choncho chida ichi chiyenera kukhazikitsidwa panthawi yanu. Koma kuphatikiza kwa macros - ndiko kulengedwa kwa mfundo yowonjezereka ya chiopsezo cha machitidwe opondereza. Kotero aliyense wosuta amadzipangira yekha omwe mwa njira zosonyeza kuti ndi bwino kuti agwiritse ntchito.