Guqula wonke amagama abe yizinhlamvu eziphezulu kwiMicrosoft Excel

Kwezinye izimo, wonke umbhalo kumadokhumenti e-Excel udinga ukubhalwa ngaphezulu, okungukuthi ngohlamvu olukhulu. Kaningi, ngokwesibonelo, lokhu kuyadingeka lapho kuthunyelwa izicelo noma izimemezelo ezinhlakeni ezihlukene zikahulumeni. Ukubhala umbhalo ngezinhlamvu ezinkulu kwikhibhodi, kunenkinobho ye-Caps Lock. Uma icindezelwa, kwethulwa imodi lapho zonke izinhlamvu zifakiwe zenziwa imali ezinkulu, noma, njengoba zisho ngokuhlukile, zinkulu.

Kepha kuthiwani uma umsebenzisi ekhohlwa ukushintshela ku-topsel noma ethola ukuthi izinhlamvu kufanele zenziwe zikhulu ngombhalo kuphela ngemuva kokuba zibhaliwe? Ngabe kufanele futhi ukuyibhala futhi? Akunjalo. E-Excel kunethuba lokuxazulula le nkinga ngokushesha okukhulu futhi kube lula. Ake sibheke ukuthi sikwenza kanjani.

Uppercele kubhasikidi

Uma ohlelweni lweZwi ukuguqula izinhlamvu zibe i-uppercase (isikhwama esincane) kwanele ukukhetha umbhalo owuthandayo, bamba inkinobho I-Shift bese uchofoza kabili enkombeni yokusebenza F3, ke ku-Excel akulula kangako ukuxazulula inkinga. Ukuze uguqulele i-sinciphothi kuya kwesiphezulu, kufanele usebenzise umsebenzi othile obizwa ngokuthi OKUFANELEKILE, noma usebenzise i-macro.

Indlela yoku-1: Umsebenzi we-UPRESS

Okokuqala, ake sibheke umsebenzi we-opharetha OKUFANELEKILE. Kusobala ngokushesha kusuka ebizweni ukuthi inhloso yawo eyinhloko ukuguqula izinhlamvu zombhalo zibe i-topc. Umsebenzi OKUFANELEKILE Kungokwesigaba sabasebenzisi be-Excel umbhalo. I-syntax yayo ilula futhi ibukeka kanjena:

= EKUFANELE (umbhalo)

Njengoba ukwazi ukubona, opharetha unempikiswano eyodwa kuphela - "Umbhalo". Le ngxabano ingaba yizwi lombhalo noma, kaningi, isethenjwa esitokisini esiqukethe umbhalo. Le fomula iguqula umbhalo owunikiwe ungeniswe ekuqoqweni okuphezulu.

Manje ake sibheke isibonelo ukhonkolo ukuthi opharetha basebenza kanjani OKUFANELEKILE. Sinethebula elinegama labasebenzi bebhizinisi. Izibongo zibhalwe ngesitayela esijwayelekile, okungukuthi, uhlamvu lokuqala lusezingeni eliphezulu, kanti ezinye lusezingeni eliphansi. Umsebenzi uwukuthi zonke izinhlamvu zibhale.

1. Khetha noma isiphi isitokisi esingenalutho eshidini. Kepha kulula kakhulu uma kutholakala kwikholamu elifanayo naleyo ebhalwe kuyo amagama okugcina. Ngokuchofoza inkinobho "Faka umsebenzi", etholakala kwesobunxele sebha yefomula.



2. Iwindows liqala Umsebenzi Wizards. Siqhubekela esigabeni "Umbhalo". Thola bese uqokomisa igama OKUFANELEKILEbese uchofoza inkinobho "Kulungile".



3. Iwindi lokuphikisana okusebenzayo liyasebenza OKUFANELEKILE. Njengoba ukwazi ukubona, kule windi kunenkambu eyodwa kuphela ehambelana nokuphela kwengxabano yomsebenzi - "Umbhalo". Sidinga ukufaka ikheli leseli lokuqala kukholamu elinamagama abasebenzi kule nkambu. Lokhu kungenziwa ngesandla. Ukuqondisa ngokuqondisa kusuka kukhibhodi lapho. Kukhona futhi inketho yesibili, elula kakhulu. Setha isikhombisi esigangeni "Umbhalo", bese uqhafaza kuseli etafuleni lapho kubhalwe khona igama lokuqala lomsebenzi. Njengoba ukwazi ukubona, ikheli liyakhonjiswa endle. Manje nje kufanele senze ukuthinta kokugcina kulewindi - chofoza inkinobho "Kulungile".



4. Ngemuva kwalesi senzo, okuqukethwe kweseli lokuqala lekholomu enamagama okugcina kuboniswa entweni ekhethiwe ngaphambili, equkethe ifomula OKUFANELEKILE. Kepha, njengoba sibona, wonke amagama aboniswe kuleseli aqukethe kuphela amagama amakhulu.



