Indlela engu-5 Yokushintsha Okhefana Ngamachashazi ku-Excel

Emsebenzini wohlelo lwe-Excel, yonke into isebenza ngokuhambisana namafomula nemisebenzi ebekiwe. Ngisho nangenxa yechashazi elilodwa noma ikhoma, konke ukugcinwa kwamabhuku kungase kuhluleke. Futhi lokhu kusho ukuthi kuzoba usizo kumsebenzisi ngamunye wohlelo ukufunda indlela yokuthola ngokushesha iphutha elenziwe futhi alilungise.

Inqubo yokumiselela

Enguqulweni ye-Excel, kusetshenziswa ukhefana ukuchaza izingxenyana zamadesimali, kodwa ohlelweni lwesiNgisi, kusetshenziswa amachashazi. Ngokuvamile leli phutha lenzeka ngenxa yokusebenza ngezilimi ezimbili noma ngenxa yokuntula ulwazi.

Okokuqala, kufanelekile ukunquma ngezizathu zokuthi kungani kuye kwadingeka ukufaka ichashazi esikhundleni sekhefana. Kwezinye izimo, lokhu kungenxa yesibonisi esibonakalayo esikhangayo kunezidingo zokusebenza. Kodwa uma isidingo sokushintsha sinqunywa isidingo sokubala, ukukhetha indlela yokushintsha okhefana ngamachashazi kufanele kuthathwe ngokungathi sína. Kuye ngenjongo yokushintshwa, indlela izohluka.

Indlela yoku-1: Sebenzisa iThuluzi Lokuthola bese Ufaka esikhundleni

Enye yezindlela ezilula nezaziwa kakhulu zokushintsha ikhoma ngechashazi ukusebenzisa ithuluzi elibizwa ngokuthi Thola bese Ufaka esikhundleni. Ngeshwa, le ndlela ayifanelekile kumafrakshini asebenzayo. Lapho ushintsha ukhefana ngechashazi usebenzisa le ndlela, amanani eseli azoguqulwa abe ifomethi yombhalo. Cabangela indlela ye-Find and Replace:

1. Sikhetha ibanga elithile lamaseli adinga ukushintshwa. Uma uchofoza kwesokudla endaweni ekhethiwe, kuvela imenyu. Lapha sikhetha into ebizwa ngokuthi "Fometha Amaseli". Lo msebenzi ungabizwa ngesinqamuleli sekhibhodi u-Ctrl+1.
2. Uma "Ifomethi Yeseli" yenziwe yasebenza, iwindi lokufometha liyavuleka. Kupharamitha ethi "Inombolo", khetha umbandela othi "Umbhalo". Ukuze ulondoloze izinguquko ezenziwe, qiniseka ukuthi uchofoza "KULUNGILE". Uma uvele uvale iwindi lokufometha, zonke izinguquko zizolahlekelwa umphumela wazo.
3. Asiqhubekele esinyathelweni esilandelayo. Futhi, khetha inombolo edingekayo yamaseli. Kuthebhu esebenzayo "Ekhaya" sithola ibhulokhi yemisebenzi "Ukuhlela", khetha "Thola bese ukhetha". Kumenyu evela ngemva kwalokhu, inketho ethi "Faka esikhundleni" kufanele icushwe.

4. Okulandelayo, iwindi elibizwa ngokuthi "Thola futhi Faka Indawo" livuleka ukuze ugcwalise amapharamitha amabili "Thola" - uhlamvu, igama noma inombolo, futhi kokuthi "Faka esikhundleni" kufanele ucacise uhlamvu, igama noma inombolo okuzoshintshwa kuyo. eyenziwe. Ngakho, emgqeni othi "Thola" kuzoba khona "," uphawu, futhi emgqeni "Faka esikhundleni" - ".".
5. Ngemva kokugcwalisa imingcele, chofoza "Faka esikhundleni Konke". Ngemva kwalokho, kuzovela umlayezo omncane mayelana nenani lokushintshwa okwenziwe. Chofoza "KULUNGILE".

Le ndlela ikuvumela ukuthi ushintshe wonke amakhoma ngezikhathi endaweni ekhethiwe yamaseli. Inqubo ilula futhi iyashesha. Ububi bale ndlela ukushintshwa kwefomethi ngombhalo, okungabandakanyi ezinye izibalo.

Indlela yesi-2: Sebenzisa umsebenzi we-SUBSTITUTE

Indlela isekelwe ekusetshenzisweni komsebenzi ohambisanayo wegama elifanayo. Lapho ukhetha le ndlela, kuyadingeka ukuguqula idatha yeseli, bese uyikopisha bese uyinamathisela endaweni yedatha yasekuqaleni.

1. Ngokukhetha iseli engenalutho, eduze kweseli engase ishintshe. Yenza kusebenze okuthi “Faka umsebenzi” – uphawu emugqeni wemisebenzi ethi “fx”.
2. Efasiteleni elivela ngemisebenzi etholakalayo, sithola isigatshana esithi "Umbhalo". Khetha ifomula ebizwa ngokuthi "Substitute" bese ugcine okukhethiwe ngokucindezela inkinobho ethi "OK".

