Nigute wahindura koma kugeza aho mbere

Birazwi ko muri verisiyo yo mu Burusiya ya Excel, koma ikoreshwa nkumutandukanya ibimenyetso icumi, mugihe mumurongo uvuga Icyongereza. Ibi biterwa no kubaho kw'amahame atandukanye muri kariya gace. Byongeye kandi, mu bihugu bivuga icyongereza, byemewe nko gusohora gutandukanya koma, kandi dufite ingingo. Na none, bitera ikibazo mugihe umukoresha afunguye dosiye yakozwe muri gahunda hamwe nubundi buryo. Bigera aho extl ntabwo isuzuma formula, kuva abona nabi ibimenyetso. Muri iki gihe, ugomba guhindura progaramu ya gahunda mumiterere, cyangwa gusimbuza inyuguti mumyandiko. Reka tumenye uburyo bwo guhindura koma kugeza kuri iyi porogaramu.

Uburyo bwo gusimbuza

Mbere yo gukomeza gusimbuza, birakenewe mbere muri byose kubyo ubyabyara. Nibintu bimwe niba ukoresha ubu buryo gusa kuko bigaragara neza neza ingingo nkumutandukanya kandi ntugategure gukoresha iyi mibare murwego rwo kubara. Nibindi bintu rwose niba ukeneye guhindura ikimenyetso neza kubara, kuva ejo hazaza inyandiko izatunganywa muburyo bwicyongereza ya Excel.

Uburyo 1: "Shakisha kandi usimbuze" igikoresho

Inzira yoroshye yo guhindura Semicolon ni ugukoresha "gushakisha no gusimbuza". Ariko, ako kanya, twakagombye kumenya ko ubu buryo budakwiriye kubara, kubera ko ibikubiye muri selile bizahinduka muburyo bwinyandiko.

1. Dutanga uburyo bwo guhitamo akarere kurupapuro aho ukeneye guhindura koma kumanota. Kora buto yimbeba iburyo. Muri menu yo gutangira, turanga ibintu "imiterere ngenda.". Abo bakoresha bahitamo kwishimira ubundi buryo bwo gukoresha "urufunguzo rushyushye", nyuma yo gutoranya bishobora guhamagara Ctrl + 1 Urufunguzo.



2. Idirishya ryashyizwe ahagaragara. Dukora urugendo muri tab "umubare". Mu itsinda ryibipimo "imiterere yumubare", twimura imyanya ya "inyandiko". Kugirango uzigame impinduka zakozwe, kanda kuri buto "OK". Imiterere yamakuru murutonde rwatoranijwe ruzahindurwa kumyandiko.



3. Ongera utanga intego. Ibi ni umunyamuryango wingenzi, kuko utabanje kugenerwa, guhinduka bizakorwa ahantu hose h'urupapuro, kandi ibi ntabwo buri gihe ari ngombwa. Agace kagaragaye, kwimukira muri tab "urugo". Kanda kuri "Shakisha hanyuma uhitemo", uherereye muri "guhindura" ibikoresho kuri kaseti. Noneho menu ntoya ifungura, ugomba guhitamo "gusimbuza ...".



4. Nyuma yibyo, "shakisha no gusimbuza" byatangijwe mugusimbuza tab. Muri "Shakisha", twashyizeho ikimenyetso ",", no mu murima "gusimbuza" - ".". Kanda kuri "gusimbuza".



5. Idirishya ryamakuru rifungura, ritanga raporo ku guhinduka. Dukora kanda kuri buto ya "ok".

Porogaramu ikora uburyo bwo guhindura koma kugirango yerekane murwego rwabigenewe. Iki gikorwa gishobora gufatwa nkigikeshwa. Ariko hagomba kwibukwa ko amakuru yasimbuwe murubu buryo azagira imiterere yinyandiko, bityo ntibizakoreshwa mubara.

Isomo: Gusimbuza ibimenyetso muri excel

Uburyo 2: Imikorere yo gusaba

Inzira ya kabiri yerekana gushyira mubikorwa umukoresha usimbuza. Gutangira, ukoresheje iyi miterere, twe duhindura amakuru murutonde rwihariye, hanyuma tukayakigana ahantu h'umwimerere.

1. Hitamo Akagari ka Budateganye na selile yambere yamakuru aho koma igomba guhinduka mugihe. Kanda ahanditse "Shyiramo Imikorere", washyizwe ibumoso bwumugozi wa formula.



2. Nyuma yibi bikorwa, umutware ukora azatangizwa. Turimo gushakisha mucyiciro "ikizamini" cyangwa "Urutonde rwuzuye rwinyuguti" izina "umusimbura". Turabigaragaza hanyuma ukande kuri buto "OK".



3. Imikorere irafungura. Ifite impaka eshatu zerekana "inyandiko", "inyandiko ishaje" n "inyandiko nshya". Mu murima "inyandiko", ugomba kwerekana aderesi ya selile aho amakuru agomba guhinduka. Kugira ngo ukore ibi, shyira indanga muriki gice, hanyuma ukande imbeba kurupapuro kuri selile yambere yitsinda rihinduka. Ako kanya nyuma yiyi aderesi izagaragara mumadirishya yimpaka. Mu murima "inyandiko ishaje", twashizeho ikimenyetso gikurikira - ",". Mu murima "inyandiko nshya", twashyize ingingo - ".". Nyuma yamakuru yatanzwe, kanda kuri buto "OK".