5. Manje sidinga ukwenza ukuguqulwa kwawo wonke amanye amaseli ekholamu anamagama abasebenzi. Njengokulindelekile, ngeke sisebenzise ifomula ehlukile kwisisebenzi ngasinye, kodwa simane sikopishe esikhona usebenzisa umaki wokugcwalisa. Ukuze wenze lokhu, beka ikhesa ekhoneni elingezansi kwesokudla kweshidi eliqukethe ifomula. Ngemuva kwalokho, isikhombisi kufanele siguqulwe sibe umaki wokugcwalisa, obukeka njengesiphambano esincane. Sibambe inkinobho yegundane kwesobunxele bese sihudula umaki wokugcwalisa ngenombolo yamaseli alingana nenombolo yawo kukholamu enamagama abasebenzi bebhizinisi.



6. Njengoba ukwazi ukubona, ngemuva kwesenzo esichaziwe, zonke izibongo zaboniswa ebangeni lekhophi futhi ngasikhathi sinye zakha amagama amakhulu.



7. Kepha manje onke amanani asarejista esidingayo atholakala ngaphandle kwetafula. Sidinga ukuzifaka etafuleni. Ukuze wenze lokhu, khetha wonke amaseli agcwele amafomula OKUFANELEKILE. Ngemuva kwalokho chofoza kukhetho ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe evula, khetha Kopisha.



8. Ngemuva kwalokho, khetha ikholomu enegama eliphelele labasebenzi bebhizinisi etafuleni. Sichofoza kwikholamu ekhethiwe ngenkinobho yegundane elifanele. Imenyu yokuqukethwe yethulwe. Ebhlokini Faka Izinketho khetha isithonjana "Amanani", eboniswa njengesikwele esinezinamba.



9. Ngemuva kwalesi senzo, njengoba ubona, inguqulo eguquliwe yokupelwa kwezibongo ngamagama amakhulu izofakwa etafuleni lokuqala. Manje usususa ibanga eligcwele amafomula, ngoba asisaludingi. Khetha bese uchofoza kwesokudla. Kumenyu yokuqukethwe, khetha Sula okuqukethwe.

Ngemuva kwalokho, sebenza etafuleni ukuguqula izinhlamvu amagama abasebenzi ukuze abe izinhlamvu ezinkulu kungabhekwa njengokuqediwe.

Isifundo: I-Excel Feature Wizard

Indlela 2: Faka ama-macro

Ungase futhi uxazulule umsebenzi wokuguqula izinhlamvu ezincane kube izinhlamvu eziphezulu e-Excel usebenzisa i-macro. Kepha ngaphambi, uma ama-macros engafakiwe kunguqulo yakho yohlelo, udinga ukwenza lo msebenzi usebenze.

1. Ngemuva kokuthi usebenzise umsebenzi wama-macros, khetha ibanga ofuna ukuguqula kulo izinhlamvu zibe yizinhlamvu ezinkulu. Ngemuva kwalokho sithayipha izinqamuleli I-Alt + F11.



2. Iwindows liqala IMicrosoft Visual Basic. Lokhu empeleni, kungumhleli we-macro. Sithola inhlanganisela I-Ctrl + G. Njengoba ukwazi ukubona, emva kwalokho isikhombisi siya endaweni ephansi.



3. Faka ikhodi elandelayo kulo mkhakha:

   kukhetho ngalunye ekukhetheni: c.value = ucase (c): ngokulandelayo

   Bese ucindezela ukhiye ENTER bese uvale iwindi Okubonakalayo okuyisisekelo ngendlela ejwayelekile, okungukuthi, ngokuchofoza inkinobho esondele ngendlela yesiphambano ekhoneni layo elingakwesokudla.



4. Njengoba ukwazi ukubona, ngemuva kokwenza amacebo angenhla, idatha kuhlu olukhethiwe iyaguqulwa. Manje zinemali enkulu ngokuphelele.

Isifundo: Ungayakha kanjani iMacro ku-Excel

Ukuze uguqule ngokushesha zonke izinhlamvu embhalweni usuka kwisibhakela esincane kuya kwesiphezulu, futhi ungachithi isikhathi uzifaka futhi usuka kwikhibhodi, e-Excel kunezindlela ezimbili. Owokuqala ubandakanya ukusebenzisa umsebenzi OKUFANELEKILE. Inketho yesibili ilula kakhulu futhi ishesha. Kepha kusekelwe emsebenzini wama-macros, ngakho-ke leli thuluzi kumele lisebenze kwisibonelo sakho sohlelo. Kodwa ukufakwa kwama-macros ukudalwa kwephuzu elingeziwe lokungazethembi kohlelo olusebenzayo lwabahlaseli. Ngakho-ke umsebenzisi ngamunye uyazinqumela ukuthi iyiphi kulezi zindlela ezikhonjisiwe ezingcono ukuthi azisebenzise.