Birazwi ko muburyo busanzwe, imitwe yinkingi muri gahunda ya Excel isobanurwa ninyuguti z'inyuguti z'ikilatini. Ariko, mugihe kimwe, umukoresha arashobora kumenya ko noneho inkingi zerekanwa nimibare. Ibi birashobora kubaho kubwimpamvu nyinshi: Ubwoko butandukanye bwa gahunda, ibikorwa bitabishaka, guhinduranya nkana bigaragazwa nundi mukoresha, nibindi Ariko, ibyo bitera ntabwo byari bimeze, mugihe ibintu bisa bibaye, ikibazo cyo gusubiza kwerekana amazina yinkingi kuri leta isanzwe iba ingirakamaro. Reka tumenye uburyo bwo guhindura imibare mumabaruwa muri Excel.
Yerekana Guhindura Amahitamo
Hariho uburyo bubiri bwo kuzana akanama gahuza ibitekerezo bisanzwe. Imwe murimwe ikorwa binyuze mu ntera ya exel, naho iya kabiri yerekana itegeko ritegeka gukurikiza amasezerano akoresha kode. Reba mubisobanuro birambuye kuburyo byombi.
Uburyo 1: Ukoresheje Imigaragarire ya Porogaramu
Inzira yoroshye yo guhindura kwerekana amazina yinkingi ifite imibare kumabaruwa ni ugukoresha ibikoresho bitaziguye bya gahunda.
- Dukora inzibacyuho kuri tab "dosiye".
- Twimukiye muri "Parameter".
- Muri gahunda y'ibipimo bya gahunda bifungura, jya kuri "formula".
- Nyuma yo guhinduranya igice cyo hagati yidirishya, dusanga "akazi hamwe na formulaire" igenamiterere. Ibyerekeye R1C1 Ihuza Imiterere ya Style ikuraho amatiku. Kanda kuri buto ya "OK" hepfo yidirishya.
Noneho izina ry'inkingi kuri Panel ihuriweho rizadusahura buri gihe, ni ukuvuga, rizarangwa n'inzandiko.
Uburyo 2: Gukoresha Macro
Imyitozo ya kabiri nkigisubizo cyikibazo kirimo gukoresha macro.
- Koresha uburyo bwateguwe kuri kaseti, niba bigaragaye ko bimugaye. Gukora ibi, jya kuri tab "dosiye". Ibikurikira, twongeyeho kuri "ibipimo".
- Mu idirishya rifungura, hitamo ikintu cya Ribbon. Kuruhande rwiburyo bwidirishya, twashizeho ikintu hafi ya "Iterambere". Kanda kuri buto ya "OK". Rero, uburyo bwiterambere burakora.
- Jya kuri tab yiterambere. Twahagaritse kuri buto "Visual Sect", iherereye kuruhande rwibumoso bwa kaseti muri "code" igenamiterere. Ntushobora gutanga ibi bikorwa kuri kaseti, ariko uhamagare gusa urufunguzo rwa clavier kuri chr + f11 clavier.
- Umuyobozi wa Vba aratanga. Kanda kuri clavier ihuza Ctrl + g urufunguzo. Mu idirishya rifungura, andika kode:
Porogaramu.Ibisobanuro byatoranijwe = xla1
Kanda kuri buto ya Enter.
Nyuma yibi bikorwa, hagaragaza inyuguti yizina ryinkingi izagaruka, ihindura imibare.
Nkuko mubibona, impinduka zitunguranye zizina ryinkingi zihuza inyuguti yandikiye umukoresha impera yumukoresha. Ibintu byose biroroshye cyane gusubira mubihugu byabanjirije ukoresheje ibipimo bya Excel. Ihitamo ukoresheje Macro isobanura gusaba gusa niba kubwimpamvu udashobora gukoresha inzira isanzwe. Kurugero, kubera kunanirwa. Birumvikana, urashobora gukoresha ubu buryo hagamijwe kugerageza kugirango urebe gusa uburyo ubwoko bwimirimo ikora mubikorwa.