Ukushintsha amachashazi ngokhefana ku-Excel ngezindlela ezihlukene

Imvamisa, ngenkathi usebenza kumathebula e-Excel, kuba nesidingo sokushintsha amachashazi ngokhefana. Lokhu kuvame ukubangelwa ukuthi emazweni akhuluma isiNgisi ichashazi lisetshenziselwa ukuhlukanisa izingxenye eziyingxenyana neziphelele enambeni, kuyilapho ezweni lakithi kusetshenziswa ikhoma ngokwale njongo.

Futhi konke kuzolunga, kodwa inkinga iwukuthi enguqulweni yaseRussia ye-Excel, idatha enechashazi ayibonwa njengezinombolo, okwenza kube nzima ukuqhubeka nokuzisebenzisa ekubaleni. Futhi ukuze ulungise lokhu, udinga ukushintsha ichashazi ngokhefana. Ukuthi lokhu kungenziwa kanjani kahle ku-Excel, sizocubungula kulesi sihloko.

Indlela yoku-1: Ukusebenzisa Ithuluzi Lokuthola Nokubuyisela

Sizoqala, mhlawumbe, indlela elula, ebandakanya ukusetshenziswa kwethuluzi “Thola Bese Ufaka Esikhundleni”, lapho usebenza okufanele uqaphe kakhulu ukuthi ungashintshi izikhathi ngephutha ngokhefana kudatha lapho lokhu kungafanele kwenziwe (ngokwesibonelo, ngezinsuku). Ngakho nansi indlela esebenza ngayo:

1. Iya kuthebhu "Ikhaya", bese uchofoza inkinobho "Thola bese ukhetha" (isithonjana sengilazi yokukhulisa) kubhulokhi "Ukuhlela". Uhlu luzovuleka lapho sikhetha khona umyalo "Faka esikhundleni". Noma ungavele ucindezele inhlanganisela yokhiye Ctrl + H.
2. Iwindi lizovela esikrinini. "Thola Futhi Faka Indawo":
   • ensimini yokufaka inani eliphambene nento “Thola” sibhala uphawu "." (iphuzu);
   • endaweni ethi “Faka esikhundleni ngokuthi”, bhala uphawu "," (ukhefana);
   • cindezela inkinobho "Amapharamitha".
3. Ezinye izinketho zizovela ukuze wenze okuthi Thola bese Ufaka esikhundleni. Ngokuchofoza inkinobho "Ifomethi" okwepharamitha “Kufakwe esikhundleni sika-”.
4. Efasiteleni elivelayo, cacisa ifomethi yeseli elungisiwe (leyo esiyithola ekugcineni). Ngokusho umsebenzi wethu, sikhetha "Okwezinombolo" fometha, bese uchofoza OK. Uma uthanda, ungasetha inombolo yezindawo zamadesimali, kanye namaqembu ahlukene wamadijithi ngokusetha ibhokisi lokuhlola elifanele.
5. Ngenxa yalokho, sizophinde sizithole sisefasiteleni “Thola Bese Ufaka Esikhundleni”. Lapha sidinga ukukhetha indawo yamaseli lapho amaphuzu azoseshwa khona bese eshintshwa ngokhefana. Uma kungenjalo, umsebenzi wokubuyisela uzokwenziwa kulo lonke ishidi, futhi idatha okungafanele ishintshwe ingase ithinteke. Ukukhetha uhla lwamaseli kwenziwa ngokucindezela inkinobho yegundane kwesokunxele. Cindezela uma usulungile "Faka Konke esikhundleni".
6. Konke sekulungile. Umsebenzi waqedwa ngempumelelo, njengoba kuboniswa iwindi lolwazi ngenani lokushintshwa okwenziwe.
7. Sivala wonke amawindi (ngaphandle kwe-Excel ngokwayo), ngemva kwalokho singaqhubeka nokusebenza nedatha eguquliwe etafuleni.

Qaphela: ukuze ungakhethi ububanzi bamaseli lapho usetha amapharamitha efasiteleni “Thola Bese Ufaka Esikhundleni”, ungakwenza kusenesikhathi, okungukuthi khetha kuqala amaseli, bese uvula ithuluzi elifanele ngezinkinobho eziseribhoni yohlelo noma usebenzisa isinqamuleli sekhibhodi. Ctrl + H.

