Icyo gukora niba babuze muri excel

Ubushobozi bwo gukora impapuro kugiti cye mu gitabo kimwe mu gitabo kimwe yemerera, mubyukuri, kugirango akore inyandiko nyinshi muri dosiye imwe kandi, nibiba ngombwa, ubihambire hamwe ningingo cyangwa formulaire. Birumvikana ko ibi bitezimbere imikorere ya gahunda kandi igufasha kwagura ibikorwa byimirimo. Ariko rimwe na rimwe bibaho ko amabati yo kurema acika cyangwa azimira rwose shortcuts zose mumiterere yumurongo. Reka tumenye uburyo ushobora kubisubiza inyuma.

Kugarura impapuro

Kugenda hagati yimpapuro zitanga bigufasha gukora shortcuts ziherereye kuruhande rwibumoso bwidirishya hejuru yimiterere. Ikibazo cyo gukira kwabo mugihe hazabaho.

Mbere yo gukomeza ubushakashatsi bwa Algorithm ya Recomenithm, reka tumenye impamvu bashobora muri rusange. Hariho impamvu enye zingenzi zituma bishobora kubaho:

• Hagarika itsinda rya shortcuts;
• Ibintu byari byihishe inyuma yumuzingo wa horizontal;
• Gutandukanya shortcuts byahinduwe muburyo bwihishe cyangwa superblit;
• Gukuraho.

Mubisanzwe, buri mpamvu imwe itera ikibazo gifite igisubizo cyacyo cya algorithm.

Uburyo 1: Guhindukira kuri label

Niba nta shortcuts mumiterere yimiterere muri rusange, harimo na label yibintu bifatika, ibi bivuze ko kwerekana kwabo byahagaritswe muburyo. Ibi birashobora gukorwa gusa kubitabo byubu. Ni ukuvuga, niba ufunguye indi dosiye ya Excel kuri gahunda imwe, kandi igenamiterere risanzwe ntirizahinduka, akanama gazerekana ikirango kizerekanwa. Guta uburyo ushobora gukora kongera kugaragara niba ikibaho cyazimye mumiterere.

1. Jya kuri tab "dosiye".



2. Ibikurikira, tuvuga igice "parameter".



3. Mu idirishya rya Portl rifungura, rikora inzibacyuho kuri tab "yateye imbere".



4. Kuruhande rwiburyo bwidirishya ryafunguye ibintu bitandukanye byingenzi biherereye. Tugomba kubona igenamiterere rya Igenamiterere "ryerekana ibipimo byigitabo gikurikira". Muri uku bice hari "kwerekana urupapuro rwabigenewe". Niba nta cheque yerekana ikimenyetso imbere yacyo, igomba gushyirwaho. Ibikurikira, kanda kuri buto "OK" hepfo yidirishya.



5. Nkuko mubibona, nyuma yo gukora ibyavuzwe haruguru, ikibaho cya label cyongeye kugaragara mubitabo byurutonde.

Uburyo 2: Himura umuzingo

Rimwe na rimwe, hari ibibazo iyo uyikoresha akuramo impanuka ya horizontal bar ya horizontal ar hejuru ya label panel. Rero, mubyukuri yarabahishe, nyuma, igihe iki kintu kibonetse, ikiruhuko gikomeye gitangira icyateye abakozi.

1. Gukemura iki kibazo byoroshye cyane. Shyira indanga ibumoso bwumuzingo wa horizontal. Igomba guhinduka umwambi werection. Kanda buto yimbeba yibumoso hanyuma ufata indanga iburyo kugeza ibintu byose biri kumwanya werekanwe. Hano, nabyo, ntabwo ari ngombwa kutabirenga kandi ntutume umuzingo muto cyane, kuko kandi ukenewe no kuyobora inyandiko. Kubwibyo, ugomba guhagarika gukurura umurongo ukimara gukingurwa.



2. Nkuko mubibona, akanama gagaragara kuri ecran.

Uburyo 3: Gushoboza ibirango byihishe