3. Kuvela iwindi lokugcwalisa imingcele edingekayo - "Umbhalo", "Umbhalo omdala" kanye "nombhalo omusha". Ipharamitha "Yombhalo" ihlanganisa ukufaka ikheli leseli elinenani langempela. Umugqa othi “Umbhalo Omdala” uhloselwe ukukhombisa uhlamvu oluzoshintshwa, okungukuthi, “,”, futhi kupharamitha “Yombhalo Omusha” sifaka u-“.” Uma wonke amapharamitha esegcwalisiwe, chofoza okuthi KULUNGILE. Okulandelayo kuzovela kuseli esebenzayo: =SUBSTITUTE(C4; “,”; “.”).

4. Ngenxa yalokho, inani leseli lishintshwa ngempumelelo. Lokhu kukhohlisa kufanele kuphindwe kuwo wonke amanye amaseli.
5. Le ndlela futhi inobubi obukhulu. Uma amanani ambalwa kuphela azoshintshwa, ukuphinda izinyathelo ngeke kuthathe isikhathi esiningi. Kodwa kuthiwani uma udinga ukushintsha uhlu olukhulu lwedatha. Ungasebenzisa, isibonelo, ukusebenzisa umaka wokugcwalisa iseli.
6. Ukuze usebenzise le nto, kufanele usethe ikhesa ekhoneni elingezansi kwesokudla seseli esebenzayo nomsebenzi osuvele ufakiwe. Kulesi simo, kuzovela isiphambano - okuthiwa umaka wokugcwalisa. Ngokuchofoza inkinobho yegundane kwesokunxele, kufanele uhudule lesi siphambano kanye nekholomu ngamavelu adinga ukushintshwa.
7. Ngenxa yalokho, amanani aseshintshile kakade azovela kukholamu ekhethiwe - esikhundleni samakhoma kumafrakshini amadesimali, manje sekunamachashazi. Manje udinga ukukopisha nokudlulisa wonke amanani aguquliwe atholiwe kumaseli ezinombolo zangempela. Gqamisa amaseli ashintshiwe. Chofoza inkinobho ethi “Kopisha” kuthebhu ethi “Okukhulu”.
8. Uma uchofoza kwesokudla igundane lekhompyutha kumaseli akhethiwe, imenyu ivela nesigaba esithi “Izinketho zokunamathisela”, thola bese ukhetha ipharamitha ethi “Values”. Ngokohlelo, le nto iboniswa njengenkinobho ethi “123”.
9. Amanani ashintshiwe azohanjiswa kumaseli afanele. Ukuze ususe amanani angadingekile kumenyu efanayo, khetha isigaba "Sula okuqukethwe".

Ngakho-ke, ukushintshwa kwamakhoma ezikhathini ebangeni elikhethiwe lamanani kwenziwe, futhi amanani angadingekile asusiwe.

Indlela yesi-3: Lungisa Izinketho ze-Excel

Ngokulungisa amapharamitha athile wohlelo lwe-Excel, ungakwazi futhi ukufeza ukushintshwa kophawu “,” ngo “.”. Kulesi simo, ifomethi yamaseli izohlala iyinombolo, futhi ngeke ishintshe ibe umbhalo.

1. Ngokuvula ithebhu ethi "Ifayela", khetha okuthi "Izinketho" vimba.
2. Kufanele uye esigabeni esithi "Okuthuthukisiwe" futhi uthole "Izinketho Zokuhlela". Susa ukumaka ibhokisi eliseduze nesimiso "Sebenzisa izihlukanisi zesistimu". Emgqeni othi "Isihlukanisi sezingxenye eziphelele neziyingxenye" ​​sishintsha ichashazi, okuzenzakalelayo, libe ikhoma.

Ngemuva kwezinguquko ezenziwe kuzilungiselelo zohlelo lwe-Excel, i-delimiter yokusho izingxenyana manje isikhathi.

Indlela yesi-4: Sebenzisa i-Custom Macro

Enye indlela yokushintsha ama-semicolon ku-Excel ibandakanya ukusetshenziswa kwama-macros. Kodwa ngaphambi kokuwasebenzisa, kufanele ucabangele iqiniso lokuthi ama-macros akhutshaziwe ngokuzenzakalelayo ohlelweni. Ngakho-ke, ukuze uqalise, udinga ukunika amandla ithebhu ethi "Unjiniyela" futhi wenze kusebenze ama-macros.

Imodi "Yonjiniyela" inikwe amandla ngezilungiselelo zohlelo. Esigatshaneni esibizwa ngokuthi "Yenza ngokwezifiso i-ribbon", bese esigabeni esithi "Amathebhu amakhulu" sithola into ethi "Unjiniyela", esibeka uphawu phambi kwayo. Izilungiselelo ziyasebenza ngemuva kokucindezela inkinobho ethi "KULUNGILE".