Indlela yesi-2: Umsebenzi we-SUBSTITUTE

Manje ake sibheke umsebenzi "SUBSTITUTE", okukuvumela futhi ukuthi umisele amachashazi ngokhefana. Kodwa ngokungafani nendlela esixoxe ngayo ngenhla, ukushintshwa kwamanani akwenziwa kwabaqalayo, kodwa kuboniswa kumaseli ahlukene.

1. Siya esitokisini esiphezulu kakhulu sekholomu lapho sihlela ukubonisa idatha, ngemva kwalokho sicindezela inkinobho "Faka umsebenzi" (fx) kwesokunxele sebha yefomula.
2. Efasiteleni elivuliwe Umsebenzi Wizards khetha isigaba - "Umbhalo", lapho sithola khona u-opharetha "SUBSTITUTE", ikhethe bese uchofoza OK.
3. Sizozithola sisefasiteleni elinama-agumenti okusebenza adinga ukugcwaliswa:
   • enanini lempikiswano "Umbhalo" cacisa izixhumanisi zeseli yokuqala yekholomu ofuna ukufaka kuyo amachashazi ngokhefana. Ungakwenza lokhu mathupha ngokufaka ikheli usebenzisa okhiye abakukhibhodi. Noma ungaqale uchofoze igundane ngaphakathi kwenkundla ukuze ufake ulwazi, bese uchofoza iseli oyifunayo kuthebula.
   • enanini lempikiswano "Star_Text" sibhala uphawu "." (iphuzu).
   • ngengxabano “Umbhalo_omusha” cacisa uphawu njengenani "," (ukhefana).
   • inani lempikiswano “Inombolo_yokungena” zingagcwaliswa.
   • chofoza uma usulungile OK.
4. Sithola umphumela esiwufunayo kuseli ekhethiwe.
5. Kusala kuphela ukunweba lo msebenzi emigqeni esele yekholomu. Vele, awudingi ukwenza lokhu ngesandla, njengoba i-Excel inomsebenzi wokuqedela ngokuzenzakalela. Ukuze wenze lokhu, hambisa ikhesa ekhoneni elingezansi kwesokudla seseli ngefomula, lapho isikhombisi sishintsha sibe uphawu olumnyama lokuhlanganisa (umaka wokugcwalisa), cindezela inkinobho yegundane kwesokunxele bese usihudulela phansi emgqeni wokugcina ohilelekile. ukuguqulwa kwedatha.
6. Kusele kuphela ukuhambisa idatha eguquliwe iye endaweni esethebula lapho kufanele ibe khona. Ukuze wenze lokhu, khetha amaseli wekholomu ngemiphumela (uma okukhethiwe kusuliwe ngemuva kwesenzo sangaphambilini), chofoza kwesokudla kunoma iyiphi indawo ebangeni elikhethiwe bese ukhetha into. "Kopisha" (noma cindezela isinqamuleli sekhibhodi Ctrl + C).
7. Bese sikhetha ububanzi obufanayo bamaseli kukholamu yokuqala idatha yayo eguquliwe. Sichofoza kwesokudla endaweni ekhethiwe nakumenyu yokuqukethwe evulayo, kuzinketho zokunamathisela, khetha “Amanani”.
8. Ngemva kokunamathisela idatha ekopishiwe, isithonjana sophawu lwesibabazo sizovela eduze kwalo. Chofoza kuso bese ukhetha ohlwini "Guqula ube inombolo".
9. Konke sekumi ngomumo, sinekholomu lapho zonke izikhathi zishintshwa ngokhefana.
10. Ikholomu yomsebenzi esetshenziselwa ukusebenza nomsebenzi I-SUBSTITUTE, ayisadingeki futhi ingasuswa ngemenyu yokuqukethwe. Ukuze wenze lokhu, chofoza kwesokudla kukholomu ebekwe kubha yokuxhumanisa evundlile bese ukhetha umyalo ohlwini oluvelayo. "Susa".
11. Izenzo ezingenhla, uma kudingeka, zingenziwa ngokuhlobene namanye amakholomu ethebula lomthombo.

Indlela 3: Ukusebenzisa iMacro