Kandi, impapuro kugiti cye zirashobora guhishwa. Muri icyo gihe, akanama ubwacyo hamwe nibindi bishakira kuri byo bizerekanwa. Itandukaniro mubintu byihishe kuva kure nuko niba ubishaka, urashobora guhora ugaragaza. Mubyongeyeho, niba kurupapuro rumwe hari indangagaciro zongerewe binyuze mu formula ziherereye kurundi ruhande, noneho mugihe cyo gusiba ikintu, iyi formulasiyo izatangira gukuramo ikosa. Niba ikintu cyihishe gusa, nta gihinduka mubikorwa bya formula bizabaho, ibirango gusa kugirango inzibacyuho itabura. Kuvuga n'amagambo yoroshye, ikintu kizaguma muburyo bumwe nkuko byari bimeze, ahubwo ni ibikoresho byo kugendana kugirango bihinduke bizashira.

Inzira ni yoroshye kwihisha. Ugomba gukanda iburyo kuri shortcut ihuye na hitamo "Hisha" ikintu kigaragara.

Nkuko mubibona, nyuma yibi bikorwa, ibintu byeguriwe bizaba bihishe.

Noneho reka tumenye uburyo bwo kwerekana ibirango bihishe. Ntabwo bigoye cyane kubahisha kandi byumvikana neza.

1. Kanda iburyo kuri label iyo ari yo yose. Ibikubiyemo bifungura. Niba hari ibintu byihishe mu gitabo kiriho, hanyuma muriyi meno bihinduka ikintu gikora "kwerekana ...". Kanda kuri yo hamwe na buto yimbeba yibumoso.



2. Nyuma yo gukanda, kuvumbura idirishya rito rirafungura, muri iki gitabo ari urutonde rwibitabo. Hitamo icyo kintu ushaka kongera kwerekana kumwanya. Nyuma yibyo, kanda kuri buto "OK" hepfo yidirishya.



3. Nkuko mubibona, label yikintu cyatoranijwe cyongeye kugaragara kumwanya.

Uburyo 4: Kwerekana impapuro za supercad

Usibye impapuro zihishe, haracyari byinshi. Kuva kuwambere baratandukanye nuko utazabasanga murwego rusanzwe rusohoka kuri ecran yinzoka. Nubwo twizeye ko iki kintu cyabayeho neza kandi ntamuntu wabisibye.

Ibintu birashobora gucika muri ubu buryo birashobora gusa niba umuntu yihishe nkana binyuze muri editor ya VBA Macro. Ariko kubashakisha no kugarura ibyerekanwa kumwanya ntibizagora niba umukoresha azi algorithm yibikorwa tuzavuga hepfo.

Kutubwacu, nkuko tubibona, nta bikoresho byimpapuro za kane na Gatanu.

Kujya mu idirishya risohoka kuri ecran y'ibintu byihishe, uburyo twavugaga mu buryo bwabanje, tubona ko izina ry'urupapuro rwa kane ryonyine. Kubwibyo, biragaragara rwose gutekereza ko niba urupapuro rwa gatanu rutasibwe, ruhishe gukoresha ibikoresho bya Vba.

1. Mbere ya byose, ugomba gushoboza uburyo bwa macros no gukora tab yiterambere, zihagarikwa kubisanzwe. Nubwo, iyo muri iki gitabo, ibintu bimwe byahawe imiterere ya superkead, birashoboka ko inzira zerekanwe muri gahunda zimaze gukorwa. Ariko, na none, nta cyemeza ko nyuma yo gukora impumyi yibintu, uyikoresha wabikoze, yongeye guhagarika ibikoresho nkenerwa kugirango ahindure kwerekana impapuro zidasanzwe. Byongeye kandi, birashoboka ko kwinjiza kwerekana shortcuts bikorwa na gato kuri mudasobwa bari bahishe.

   Jya kuri tab "dosiye". Ibikurikira, kanda kuri "Ibipimo" muri menu ihagaze iherereye kuruhande rwibumoso bwidirishya.



