Ukushintsha okhefana ngamachashazi ku-Excel: izindlela ezi-5

Ukuze kuhlukaniswe izinombolo eziphelele neziyingxenye yenombolo emelelwa njengengxenye yedesimali, kusetshenziswa uhlamvu oluyisihlukanisi olukhethekile: emazweni akhuluma isiNgisi iyichashazi, kwamanye ngokuvamile ikhefana. Ngenxa yalo mehluko, abasebenzisi be-Excel bavame ukubhekana nomsebenzi wokushintsha izinhlamvu ezithile ngalezo abazidingayo. Ake sibone ukuthi ungawashintsha kanjani okhefana abe amachashazi ohlelweni.

Qaphela: uma kusetshenziswa ukhefana njengesihlukanisi, uhlelo ngeke lwamukele izinombolo ezinamachashazi njengezingxenye zedesimali, okusho ukuthi azikwazi ukusetshenziswa ekubalweni futhi. Lokhu kuyiqiniso futhi esimweni esiphambene.

Indlela yoku-1: Sebenzisa iThuluzi Lokuthola bese Ufaka esikhundleni

Le ndlela ithandwa kakhulu futhi ihlanganisa ukusetshenziswa kwethuluzi "Thola Futhi Faka Indawo":

1. Nganoma iyiphi indlela elula, sikhetha uhla lwamaseli lapho wonke amakhoma kufanele ashintshwe amachashazi. Kokufakwayo okuyinhloko kubhulokhi "Ukuhlela" chofoza isithonjana somsebenzi "Thola bese ukhetha" futhi ezinkethweni ezihlongozwayo sima kulokho okukhethayo - "Faka esikhundleni". Ungasebenzisa futhi isinqamuleli sekhibhodi ukuze uqalise leli thuluzi. Ctrl + H.Qaphela: uma ungenzi ukukhetha ngaphambi kokusebenzisa ithuluzi, khona-ke ukusesha nokushintshwa kwamakhoma ngezikhathi kuzokwenziwa kukho konke okuqukethwe eshidini, okungadingeki ngaso sonke isikhathi.
2. Iwindi elincane lomsebenzi lizovela esikrinini. “Thola Bese Ufaka Esikhundleni”. Kufanele ngokushesha sibe kuthebhu "Faka esikhundleni" (uma ngesizathu esithile lokhu kungenzeki, sishintshela kukho mathupha). Lapha sikunani lepharamitha “Thola” cacisa uphawu lukakhefana lwe “Kufakwe esikhundleni sika-” – uphawu lwamachashazi. Cindezela inkinobho uma usulungile "Faka Konke esikhundleni"ukusebenzisa ithuluzi kuwo wonke amaseli akhethiwe.Ukucindezela inkinobho efanayo "Faka esikhundleni" izokwenza ukusesha okukodwa futhi ifake esikhundleni, iqala kuseli lokuqala lobubanzi obukhethiwe, okungukuthi izodinga ukuba ichofozwe izikhathi eziningi njengoba kukhona ukumiselela ngokuya ngemingcele enikeziwe.
3. Iwindi elilandelayo lizoqukatha ulwazi mayelana nenani lokushintshwa okwenziwe.
4. Ngakho, ngaphandle komzamo omkhulu, sikwazile ukufaka amachashazi esikhundleni sikakhefana esiqeshini esikhethiwe setafula.

Indlela yesi-2: sebenzisa umsebenzi othi “Okubambele”

Ngalo msebenzi, ungasesha futhi ngokuzenzakalelayo futhi ushintshe uhlamvu olulodwa ufake olunye. Nakhu esikwenzayo:

