Ungabhala kanjani wonke amagama ngosonhlamvukazi ku-Excel. Izindlela Ezi-2 Zokushintsha Izinhlamvu Ezincane Ngezinhlamvu Ezinkulu ku-Excel

Abantu abasebenza ngokuzikhandla e-Excel bavame ukulungiselela imibiko yama-ejensi ahlukahlukene kahulumeni, bahlangane njalo nezimo lapho wonke umbhalo ovela embhalweni, obhalwe ngezinhlamvu ezijwayelekile, udinga ukushintshwa ngamagama amakhulu. Ungakwenza lokhu kusenesikhathi uma umbhalo ungakabhalwa. Vele ucindezele okuthi “CapsLock” bese ugcwalisa wonke amaseli adingekayo ngosonhlamvukazi. Kodwa-ke, lapho itafula selivele lilungile, ukushintsha yonke into ngesandla kuyinkinga impela, kunengozi enkulu yokwenza amaphutha. Ukwenza le nqubo ngokuzenzakalelayo, ungasebenzisa eyodwa yezindlela ezi-2 ezitholakalayo ze-Excel.

Inqubo yokushintsha izinhlamvu ezincane zibe ngosonhlamvukazi

Uma siqhathanisa ukwenziwa kwale nqubo ku-Word ne-Excel, kumhleli wombhalo, kwanele ukwenza ukuchofoza okulula okumbalwa esikhundleni sazo zonke izinhlamvu ezijwayelekile ngosonhlamvukazi. Uma sikhuluma ngokushintsha idatha etafuleni, yonke into iyinkimbinkimbi kakhulu lapha. Kunezindlela ezimbili zokushintsha izinhlamvu ezincane zibe ngosonhlamvukazi:

1. Ngokusebenzisa i-macro ekhethekile.
2. Ukusebenzisa umsebenzi – PHEZULU.

Ukuze ugweme noma yiziphi izinkinga ohlelweni lokushintsha ulwazi, zombili izindlela kufanele zibhekwe ngokuningiliziwe.

Ngemakhro

I-macro iyisenzo esisodwa noma inhlanganisela yazo engenziwa izikhathi eziningi. Kulokhu, izenzo eziningana zenziwa ngokucindezela ukhiye owodwa.. Ngenkathi udala ama-macros, izinkinobho zekhibhodi negundane ziyafundwa.

Kubalulekile! Ukuze i-macro ithathe indawo yezinhlamvu ezincane ngosonhlamvukazi ukuze isebenze, kufanele uqale uhlole ukuthi ngabe umsebenzi we-macro uyasebenza yini ohlelweni noma cha. Uma kungenjalo, indlela izoba yize.

Inqubo:

1. Ekuqaleni, udinga ukumaka ingxenye yekhasi, umbhalo ofuna ukuwushintsha. Ukuze wenze lokhu, ungasebenzisa igundane noma ikhibhodi.

2. Lapho ukukhetha sekuqediwe, kufanele ucindezele inhlanganisela yokhiye "Alt + F11".
3. Isihleli esikhulu kufanele sivele esikrinini. Ngemuva kwalokho, udinga ukucindezela inhlanganisela yokhiye elandelayo "Ctrl + G".
4. Endaweni evulekile evuliwe “ngokushesha” kuyadingeka ukuthi kubhalwe umusho wokusebenza “kulowo nalowo c ekukhetheni:c.value=ucase(c):olandelayo”.

Isenzo sokugcina sicindezela inkinobho ethi "Enter". Uma umbhalo ufakwe ngendlela efanele futhi ngaphandle kwamaphutha, zonke izinhlamvu ezincane ohlwini olukhethiwe zizoshintshwa zibe ngofeleba.

Ukusebenzisa umsebenzi OPHEZULU

Inhloso yomsebenzi OPHEZULU iwukuba esikhundleni sezinhlamvu ezijwayelekile ufake osonhlamvukazi. Inefomula yayo: =UPPER(Umbhalo oguquguqukayo). Ekuphikisaneni okuwukuphela kwalo msebenzi, ungacacisa amanani angu-2:

• izixhumanisi zeseli nombhalo ozoshintshwa;
• izinhlamvu ezizoshintshwa zibe ngosonhlamvukazi.