2. Muri Excel Parameter idirishya rifungura, kanda ahanditse Ribbon. Muri "tabs shingiro", iherereye kuruhande rwiburyo bwidirishya ryakinguye, rikashyiraho amatike niba atariho, hafi ya "abatezimbere". Nyuma yibyo, twimukiye mu cyiciro cyumutekano ukoresheje menu ihagaze kuruhande rwibumoso bwidirishya.



3. Mu idirishya riruka, kanda kuri buto "Ibipimo bya Centre yo gucunga umutekano ...".



4. Idirishya ryo gucunga umutekano mu idirishya ryatangijwe. Jya kuri "macro igenamiterere" ukoresheje menu ihagaze. Muri "macro igenamiterere" igikoresho, washyizeho switch kuri "ishoboze. Muri "Macro igenamigambi ryumuteza imbere" guhagarika, twashizeho amatiku yikintu "kwizerana kugera kubintu byimishinga ya VBA". Nyuma yo gukorana na macros ikora, kanda kuri buto ya "ok" hepfo yidirishya.



5. Gusubira mubipimo bya Excel kugirango impinduka zose zigenamiterere zinjiye mu ngufu, nanone kanda buto "OK". Nyuma yibi, tab yabateza imbere no gukorana na macros izakorwa.



6. Noneho, gufungura umwanditsi wa Macro, twimukira kuri tab "itezimbere", tumaze gukora. Nyuma yibyo, kuri kaseti muri "code" igikoresho, kanda ahanini "amashusho yibanze".

   

   Muhinduzi wa Macro arashobora kandi gutangizwa no kwandika clavier ya Alt + f11.

7. Uzahita ubona igitabo cya Macro, mugice cyibumoso cyacyo ni umushinga "umushinga" n "" imiterere ".

   

   Ariko birashoboka ko utu turere tutazaba mu idirishya rifungura.



8. Kugirango ushoboze kwerekana ahantu "umushinga", kanda kuri Reba Ibikubiyemo bya Horizontal. Kurutonde rufungura, hitamo umwanya "Umushinga Explorer". Cyangwa urashobora gukora guhuza urufunguzo rushyushye Ctrl + R.



9. Kugirango werekane agace ka "Umutungo", Ongera ukande kuri menu yerekana, ariko iki gihe "Idirishya ryamadirishya" ryatoranijwe murutonde. Cyangwa, nkubundi buryo, urashobora gukanda gusa urufunguzo rwa F4.



10. Niba agace kamwe karenze ikindi, nkuko byatanzwe mumashusho hepfo, noneho ugomba gushiraho indanga kumupaka wumwanya. Muri icyo gihe, bigomba guhinduka umwambi we. Noneho vuga buto yimbeba yibumoso hanyuma ukurura umupaka kugirango turere twombi rwerekanwe neza mumutwe wa Macro.



11. Nyuma yibyo, mukarere ka "umushinga", tugenera izina ryibintu bigenzurwa, ibyo tutagishoboye kubibona mumwanya cyangwa kurutonde rwibintu byihishe. Muri uru rubanza, iyi ni "urupapuro rwa 5". Muri iki kibazo, muri "imiterere", imiterere yiki kintu irerekanwa. Tuzishimira byimazeyo ikintu "kigaragara" ("kugaragara"). Kugeza ubu, imbere yacyo, "2 - XlsHeeveryryryherveryryveryryry's Hashyizweho. Byahinduwe mu kirusiya, "bihishe cyane" bisobanura "byihishe cyane", cyangwa nkuko twabigaragaje mbere "birenze". Guhindura iyi parameter hanyuma usubize kugaragara kwa label, kanda kuri mpandeshatu iburyo bwacyo.



12. Nyuma yibyo, urutonde rwimpapuro eshatu zigaragara:
    • "-1 - XlSheetvisible" (Bigaragara);
    • "0 - Xlsiath °" (yihishe);
    • "2 - XLSHEDVERYSTHEBSTHSVEDSTHSLSTHEBDSTHEBDSTSHEMBEDEND

    Kugirango umwanda ugaragare kumwanya, hitamo umwanya wa "-1 - Xlsheetvisible".