1. Sisukuma esitokisini esingenalutho eduze kwaleli eliqukethe ukhefana (emgqeni ofanayo, kodwa hhayi kwelilandelayo). Bese uchofoza isithonjana "Faka umsebenzi" ohlangothini lwesobunxele lwebha yefomula.
2. Efasiteleni elivuliwe Ukufakwa kwesici chofoza esigabeni samanje bese ukhetha "Umbhalo" (futhi kufanelekile “Uhlu oluphelele lwama-alfabhethi”). Ohlwini oluhlongozwayo, maka u-opharetha "SUBSTITUTE", bese ucindezela OK.
3. Iwindi lizovela lapho udinga ukugcwalisa khona ama-agumenti omsebenzi:
   • "Umbhalo": Cacisa ireferensi yeseli yoqobo equkethe ukhefana. Ungakwenza lokhu mathupha ngokuthayipha ikheli usebenzisa ikhibhodi. Noma, njengoba usenkundleni yokufaka ulwazi, chofoza into oyifunayo kuthebula ngokwalo.
   • "Star_Text": lapha, njengomsebenzi “Thola Bese Ufaka Esikhundleni”, khombisa uphawu oluzoshintshwa, okungukuthi ukhefana (kodwa kulokhu kuzimpawu zokucaphuna).
   • “Umbhalo_omusha”: cacisa uphawu lwamachashazi (kuzimpawu zokucaphuna).
   • “Inombolo_yokungena” akuyona impikiswano edingekayo. Kulesi simo, shiya inkambu ingenalutho.
   • Ungashintsha phakathi kwama-agumenti omsebenzi ngokumane uchofoze ngaphakathi kwenkambu oyifunayo noma usebenzisa ukhiye Ithebhu kukhibhodi. Uma yonke into isilungile, chofoza OK.
4. Sithola idatha ecutshunguliwe kuseli nomsebenzisi. Ukuze uthole umphumela ofanayo wezinye izakhi zekholomu, sebenzisa gcwalisa umaka. Ukuze wenze lokhu, hambisa phezulu ekhoneni elingezansi kwesokudla seseli ngomsebenzi. Lapho nje isikhombi sishintsha sibe uphawu olumnyama lokuhlanganisa (lokhu kungukuthi umaka), cindezela inkinobho yegundane kwesokunxele bese uyihudulela phansi engxenyeni yokugcina yekholomu.
5. Ngokukhulula inkinobho yegundane, sizobona ngokushesha umphumela. Kusele kuphela ukuhambisa idatha entsha kuthebula, esikhundleni saleyo yokuqala ngayo. Ukuze wenze lokhu, khetha amaseli anamafomula (uma ukukhetha kususwe kungazelelwe), chofoza kwesokudla endaweni ephawuliwe bese ukhetha into kumenyu yokuqukethwe evulayo. "Kopisha".Ungasebenzisa futhi inkinobho efanayo etholakala ebhokisini lamathuluzi "Ibhodi lokunamathisela" kuthebhu eyinhloko yohlelo. Noma vele ucindezele ama-hotkeys Ctrl + C.
6. Manje sikhetha ububanzi bamaseli kuthebula ngokwalo, lapho kufanele sinamathisele khona idatha ekopishwe ebhodini lokunamathisela. Chofoza kwesokudla endaweni ekhethiwe, kumenyu evulayo "Namathisela Izinketho" khetha uphawu olunesithombe sefolda nezinombolo 123, – umyalo “Faka Amanani”.Qaphela: Esikhundleni sokukhetha ububanzi kuthebula lomthombo, ungavele uye kuseli eliphezulu kakhulu (noma iseli eliphezulu kwesokunxele, uma sikhuluma ngendawo yamakholomu nemigqa eminingi), kusukela lapho ufuna ukuya khona. namathisela idatha ekopishiwe.
7. Wonke amakholamu kukholamu athathelwa indawo ongqi. Asisayidingi ikholomu eyisizayo, futhi singayisusa. Ukuze wenze lokhu, chofoza igama layo kubha yokuxhumanisa evundlile ngenkinobho yegundane engakwesokudla futhi kumenyu yokuqukethwe evulayo, yima kumyalo. "Susa". Lapho wenza umsebenzi, udinga ukwenza isiqiniseko sokuthi ayikho idatha ebalulekile emigqeni engezansi kwale kholomu, nayo ezosuswa.Enye indlela ukusula okuqukethwe kwamaseli. Ukuze wenze lokhu, zikhethe, shayela imenyu yokuqukethwe ngokuchofoza kwesokudla kuzo bese ukhetha umyalo ofanele ohlwini oluvulayo.

Indlela yesi-3: Lungisa Izinketho ze-Excel

Ake siqhubekele endleleni elandelayo, ehlukile kuleyo okuxoxwe ngayo ngenhla ngokuthi sizokwenza izenzo hhayi endaweni yokusebenza yohlelo (eshidini), kodwa ezilungiselelweni zalo.

Kumele kuqashelwe ukuthi, lapho ufuna ukwenza khona ukushintshwa, kufanele kukhethwe njenge Izinombolo (noma General) ukuze uhlelo lubone okuqukethwe kwakho njengezinombolo futhi lusebenzise izilungiselelo ezishiwo kuzo. Ngakho-ke ake siqale:

