Guhuza urufunguzo rushyushye ni amahitamo ashoboka guhamagara guhuza cyane kuri clavier, ushobora kubona uburyo bwihuse kubintu bimwe byumwanditsi wa Eksel. Mu kiganiro, suzuma uburyo bwo gusiba imirongo mumeza yubwanditsi ukoresheje urufunguzo rushyushye.
Gusiba umurongo hamwe na clavier ifite urufunguzo rushyushye
Uburyo bwihuse bwo gukuraho ni byinshi ni ugukoresha urufunguzo rushyushye. Kugirango ukureho umurongo ukoresheje urufunguzo, ugomba gusa gukanda buto 2, imwe muriyo "Ctrl", nuwa kabiri "-".
Twabibutsa kandi ko umurongo (cyangwa ibintu byinshi) bigomba gutangwa mbere. Itegeko rizakuraho urwego rwerekanwe hamwe na offset. Gusaba bizatanga amahirwe yo kugabanya igihe cyakoreshejwe no kureka ibikorwa bitari ngombwa kubiganiro bitwa. Birashoboka kwihutisha inzira yo gukuraho imirongo ikoresheje hotkeys, ariko kubwiyi ntego uzakenera gukora ibikorwa 2. Ubwa mbere, uzigame macro, hanyuma ushimangire kwicwa kwacyo muburyo bwihariye bwa buto.
Kubungabunga MacroMugukoresha kode ya Macro kugirango ukureho umurongo wibintu, birashoboka kubikuraho nta gusiganwa ku mbeba. Imikorere izafasha kumenya umubare wikintu kimwe aho umupera wigunga iherereye kandi akureho umurongo hamwe no guhagarika hejuru. Gushyira mubikorwa ibikorwa, ntuzakenera kwerekana ikintu ubwacyo. Kwimura kode nkiyi kuri PC, ugomba kuyandukura hanyuma ukande muri module ya module.
2 Kwiha urufunguzo rwa macroBirashoboka kwerekana hoteri zabo bwite, kugirango inzira yo gusiba izahita ihita, ariko kubwiyi ntego ibikorwa 2. Ku ikubitiro, ugomba gukiza macro mugitabo, hanyuma ushimangire urufunguzo rworoshye rwo kwicwa. Uburyo bwo gukuraho imirongo bukwiye cyane kubakoresha bakomeye bwa Eksel Ubwanditsi.
Byongeye kandi, umwanditsi atandukanye n'inyuguti z'urwandiko rwagenwe, kuko kudashimangira imiterere mugihe cyo gutangiza macro, birashoboka kuyigata hamwe nizina ryiza hanyuma uhitemo urufunguzo rwo gukoresha buto nkiyi .
Macro kugirango akureho imirongo kubisabwa
Hariho kandi ibikoresho byambere byo gushyira mubikorwa inzira zirimo gusuzumwa, gukoresha itazakenera kwibanda ku gusanga kugirango bakurweho. Kurugero, urashobora gufata macro ushaka kandi usiba ibintu bito kurubuga birimo inyandiko yagenwe numukoresha, hamwe no kongeraho kuba indashyikirwa. Ikuraho imirongo hamwe nibihe byinshi bitandukanye nubushobozi bwo kubashyira mubiganiro.Umwanzuro
Kugirango ukureho inyuguti nto muri extl umwanditsi hari ibikoresho byinshi. Urashobora gukoresha urufunguzo rushyushye kugirango ushyire mubikorwa ibikorwa nkibi, kimwe no kurema macro yawe kugirango ukureho ibintu bito mumeza, ikintu cyingenzi nukubahiriza algorithm yibikorwa.
Ubutumwa butkey "Gusiba umurongo" mumeza ya Excel byagaragaye mbere kugirango ubone amakuru yamakuru.