13. Ariko, uko twibuka, haracyari "urupapuro rwa 4". Nibyo, ntabwo birenze bityo birashobora gushyirwaho ukoresheje uburyo 3. Noneho nabyo bizoroha kandi byoroshye. Ariko, niba twatangiye ikiganiro kubyerekeranye no kwinjiza shortcuts binyuze mu muhinduzi wa Macro, reka turebe uko bigenda ushobora kugarura ibintu bisanzwe.

    Muri "umushinga", tugenera izina "urutonde rwa 4". Nkuko dushobora kubibona, muburyo bwa "Umutungo", imbere "ikintu" kigaragara "," 0 - Xlsethester ", ihuye nibintu bisanzwe byihishe. Kanda kuri mpandeshatu kugera ibumoso bwiyi parameter kugirango uhindure.



14. Kurutonde rwibipimo bifungura, hitamo "-1 - xlsheetvisible".



15. Tumaze gushiraho kwerekana ibintu byose byihishe kuri panel, urashobora gufunga umwanditsi wa macro. Kugirango ukore ibi, kanda kuri buto isanzwe yo gusoza nkumusaraba mugice cyo hejuru cyiburyo bwidirishya.



16. Nkuko mubibona, noneho ibirango byose byerekanwe kuri parnerl.

Isomo: Nigute ushobora Gushoboza cyangwa Guhagarika Macros muri Excel

Uburyo 5: Kugarura impapuro za kure

Ariko akenshi bibaho ko ibirango byabuze kuri panel kubera gusa uko bakuweho. Ubu ni bwo buryo bugoye. Niba mubihe byashize, hamwe na algorithm yukuri yibikorwa, amahirwe yo kugarura kwerekana shortcuts ni 100%, ntamuntu wakuweho, ntamuntu numwe ushobora gutanga ingwate yibisubizo byiza.

Kuraho ikirango cyoroshye kandi cyitota. Kanda kuri yo hamwe na buto yimbeba iburyo no muri menu igaragara ihitamo "Gusiba".

Nyuma yibyo, umuburo wo gusiba ugaragara nkikiganiro. Kurangiza inzira, birahagije gukanda kuri buto "Gusiba".

Kugarura ikintu cya kure kiragoye cyane.

1. Niba watanze ikirango, ariko bamenya ko byakozwe mubusa na mbere yo kuzigama dosiye, noneho ugomba gufunga gusa ukanda kuri buto isanzwe ifunga inyandiko muburyo bwa umusaraba wera muri kare kare.



2. Mu kiganiro agasanduku gafungura nyuma yibyo, ugomba gukanda kuri buto "Ntukize".



3. Nyuma yo kongera gufungura iyi dosiye, ikintu cya kure kizaba gihari.

Ariko hagomba kwishyurwa ko kugarura urupapuro muri ubu buryo, uzabura amakuru yose yakozwe mu nyandiko, atangirira kubungabunga. Nibyo, mubyukuri, umukoresha agomba guhitamo hagati yukuri ko kuri we ushyira imbere: ikintu cya kure cyangwa amakuru yashoboye gukora nyuma yo kubungabunga nyuma.

Ariko, nkuko bimaze kuvugwa haruguru, ubu buryo bwo gukira buzakomeza gusa niba umukoresha adafite umwanya wo kuzigama amakuru nyuma yo gusiba. Niki nakora niba umukoresha yagumanye inyandiko cyangwa muri rusange bivuye kuri yo hamwe no kubungabunga?

Niba, nyuma yo gukuraho ikirango, mumaze gukiza igitabo, ariko ntibyagize umwanya wo kubifunga, ni ukuvuga, byumvikana gucukura muri verisiyo.

1. Kujya kureba verisiyo, wimuke kuri tab "dosiye".