4. Nkuko mubibona, kuri selile ya mbere, impinduka zigenda neza. Igikorwa nkiki kirashobora gukorerwa andi kagari kwose k'urwego rwifuzwa. Nibyiza, niba iyi nkuru ari nto. Ariko icyo gukora niba kigizwe nu selile zitandukanye? Nyuma ya byose, guhindura muburyo busa, muriki gihe, igihe kinini kizatwara. Ariko, uburyo burashobora kwihuta cyane mu gukoporora formula yasimbuwe nubufasha bwo kuzuza ikimenyetso cyuzuye.

   Dushiraho indanga iburyo bwiburyo bwa selire, ikubiyemo umurimo. Ikimenyetso cyo kuzura muburyo bwumusaraba muto. Shyira buto yimbeba yibumoso hanyuma ukurura uyu wasaruye hamwe n'akarere ukeneye guhindura komasira ya TEST kugeza aho.



5. Nkuko mubibona, ibiri mubyifuzo byintego byahinduwe mumakuru ningingo aho kuba koma. Noneho ukeneye kwigana ibisubizo no gushyiramo ahantu heza. Hitamo selile hamwe na formula. Mugihe muri tab ya mu rugo, kanda kuri buto kuri kaseti "kopi", iherereye muri "buffer". Irashobora gukorwa kandi byoroshye, aribyo nyuma yo guhitamo intera, hamagara urufunguzo rwingenzi kuri clavier Ctrl + 1.



6. Hitamo urwego rwumwimerere. Kanda kugirango ugaragaze buto yimbeba iburyo. Ibikubiyemo biragaragara. Muri yo, ukora gukanda kuri "agaciro", iherereye mumatsinda "shyiramo ibice". Iki kintu cyerekanwa nimibare "123".



7. Nyuma yibi bikorwa, indangagaciro zizinjizwa murwego rukwiye. Muri icyo gihe, komasi izahindurwa ingingo. Kugirango ukureho agace umaze gukenera, cyuzuyemo formulaire, ndabigaragaza hanyuma ukande buto yimbeba iburyo. Muri menu igaragara, hitamo "ibintu bisobanutse".

Guhindura amakuru ku guhindura koma kugeza aho byakozwe, kandi ibintu byose bitari ngombwa byavanyweho.

Isomo: Umukozi wa Wizard muri Excel

Uburyo 3: Gukoresha Macro

Uburyo bukurikira bwo guhindura koma mu ngingo bujyanye no gukoresha macros. Ariko, urubanza ni uko muri macros isanzwe muri Excele ifite ubumuga.

Mbere ya byose, macros igomba gushoboka, kimwe no gukora tab yiterambere, niba itarakora muri gahunda yawe. Nyuma yibyo, ugomba gukora ibikorwa bikurikira:

1. Twimukiye muri tab "itezimbere" hanyuma ukande kuri buto "igaragara", ishyirwa muri "code" agasanduku k'ibikoresho kuri kaseti.



2. Macros irafungura. Turakora kode ikurikira:

   Subro_trayformation___V_V_VI ()

   Guhitamo. ",", ", Gusimburwa: =". "

   Kurangiza.

   Turangije imikorere yumwanditsi hamwe nuburyo busanzwe ukanze kuri buto yo gufunga mugice cyo hejuru.



3. Ibikurikira, tugenera intera yo guhinduka. Kanda kuri buto ya "Macros", iherereye byose mumatsinda amwe ibikoresho bya Kode.



4. Idirishya rifungura urutonde rwa macros iboneka mugitabo. Hitamo imwe iherutse gukorwa ukoresheje umwanditsi. Umaze guhitamo umurongo hamwe nizina ryayo, kanda kuri buto "Koresha".

Guhinduka bikorwa. Koma izahindurwa ingingo.

Isomo: Nigute wakora macro muri excel

Uburyo 4: Excel Igenamiterere

Uburyo bukurikira ni bwo bwonyine muri ibyo hejuru, aho iyo guhindura koma ku ngingo, imvugo izabonwa na gahunda nk'umubare, kandi ntabwo ari inyandiko. Kugirango dukore ibi, tuzakenera guhindura sisitemu itandukanya muburyo bwa cumi kugeza aho.

1. Kuba muri tab "dosiye", kanda ku izina rya "Ibipimo".



2. Mu idirishya rya Parameter, twimukira mu gice cya "cyateye imbere". Turatanga gushakisha kuri "guhindura ibice" igenamiterere. Dukuraho agasanduku kegereye agaciro "koresha sisitemu itandukana". Noneho, mu gice "Gutandukanya igice cyose kandi giciranireza" Dutanga umusimbura "," kuri ".". Kwinjiza ibipimo, kanda kuri buto "OK".

Nyuma yibyavuzwe haruguru, koma, byakoreshwaga nkabitandukanya ibice, bizahindurwa ingingo. Ariko, ikintu cyingenzi, imvugo ikoreshwamo izakomeza kuba imibare, kandi ntizahindurwa inyandiko.

Hariho inzira zitari nke zo guhindura ingingo zagabanijwe mubyangombwa bya Excel. Ibyinshi muribi byo guhitamo byerekana guhindura imiterere yamakuru hamwe ninyandiko. Ibi biganisha ku kuba porogaramu idashobora kuba irimo iyi mvugo mubare. Ariko hariho nuburyo bwo guhindura koma yatangaye mumanota mugihe ukomeza imiterere yinkomoko. Kugirango ukore ibi, uzakenera guhindura igenamiterere rya porogaramu ubwayo.