Ungakuvumela kanjani ukuhlola isipelingi ku-Excel

Labo abasebenza kumhleli wombhalo we-MS Word babone ukuthi ukudwebela okubomvu kuvela kanjani lapho amagama engapelwanga kahle noma kwenziwa umshini wokuthayipha. Ngeshwa, kuhlelo lokusebenza lwe-MS Excel, ukusebenza okunjalo kushoda kakhulu. Kuyacaca ukuthi zonke izinhlobo zezifinyezo, izifinyezo nezinye izipelingi zamagama efomini eliguquliwe zingadukisa uhlelo, futhi zizonikeza ngokuzenzakalelayo imiphumela engalungile. Naphezu kwalokhu, umsebenzi onjalo ukhona, futhi ungawusebenzisa.

Setha ulimi olumisiwe lube

Ukulungisa okuzenzakalelayo kwama-typos namagama angapeliwe kahle kunikwe amandla ngokuzenzakalela, kodwa uhlelo lunezinkinga zohlelo oluhlukile. Lapho ubheka amadokhumenti ngemodi ezenzakalelayo, ezimweni eziyi-9 kweziyi-10, uhlelo luphendula emibhalweni yesiNgisi ebhalwe ngokungalungile. Kungani lokhu kwenzeka nokuthi ungayilungisa kanjani, ake sizame ukukuthola ngokuqhubekayo:

1. Phezulu kwephaneli, chofoza inkinobho ethi “Fayela” bese ulandela isixhumanisi esithi “Izinketho”.

2. Khetha “Ulimi” ohlwini olungakwesokunxele.
3. Iwindi elilandelayo lezilungiselelo zolimi linezilungiselelo ezimbili. Kowokuqala "Ukukhetha Izilimi Zokuhlela" ungabona lokho kusethwe ngokuzenzakalelayo.

Uma, ngasizathu simbe, ukhetha isiNgisi (USA) ukuthi sisebenze nemibhalo, kuzomele wenze okunye esikhundleni ngokuvula ulayini ngokukhetha ulimi bese uchofoza inkinobho ethi “Okuzenzakalelayo” ekhanyisayo.

4. Okulandelayo, sehlela entweni ethi "Ukukhetha izilimi zesixhumi esibonakalayo nosizo". Lapha, ngokuzenzakalelayo, njengoba ubona, isikhombimsebenzisi sisethelwe olimini lwe-Microsoft Windows, futhi ngereferensi, ulimi lwesixhumi esibonakalayo.

5. Kuyadingeka ukwenza esikhundleni se-. Ungakwenza ngenye yezindlela ezilandelayo: chofoza umugqa othi “” bese uchofoza inkinobho ethi “Okuzenzakalelayo” ngezansi, noma uchofoze inkinobho esebenzayo ngomcibisholo oya phansi.
6. Kuhlala kuphela ukuvumelana ngokuchofoza "KULUNGILE". Kuzovela iwindi elinezincomo zokuqalisa kabusha uhlelo ukuze izinguquko zisebenze. Siyavuma futhi siqalise kabusha ngemodi eyenziwa mathupha.

Ngemva kokuqalisa kabusha, uhlelo kufanele lwenze ngokuzenzakalelayo ulimi oluyinhloko.

Okudingayo ukuze unike amandla isipelingi ku-Excel

Lokhu kusetha akuqediwe, futhi udinga ukwenza ezinye izinyathelo ezimbalwa:

• Kuhlelo lokusebenza olusanda kwethulwa, iya kokuthi “Fayela” futhi bese uvula “Izinketho”.
• Okulandelayo, sinentshisekelo ethuluzini lokupela. Yenza kusebenze ukuvuleka kwewindi ngokuchofoza umugqa we-LMB.
• Sithola umugqa "Izinketho Zokulungisa Okuzenzakalelayo ..." bese uchofoza kuwo LMB.

• Siya efasiteleni elivulayo, lapho udinga ukwenza kusebenze ikholomu ethi "AutoCorrect" (njengomthetho, ivuliwe uma iwindi livuliwe).
• Esihlokweni esithi “Bonisa izinkinobho zezinketho zokulungisa ngokuzenzakalelayo” sithola umsebenzi ofakiwe. Lapha, ukuze kube lula ukusebenza ngamatafula, kunconywa ukukhubaza imisebenzi eminingana, isibonelo, "Yenza izinhlamvu zokuqala zemisho ngosonhlamvukazi" kanye "Bhala amagama ezinsuku ngohlamvu olukhulu".