Ukuze uqonde ukuthi ungasebenza kanjani nalo msebenzi, kuyadingeka ukucabangela esinye sezibonelo ezisebenzayo. Umthombo kuzoba itafula elinemikhiqizo amagama ayo abhalwe ngezinhlamvu ezincane, ngaphandle kosonhlamvukazi bokuqala. Inqubo:

1. Maka nge-LMB indawo etafuleni lapho umsebenzi uzokwethulwa khona.
2. Okulandelayo, udinga ukuchofoza inkinobho yokwengeza umsebenzi we- "fx".

3. Kumenyu ye-Function Wizard, khetha "Umbhalo" uhlu.
4. Uhlu lwemisebenzi yombhalo luzovela, lapho uzodinga ukukhetha OKUPHEZULU. Qinisekisa ukukhetha ngenkinobho ethi "KULUNGILE".

5. Efasiteleni lempikiswano yomsebenzi elivulekayo, kufanele kube nenkambu yamahhala ebizwa ngokuthi “Umbhalo”. Kuyo, udinga ukubhala izixhumanisi zeseli lokuqala kusuka ebangeni elikhethiwe, lapho udinga ukufaka esikhundleni sezinhlamvu ezijwayelekile ngosonhlamvukazi. Uma amaseli ehlakazekile eduze kwetafula, kuzodingeka ucacise izixhumanisi zalelo nalelo qoqo. Chofoza inkinobho ethi "OK".
6. Umbhalo osushintshiwe kakade osuka kuseli, izixhumanisi zawo ezishiwo ku-agumenti yomsebenzi, uzoboniswa kuseli elikhethwe kusengaphambili. Zonke izinhlamvu ezincane kufanele zishintshwe zibe ngosonhlamvukazi.
7. Okulandelayo, udinga ukusebenzisa isenzo somsebenzi kuseli ngalinye ukusuka ebangeni elikhethiwe. Ukuze wenze lokhu, udinga ukukhomba ikhesa esitokisini ngombhalo oshintshiwe, ulinde kuze kuvele isiphambano esimnyama emaphethelweni angakwesokudla kwesokunxele. Chofoza kuyo nge-LMB, kancane kancane udonsele phansi amaseli amaningi njengoba udinga ukushintsha idatha.

8. Ngemva kwalokho, kufanele kuvele ikholomu ehlukile enolwazi oselushintshile.

Isigaba sokugcina somsebenzi ukushintshwa kohlu lwangempela lwamaseli nalolo oluvele ngemva kokuba zonke izenzo seziqediwe.

1. Ukuze wenze lokhu, khetha amaseli anolwazi olushintshile.
2. Chofoza kwesokudla ebangeni elikhethiwe, khetha umsebenzi othi “Kopisha” kumenyu yokuqukethwe.
3. Isinyathelo esilandelayo ukukhetha ikholomu ngolwazi lokuqala.
4. Cindezela inkinobho yegundane engakwesokudla ukuze ushayele imenyu yokuqukethwe.
5. Ohlwini oluvelayo, thola ingxenye ethi "Namathisela Izinketho", khetha inketho - "Amanani".
6. Wonke amagama emikhiqizo abekhonjisiwe azothathelwa indawo amagama abhalwe ngosonhlamvukazi.

Ngemuva kwakho konke okuchazwe ngenhla, akufanele sikhohlwe ngokususa ikholomu lapho ifomula ifakwe khona, eyasetshenziselwa ukwakha ifomethi yolwazi olusha. Uma kungenjalo, izophazamisa ukunaka, ithathe indawo yamahhala. Ukuze wenze lokhu, udinga ukukhetha indawo eyengeziwe ngokubamba inkinobho yegundane kwesokunxele, chofoza kwesokudla endaweni ekhethiwe. Khetha "Susa" kumenyu yokuqukethwe.

Isiphetho

Uma ukhetha phakathi kokusebenzisa i-macro noma umsebenzi OPHEZULU, abaqalayo bavame ukukhetha ama-macros. Lokhu kungenxa yesicelo sabo esilula. Noma kunjalo, ama-macros awaphephile ukuwasebenzisa. Uma icushiwe, idokhumenti iba sengozini yokuhlaselwa kwe-hacker, ngenxa yalokhu, kunconywa ukufunda indlela yokusebenzisa umsebenzi OKUPHEZULU.