2. Nyuma yibyo, jya mubice bya "Ibisobanuro birambuye", bigaragazwa muri menu zihagaritse. Mu gice cyo hagati yidirishya ryakinguye idirishya riherereye. Irimo urutonde rwibintu byose byiyi dosiye yabitswe ukoresheje ibikoresho byo kubika Excel. Iki gikoresho gishoboka kubisanzwe no kubika inyandiko buri minota 10 niba utabikora wenyine. Ariko niba wakoze ibyahinduwe mu gitabo muri Igenamiterere rya Excel, uzimye ububiko bwimodoka, ntuzashobora kugarura ibintu bya kure. Igomba kandi kuvugwa ko nyuma yo gufunga dosiye, uru rutonde rwahanaguwe. Kubwibyo, ni ngombwa kubona kubura ikintu ugahitamo gukenera kugarura mbere yuko ufunga igitabo.

   Rero, kurutonde rwa verisiyo zifasha, turashaka uburyo bugezweho bwo kubungabunga, bwakozwe kugeza igihe cyo gukuraho. Kanda kuri iki kintu murutonde rwerekanwe.



3. Nyuma yibyo, idirishya rishya rizafungurwa mu idirishya rishya. Nkuko mubibona, ifite ikintu cya kure cya kure. Kugirango urangize dosiye yo kugarura, ugomba gukanda kuri buto yo kugarura hejuru yidirishya.



4. Nyuma yibyo, ikiganiro agasanduku kazakingurwa, kizahabwa kugirango usimbuze verisiyo yanyuma yakijijwe yigitabo niyi verisiyo. Niba bikwiranye, kanda kuri buto "OK".

   

   Niba ushaka gusiga verisiyo zombi za dosiye (hamwe nurupapuro rwemewe kandi hamwe namakuru yongeweho mugitabo nyuma yo gusiba), hanyuma ujye kuri tab "hanyuma ujye kuri tab" kubika nka "Kubika nka ...".



5. Tangira kubika idirishya. Muri yo, bizakenerwa guhindura izina igitabo cyagaruwe, hanyuma ukande buto "Kubika".



6. Nyuma yibyo uzakira verisiyo zombi za dosiye.

Ariko niba waratse kandi ufunze dosiye, hanyuma ukabibona, wabonye ko imwe mu bahinnye isibwe, kuko urutonde rwimyanya ya dosiye izaba isuku. Ariko urashobora kugerageza kugarura verisiyo yo kugenzura verisiyo, nubwo bishoboka ko gutsinda muri uru rubanza ari munsi ya iyo ukoresheje amahitamo yabanjirije.

1. Jya kuri tab "dosiye" no muri "Umutungo" kanda kuri buto "verisiyo yo gucunga verisiyo". Nyuma yibyo, menu ntoya iragaragara, igizwe ningingo imwe gusa - "kugarura ibitabo bidashidikanywaho". Kanda kuri.



2. Idirishya rifungura idirishya mububiko aho rihari ibitabo bitagerwaho muburyo bwa Xlsb burnary. Ubundi hitamo amazina hanyuma ukande buto "Gufungura" hepfo yidirishya. Ahari imwe muri dosiye zizaba igitabo kirimo ikintu cya kure ukeneye.

Gusa biracyashoboka kubona igitabo cyiza ni gito. Byongeye kandi, nubwo byaba ari mururu rutonde kandi bikubiyemo ibintu bya kure, birashoboka ko bizaba bishaje kandi bitarimo impinduka nyinshi zakozwe nyuma.

Isomo: Kugarura Igitabo cyabitswe Excel

Nkuko dushobora kubibona, kubura ibirango mumwanya birashobora guterwa nimpamvu nyinshi, ariko bose barashobora kugabanywa mumatsinda abiri manini: impapuro zari zihishe cyangwa zavanyweho. Mu rubanza rwa mbere, impapuro zikomeje kuguma muri iyo nyandiko, gusa kuyigeraho biragoye. Ariko niba ubishaka, mugusobanura inzira, labels yari yihishe, akurikiza algorithm yibikorwa, kugirango isubize ikarita yabo mu gitabo ntabwo bizagorana. Ikindi kintu, niba ibintu byasibwe. Muri uru rubanza, bakuwe mu nyandiko, kandi gukira kwabo ntabwo buri gihe bishoboka. Ariko, no muriki gihe, rimwe na rimwe birashoboka kugarura amakuru.