Amamakhro futhi akuvumela ukuthi ushintshe ichashazi ngokhefana. Nansi indlela okwenziwa ngayo:

1. Okokuqala udinga ukwenza isiqiniseko sokuthi ithebhu ivuliwe “Unjiniyela”ekhutshazwa ngokuzenzakalelayo ku-Excel. Ukuze unike amandla ithebhu oyifunayo, hamba kumenyu "Ifayela".
2. Ohlwini olungakwesokunxele, hamba esigabeni "Amapharamitha".
3. Kuzinketho zohlelo, chofoza ingxenye “Yenza ngendlela oyifisayo i-Ribbon”, ngemva kwalokho, engxenyeni efanele yefasitela, faka uphawu phambi kwento “Unjiniyela” bese uchofoza OK.
4. Shintshela kuthebhu “Unjiniyela”lapho sichofoza inkinobho "VisualBasic".
5. Kumhleli, chofoza eshidini esifuna ukulishintsha, efasiteleni elivulayo, namathisela ikhodi engezansi, bese uvala isihleli:

   Sub Макрос_замены_точки_на_запятую()

   Ukukhetha.Faka esikhundleni se-What:=".", Replacement:=".", LookAt:=xlPart, _

   I-SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=Amanga, _

   I-ReplaceFormat:=Amanga

   Qeda i-Sub

6. Manje khetha uhla lwamaseli eshidini lapho sihlela ukwenza khona ukushintshwa, bese uchofoza inkinobho "Imakhro" konke kuthebhu efanayo “Unjiniyela”.
7. Iwindi lizovuleka ngohlu lwamamakhro, lapho sikhetha khona “Macro_replaceing_dot_by_comma” bese ucindezela "Gijima".
8. Njengomphumela, sizothola amaseli anedatha eguquliwe, lapho amachashazi ashintshwe ngokhefana, okuyikhona ebesikudinga.

Indlela 4: Ukusebenzisa i-Notepad

Le ndlela isetshenziswa ngokukopisha idatha kusihleli esakhelwe ohlelweni lokusebenza lweWindows. Inothi ukuhlela kamuva. Inqubo iboniswa ngezansi:

1. Okokuqala, sikhetha uhla lwamaseli kumanani okudingeka sishintshe amachashazi ngokhefana (ake sicabangele ikholomu eyodwa njengesibonelo). Ngemuva kwalokho, chofoza kwesokudla kunoma iyiphi indawo endaweni ekhethiwe bese ukhetha umyalo kwimenyu evulayo. "Kopisha" (noma ungasebenzisa isinqamuleli sekhibhodi Ctrl + C).
2. Qalisa Inothi bese unamathisele ulwazi olukopishiwe. Ukuze wenze lokhu, chofoza kwesokudla bese ukhetha umyalo kumenyu yokudonsela phansi. "Faka" (noma sebenzisa inhlanganisela Ctrl + V).
3. Kubha yemenyu ephezulu, chofoza "Hlela". Uhlu luzovuleka, lapho sichofoza khona umyalo "Faka esikhundleni" (noma cindezela ama-hotkeys Ctrl + H).
4. Iwindi elincane lokubuyisela lizovela esikrinini:
   • emkhakheni wokufaka inani lepharamitha "Ini" phrinta uhlamvu "." (iphuzu);
   • njengenani lepharamitha "Kanjani" beka uphawu "," (ukhefana);
   • Phusha "Faka Konke esikhundleni".
5. Vala iwindi lokumiselela. Khetha idatha eguquliwe, bese uchofoza kwesokudla kuyo bese ukhetha umyalo "Kopisha" kumenyu yokuqukethwe evulayo (ungasebenzisa futhi Ctrl + C).
6. Asibuyele ku-Excel. Simaka indawo ofuna ukufaka kuyo idatha eshintshiwe. Bese uchofoza kwesokudla ebangeni elikhethiwe bese ukhetha umyalo "Gcina umbhalo kuphela" kuzinketho zokufaka (noma chofoza Ctrl + V).
7. Kusala kuphela ukusetha ifomethi yeseli njenge "Okwezinombolo". Ungayikhetha ebhokisini lamathuluzi "Inombolo" (ithebhu "Ikhaya") ngokuchofoza ifomethi yamanje bese ukhetha oyifunayo.
8. Umsebenzi uqedwe ngempumelelo.

