I-Bandicam 4.1.3.1400

Kwezinye izimo, wonke umbhalo kumadokhumenti e-Excel kudingeka ukuthi ubhalwe phansi, okungukuthi, ngencwadi enkulu. Ngokuvamile, isibonelo, lokhu kuyadingeka lapho uthumele izicelo noma izimemezelo ezihlotsheni ezahlukene zombuso. Ukuze ubhale umbhalo ngezinhlamvu ezinkulu kukhibhodi kukhona i-Caps Lock inkinobho. Uma ucindezelwe, imodi iqalisiwe, lapho zonke izinhlamvu ezifakiwe zizoba yi-oppercase noma, njengoba zisho ngendlela ehlukile, ngaphezulu.

Kodwa yini okufanele uyenze uma umsebenzisi ekhohlwa ukushintshela esimweni esiphezulu noma uthole ukuthi lezi zincwadi kwakudingeka zenziwe ezinkulu ematheksthini ngemuva kokubhala? Ingabe kufanele uphinde ubhale futhi? Akunjalo ngempela. Ku-Excel, kungenzeka ukuxazulula le nkinga ngokusheshisa futhi kulula. Ake sibone ukuthi singakwenza kanjani.

Bheka futhi: Indlela yokwenza umbhalo eZwini ezincwadini ezinkulu

Ukuguqulwa kwezinhlamvu ze-lowercase kuya ku-uppercase

Uma uhlelo lweZwi lokuguqula izinhlamvu zibe yinto ephezulu (umthamo) ngokwanele ukukhetha umbhalo ofunayo, ubambe inkinobho SHIFT futhi uchofoze kabili kunkinobho yomsebenzi F3ke akulula kakhulu ukuxazulula inkinga ku-Excel. Ukuze uguqule izincwadi ezincane ze-lowercase ukuze usebenze kalula, kuzodingeka usebenzise umsebenzi okhethekile obizwa ngokuthi UPPERnoma sebenzisa i-macro.

Indlela 1: umsebenzi we-UPPER

Okokuqala, ake sibheke umsebenzi womqhubi UPPER. Kusukela esihlokweni kuvele kucacile ukuthi umgomo wayo oyinhloko ukuguqula izinhlamvu ematheksthini. Umsebenzi UPPER kungokwesigaba se-opharetha bombhalo Excel. I-syntax yayo ilula kakhulu futhi ibukeka kanje:

= UPPER (umbhalo)

Njengoba ungabona, opharetha unengxabano eyodwa kuphela - "Umbhalo". Le mpikiswano ingaba inkulumo yombhalo noma, kaningi, ukubhekisela kweseli equkethe umbhalo. Umbhalo lo mbhalo futhi uguqula ekungeneni okuphezulu.

Manje ake sithathe isibonelo sokhonkolo ukuze sibone ukuthi usebenza kanjani. UPPER. Sinetafula egama labasebenzi benkampani. Isibongo sibhaliwe ngesitayela esivamile, okungukuthi, incwadi yokuqala iyinhloko futhi bonke abanye bangaphansi. Umsebenzi wukuthi zonke izinhlamvu zithathwe (capital).

1. Khetha noma iyiphi iseli elingenalutho kushidi. Kodwa kulula kakhulu uma itholakala ekholomu efana nenye lapho amagama alotshiwe khona. Okulandelayo, chofoza inkinobho "Faka umsebenzi"elitholakala ngakwesokunxele kwebha yefomula.



2. Ifasitela iqala. Amakhosi omsebenzi.沼yela kwesigaba "Umbhalo". Thola bese ukhetha igama UPPERbese uchofoza inkinobho "Kulungile".



3. Ukuqalisa ifasitelana lokuphikisana lomqhubi UPPER. Njengoba ubona, kule festile kukhona insimu eyodwa kuphela ehambisana nokuphikisana okulodwa komsebenzi - "Umbhalo". Sidinga ukungena ikheli leseli lokuqala kule nkambu kukholomu ngamagama abasebenzi. Lokhu kungenziwa ngesandla. Ukushaya kusuka kukhibhodi lapho kuqondanisa. Kukhona futhi ukhetho lwesibili, okuyinto elula kakhulu. Setha isikhombisi emkhakheni "Umbhalo", bese sichofoza kuleso selula etafuleni lapho isibonakaliso sokuqala sesisebenzi siswa khona. Njengoba ungabona, ikheli liyaboniswa ensimini. Manje kufanele senze ukuthinta kokugcina kule window - chofoza inkinobho. "Kulungile".



4. Ngemva kwalesi senzo, okuqukethwe kweseli yokuqala yekholomu ngamagama okugcina kuboniswa kwisici esikhethiwe ngaphambili, esinefomula UPPER. Kodwa, njengoba sibona, wonke amagama aboniswe kule seli ahlanganisa kuphela amagama amakhulu.