Incazelo evela kuchwepheshe! Njengoba ulimi lungakuhlinzekeli ukubhala izinsuku zesonto ngosonhlamvukazi, ungasusa ukumaka lo mugqa. Kuyaphawuleka ukuthi ukubhala ngosonhlamvukazi izinhlamvu zokuqala zomusho akuwenzi umqondo, njengoba ukusebenza ngamatafula kuhilela izifinyezo eziqhubekayo. Uma ushiya uphawu lokuhlola kule nto, ngemva kwephuzu ngalinye egameni elifushanisiwe, uhlelo luzosabela futhi lulungise igama elingapeliwe kahle.

Sehla ngezansi futhi sibona ukuthi kuleli windi lesixhumi esibonakalayo kukhona nohlu lwamagama alungisa ngokuzenzakalelayo. Ngakwesokunxele, kuhlongozwa ukwahluka kwamagama apelwe ngokungalungile, futhi kwesokudla, izinketho zokuzilungisa. Yebo, lolu hlu alukwazi ukubizwa ngokuthi luphelele, kodwa namanje amagama amakhulu angapeliwe kahle akhona kulolu hlu.

Phezulu kunezinkambu zokufaka amagama okusesha. Isibonelo, masibhale “umshini”. Uhlelo luzophakamisa ngokuzenzakalelayo igama lokulungisa ngokuzenzakalelayo endaweni engakwesokunxele. Esimweni sethu, lokhu "umshini". Kungenzeka futhi ukuthi igama ngeke libe kusichazamazwi esihlongozwayo. Ngemuva kwalokho uzodinga ukufaka isipelingi esifanele mathupha bese uchofoza inkinobho ethi "Engeza" ngezansi. Lokhu kuqeda izilungiselelo, futhi ungaqhubeka nokuqalisa ukuhlola ukupela okuzenzakalelayo ku-Excel.

Qalisa isihloli sokupela esizenzakalelayo

Ngemva kokuhlanganisa ithebula nokurekhoda lonke ulwazi oludingekayo, kuyadingeka ukuhlola ukupela kombhalo. Ukuze wenze lokhu, udinga ukwenza uhlu olulandelayo lwezenzo:

• Uma udinga ukuhlola ingxenye yombhalo kuphela, bese ukhetha leyo okumele ihlolwe. Uma kungenjalo, asikho isidingo sokugqamisa umbhalo.
• Phezulu kohlelo, thola ithuluzi Lokubuyekeza.
• Okulandelayo, entweni ethi "Spelling", thola inkinobho ethi "Spelling" bese uchofoza kuyo nge-LMB.

• Iwindi lizovuleka lapho uzocelwa ukuthi uqhubeke nokuhlola ukupela kusukela ekuqaleni kweshidi. Chofoza inkinobho ethi "Yebo".
• Ngemva kokuthi ithuluzi lithole igama elingapeliwe kahle, ibhokisi lengxoxo lizovela negama uhlelo olucabanga ukuthi alipelwanga kahle.

• Esigabeni esithi “Izinketho,” khetha igama elifanele bese uchofoza okuthi “Faka esikhundleni” uma kunegama elilodwa kuphela elinjalo embhalweni, noma “Faka Faka Konke esikhundleni” uma kungenzeka ukuthi igama elikhethiwe livela izikhathi eziningana.

Inothi elivela kuchwepheshe! Futhi naka ezinye izinto ezitholakala kwesokudla. Uma uqinisekile ukuthi igama lipelwe kahle, kuzomele ukhethe okuthi “Yeqa” noma “Yeqa konke”. Futhi, uma uqinisekile ukuthi igama alipelwanga kahle, ungasebenzisa okuthi “AutoCorrect”. Kulokhu, uhlelo luzoshintsha ngokuzenzakalelayo wonke amagama ngokwalo. Kukhona enye into "Engeza kusichazamazwi". Kuyadingeka ukuthi uzenzele amagama ongase ungapeli kahle.

Isiphetho

Kungakhathaliseki ukuthi uchwepheshe kangakanani kuwe, awusoze waqiniseka ngokuphelele ngokunemba kombhalo obhaliwe. Isici somuntu sihlanganisa ukucatshangwa kwezinhlobo ezahlukene zamaphutha. Ikakhulukazi kuleli cala, i-MS Excel inikeza ithuluzi lokuhlola ukupela, ngokulisebenzisa ongalungisa amagama angapeliwe kahle.