Indlela 5: Ukusetha Izinketho ze-Excel

Ngokusebenzisa le ndlela, sidinga ukushintsha izilungiselelo zohlelo ezithile.

1. Iya kumenyu "Fayela", lapho sichofoza khona ingxenye "Amapharamitha".
2. Kumapharamitha ohlelo ohlwini olungakwesokunxele, chofoza ingxenye “Okwengeziwe”… Kubhulokhi yezilungiselelo "Hlela Izinketho" khipha ibhokisi lokuhlola eduze kwezinketho "Sebenzisa izihlukanisi zesistimu". Ngemva kwalokho, izinkambu zokufaka izinhlamvu njengezihlukanisi ziyavulwa. Njengesihlukanisi sezingxenye eziphelele neziyingxenye, sibhala uphawu "." (ichashazi) bese ugcine izilungiselelo ngokucindezela inkinobho OK.
3. Ngeke kube nezinguquko ezibonakalayo kuthebula. Ngakho-ke, siyaqhubeka. Ukuze wenze lokhu, kopisha idatha bese uyinamathisele ku Inothi (ake sibheke isibonelo sekholomu eyodwa).
4. Ikhipha idatha kusuka I-Notepad bese ufaka emuva etafuleni Excel endaweni efanayo lapho zikopishwe khona. Ukuqondanisa kwedatha kushintshile ukusuka kwesokunxele kuye kwesokudla. Lokhu kusho ukuthi manje uhlelo lubona lawa manani njengezinombolo.
5. Buyela emuva kuzilungiselelo zohlelo (isigaba “Okwengeziwe”), lapho sibuyisela khona ibhokisi lokuhlola elibhekene nento "Sebenzisa izihlukanisi zesistimu" endaweni bese ucindezela inkinobho OK.
6. Njengoba ubona, amachashazi athathelwa indawo uhlelo ngokhefana. Ungakhohlwa ukuguqulela ifomethi yedatha "Okwezinombolo" futhi ungasebenza nabo ngokuqhubekayo.

Indlela 6: Izilungiselelo Zesistimu

Futhi ekugcineni, cabangela enye indlela efana naleyo echazwe ngenhla, kodwa ihilela ukushintsha izilungiselelo hhayi ze-Excel, kodwa zesistimu yokusebenza ye-Windows.

1. Singena Iphaneli yokulawula nganoma iyiphi indlela elula. Ngokwesibonelo, lokhu kungenziwa ngokusebenzisa Ukucingangokuthayipha igama olifunayo bese ukhetha inketho etholiwe.
2. Setha ukubuka njengezithonjana ezincane noma ezinkulu, bese uchofoza esigabeni “Amazinga Wesifunda”.
3. Iwindi lezilungiselelo zesifunda lizovela, lapho, ngokuba kuthebhu "Ifomethi" chofoza inkinobho "Izilungiselelo ezengeziwe".
4. Efasiteleni elilandelayo elinezilungiselelo zefomethi, sibona ipharamitha “I-Integer/Decimal Separator” kanye nenani elibekelwe yona. Esikhundleni sikakhefana, bhala isikhathi bese ucindezela OK.
5. Ngokufanayo nendlela yesihlanu okukhulunywe ngayo ngenhla, sikopisha idatha kusuka ku-Excel kuya Inothi futhi emuva.
6. Sibuyisela izilungiselelo zefomethi endaweni yazo yasekuqaleni. Lesi senzo sibalulekile, njengoba kungenjalo kungenzeka amaphutha ekusebenzeni kwezinye izinhlelo nezinsiza.
7. Wonke amachashazi kukholamu ebesisebenza kuwo athathelwa indawo ngokuzenzekelayo okhefana.

Isiphetho

Ngakho-ke, i-Excel inikeza izindlela ezi-5 ezihlukene, ongazisebenzisa ukufaka amachashazi ngokhefana, uma isidingo esinjalo sivela ngesikhathi somsebenzi. Ngaphezu kwalokho, ungasebenzisa enye indlela, ehlanganisa ukwenza izinguquko kuzilungiselelo zesistimu yokusebenza ye-Windows ngokwayo, lapho i-Excel ifakwe khona.