5. Manje sidinga ukuguqula wonke amanye amaseli kukholomu ngamagama abasebenzi. Ngokwemvelo, ngeke sisebenzise ifomula ehlukile yomsebenzi ngamunye, kodwa mane nje ukopishe okhona kakade usebenzisa uphawu lokugcwalisa. Ukuze wenze lokhu, faka isikhombisi ekhoneni elingezansi elingakwesokudla se-sheet element, equkethe ifomula. Ngemuva kwalokho, isikhombisi kufanele siguqulwe kumaka wokugcwalisa, okubukeka njengesiphambano esincane. Senza isiqeshana senkinobho yegundane lesokunxele bese sondela umaka wokugcwalisa ngenani lamaseli alingana nenombolo yakhe kukholomu ngamagama abasebenzi basekhampani.



6. Njengoba ubona, ngemuva kwalokhu isenzo, wonke amagama agcinwe ebangeni lokukopisha futhi ngesikhathi esifanayo ahlanganisa kuphela izinhlamvu ezinkulu.



7. Kodwa manje wonke amagugu ebhalweni esiwadingayo atholakala ngaphandle kwetafula. Sidinga ukuwafaka etafuleni. Ukuze wenze lokhu, khetha wonke amaseli agcwele amafomula UPPER. Ngemuva kwalokho, chofoza ukukhethwa inkinobho yegundane kwesokudla. Emenyu yemenyu evulwe, khetha into "Kopisha".



8. Emva kwalokho, khetha ikholomu negama labasebenzi benkampani etafuleni. Chofoza kukholomu ekhethiwe nge inkinobho yesokudla yegundane. Iqala imenyu yokuqukethwe. Ku-block "Izinketho zokufaka" khetha isithonjana "Amanani"okuboniswa njengesikwele esinezinombolo.



9. Ngemuva kwalesi senzo, njengoba ubona, inguqulo eguqulwayo yokupeliswa kwamazita ezinhlamvu ezinkulu izofakwa efoleni langempela. Manje ungasusa ibanga eligcwele amafomula, ngoba asisadingi. Khetha bese uchofoza inkinobho yegundane kwesokudla. Kumenyu yesimo, khetha into "Sula Okuqukethwe".

Ngemuva kwalokho, umsebenzi otafuleni ekuguqulweni kwezinhlamvu ngamagama abasebenzi kubhalwe amagama amakhulu angacatshangwa agcwaliswe.

Isifundo: I-Excel umsebenzi wizard

Indlela 2: Sebenzisa i-Macro

Ungakwazi futhi ukuxazulula umsebenzi wokuguqula izincwadi ezincane ezenziwe ngaphansi kwe-Excel usebenzisa i-macro. Kodwa ngaphambili, uma inguqulo yakho yohlelo ingahlanganisi umsebenzi nama-macros, udinga ukusebenze lo msebenzi.

1. Uma ususebenze i-macro, khetha uhla lapho ufuna ukuguqula khona izinhlamvu ngaphezulu. Bese uthayipha isinqamuleli I-Alt + F11.



2. Iwindi iqala I-Microsoft Visual Basic. Lokhu, empeleni, umhleli omkhulu. Thola inhlanganisela Ctrl + G. Njengoba ungabona, emva kwalokhu, isikhombisi sithuthela ensikeni ephansi.



3. Faka ikhodi elandelayo kule nsimu:

   c ngayinye c ekukhethweni: c.value = ucase (c): elandelayo

   Bese uchofoza ukhiye ENTER bese uvale iwindi Okuyisisekelo esibukwayo ngendlela ejwayelekile, okungukuthi, ngokuchofoza inkinobho yokuvala ngendlela yesiphambano ekhoneni layo elingakwesokudla.



4. Njengoba ungabona, ngemuva kokwenza le ndlela ekhonjwe ngenhla, idatha ebangeni elikhethiwe liguqulwa. Manje zinezinhlamvu ezinkulu.

Isifundo: Indlela yokudala i-macro ku-Excel

Ukuze uguqule masinyane zonke izinhlamvu ezitholakala kumbhalo ukusuka ngaphansi kwe-lowercase kuya ku-uppercase, futhi ukuze ungachithi isikhathi ngokuzifaka ngesandla ngokuzenzekelayo kusukela kukhibhodi, kunezindlela ezimbili ku-Excel. Okokuqala kuhilela ukusetshenziswa komsebenzi UPPER. Ukhetho lwesibili kulula nakakhulu futhi. Kodwa kusekelwe emsebenzini we-macros, ngakho-ke leli thuluzi kufanele lenziwe kusebenze esimweni sakho sohlelo. Kodwa ukufakwa kwama-macros - kudalwa iphuzu elengeziwe lokungcupheni kwesistimu yokusebenza yabahlaseli. Ngakho umsebenzisi ngamunye uzikhethela ukuthi yiziphi izindlela ezibonisiwe okungcono ukuthi azisebenzise.