1. Iya kumenyu "Fayela".
2. Khetha into ohlwini olungakwesokunxele "Amapharamitha".
3. Esigatshaneni “Okwengeziwe” susa ukumaka inketho "Sebenzisa izihlukanisi zesistimu" (iqembu lepharamitha "Hlela Izinketho"), ngemva kwalokho inkambu ephambene iyavulwa “I-integer ne-fraction separator”, lapho sibonisa khona isibonakaliso "khomba" bese uchofoza OK.
4. Ngakho, okhefana bazothathelwa indawo amachashazi kuwo wonke amaseli aqukethe amanani ezinombolo. Isenzo sizokwenziwa kuyo yonke incwadi yokusebenzela, hhayi kuleli shidi kuphela.

Indlela yesi-4: Sebenzisa i-Custom Macro

Le ndlela ayikwazi ukubizwa ngokuthi iyathandwa, noma kunjalo, ikhona, ngakho-ke sizoyichaza.

Okokuqala, sidinga ukwenza ukulungiselela kokuqala, okungukuthi, vumela imodi Unjiniyela (ivaliwe ngokuzenzakalelayo). Ukuze wenze lokhu, kumapharamitha wohlelo esigatshaneni “Yenza ngendlela oyifisayo i-Ribbon” engxenyeni engakwesokudla yefasitela, khetha ibhokisi eduze kwento “Unjiniyela”. Qinisekisa izinguquko ngokucindezela inkinobho OK.

Manje ake sehlele emsebenzini wethu oyinhloko:

1. Ishintshela kuthebhu evelayo “Unjiniyela” chofoza isithonjana ohlangothini lwesobunxele lweribhoni "Visual Basic" (iqembu lamathuluzi "ikhodi").
2. Iwindi lizovela esikrinini. Umhleli we-Microsoft VB. Ngakwesokunxele, chofoza kabili kunoma yiliphi ishidi noma incwadi. Enkambini evulayo, 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

3. Sikhetha amaseli kokuqukethwe ofuna ukukushintsha. Bese uchofoza isithonjana "Imakhro".
4. Ewindini elivelayo, maka i-macro yethu futhi uqinisekise ukwenziwa komyalo ngokucindezela inkinobho efanelekile. Sicela uqaphele ukuthi lesi senzo asikwazi ukuhlehliswa.
5. Ngenxa yalokho, wonke amakhoma kumaseli akhethiwe azothathelwa indawo amachashazi.

Qaphela: le ndlela isebenza kuphela uma iphuzu lisetshenziswa njengesihlukanisi sedesimali ohlelweni, okungukuthi inketho "Sebenzisa izihlukanisi zesistimu" (okuxoxwe ngenhla) kukhutshaziwe.

Indlela yesi-5: Shintsha izilungiselelo zesistimu yekhompyutha

Ake siqedele ngendlela ehlanganisa ukwenza izinguquko kuzilungiselelo zesistimu yokusebenza ngokwayo (ake sibheke isibonelo se-Windows 10).

1. Qalisa Iphaneli yokulawula (ngokwesibonelo, ngomugqa Ukucinga).
2. Kumodi yokubuka “Izithonjana ezincane/ezinkulu” chofoza ku-applet “Amazinga Wesifunda”.
3. Efasiteleni elivulekayo, sizozithola sikuthebhu "Ifomethi"lapho sicindezela khona inkinobho "Izinketho ezengeziwe".
4. Ewindini elilandelayo kuthebhu "Izinombolo" singacacisa uhlamvu lwe-delimiter esifuna ukulumisa njengolumisiwe lwesistimu kanye nohlelo lwe-Excel ikakhulukazi. Esimweni sethu, lokhu kuyiphuzu. Cindezela uma usulungile OK.
5. Ngemuva kwalokho, wonke amakhoma kumaseli wetafula aqukethe idatha yezinombolo (ngefomethi - Izinombolo or General) kuzothathelwa indawo amachashazi.

Isiphetho

Ngakho-ke, kunezindlela ezimbalwa ku-Excel ongazisebenzisa ukufaka okhefana kumaseli ethebula. Imvamisa, lokhu ukusetshenziswa kwethuluzi elithi Thola bese Ubuyisela esikhundleni, kanye nomsebenzi we-SUBSTITUTE. Ezinye izindlela ziyadingeka ezimweni ezihlukile futhi zisetshenziswa kancane kakhulu.