1. Tab “Unjiniyela” → vimba “Ikhodi”, cindezela inkinobho ebizwa ngokuthi “Visual Basic”.
2. Iwindi lomhleli omkhulu lizovuleka. Kuleli windi, udinga ukufaka ikhodi yohlelo elandelayo:

Kulesi sigaba, siqeda umsebenzi kusihleli ngokuvele sivale iwindi lomhleli.

3. Khetha amaseli lapho izinguquko zizokwenziwa khona. Cindezela inkinobho ethi “Macros”, etholakala ebhokisini lamathuluzi.
4. Kuvela iwindi elibonisa amamakhro atholakalayo. Khetha i-macro esanda kwakhiwa. Uma i-macro ekhethiwe, chofoza "Run" ukuze uyivule.

5. Ukushintshwa kuyenziwa - amachashazi avele esikhundleni samakhoma.

Ukusetshenziswa kwale ndlela kudinga ukunakwa okukhethekile. Ngemuva kokwenza i-macro isebenze, akusakwazi ukubuyisela yonke into emuva. Lapho ukhetha amaseli anamanani athile, udinga ukwenza isiqiniseko sokuthi izinguquko zizokwenziwa kuphela kuleyo datha eyidinga ngempela.

Indlela yesi-5: Shintsha izilungiselelo zesistimu yekhompyutha

Le ndlela ayivamile kakhulu, nokho, iphinde isetshenziselwe ukufaka okhefana esikhundleni sezikhathi lapho kwenziwa izibalo kumadokhumenti e-Excel. Sizoshintsha izilungiselelo ngqo kusofthiwe. Cabanga ngale nqubo usebenzisa isibonelo se-Windows 10 Pro software.

1. Siya ku- "Control Panel", engabizwa ngokuthi "Qala".

2. Esigabeni "Isikhathi nolimi", khetha inketho ethi "Isifunda".
3. Ngemva kwalokho, iwindi lizovuleka. Lapha senza kusebenze "Izinketho ezengeziwe zosuku, isikhathi, isifunda".

4. Iwindi elisha lizovuleka, lapho siya khona ku- "Regional Standards".

5. Manje yiya kuthebhu ethi “Amafomethi” futhi ezansi kwewindi vula “Izinketho ezithuthukisiwe ...”.

6. Okulandelayo, esigabeni esithi “Izinombolo,” cacisa uhlamvu lwesihlukanisi oludingekayo emgqeni othi “Isihlukanisi senamba nezingxenye eziyingxenye.” Ngemva kokwenza izinguquko, chofoza "OK".

Njengomphumela womsebenzi wethu, okhefana kumaseli-izinkambu zamathebula e-Excel agcwele amanani ezinombolo azoguqulwa abe ongqi. Kulokhu, ifomethi yeseli ayinandaba, kungakhathaliseki ukuthi "Okuvamile" noma "Izinombolo".

Kubalulekile! Uma udlulisela ifayela kwenye ikhompuyutha enezilungiselelo ezijwayelekile, kungase kuvele izinkinga ngenqubo yokubala.

Indlela Eyengeziwe: Ukushintsha ichashazi ngokhefana ku-Excel usebenzisa i-Notepad

Isofthiwe ye-Windows inohlelo lwe-Notepad olusebenza ngesisekelo senani elincane lemisebenzi nezilungiselelo. I-“Notepad” ingasetshenziswa njengomxhumanisi wokukopisha, ukuhlola kuqala idatha.

1. Udinga ukukhetha uhla olufunayo lwamaseli bese ulukopisha. Vula i-Notepad bese unamathisela amanani akopishiwe efasiteleni elivulekayo.

2. Kuthebhu ethi "Hlela", khetha isigaba "Faka esikhundleni". Njengokhiye oshisayo, inhlanganisela "CTRL + H" isetshenziswa. Kuvela iwindi lapho sigcwalisa khona izinkambu. Emgqeni othi "Yini" faka ",", emgqeni "Yini" - ".". Lapho izinkambu zigcwalisiwe, chofoza okuthi "Faka esikhundleni Konke".

Ngemva kwalezi zikhohlisi embhalweni ofakiwe, wonke amakhoma aguqulwa abe ongqi. Manje sekusele kuphela ukukopisha amanani ashintshiwe ama-fractional XNUMX futhi uwanamathisele etafuleni lombhalo we-Excel.

Isiphetho

I-athikili ihlole izindlela eziphumelela kakhulu nezidumile zokushintsha uhlamvu lukakhefana kumafrakshini wedesimali ngamachashazi kumaspredishithi e-Excel. Ngokuvamile, abasebenzisi bakhetha ithuluzi elakhelwe ngaphakathi elithi Thola futhi Umiselele ukuze libukeke ngokubukeka lamanani amanani, futhi umsebenzi we-SUBSTITUTE usetshenziselwa ukwenza izibalo.