Okuqukethwe
Inhlanganisela yokhiye oshisayo iyindlela ongakwazi ngayo ukuthayipha inhlanganisela ethile kukhibhodi, ongafinyelela ngayo ngokushesha izici ezithile zomhleli we-Excel. Esihlokweni, sizocubungula izindlela zokususa imigqa etafuleni lomhleli usebenzisa okhiye abashisayo.
Isusa umugqa kukhibhodi ngokhiye abashisayo
Indlela eshesha kakhulu yokususa ulayini noma eminingana ukusebenzisa inhlanganisela yokhiye abashisayo. Ukuze ususe i-elementi esemgqeni usebenzisa isinqamuleli sekhibhodi, udinga nje ukuchofoza izinkinobho ezi-2, enye yazo ingu-“Ctrl” neyesibili ithi “-“.
Kufanele futhi kuqashelwe ukuthi umugqa (noma izakhi eziningana) kufanele zikhethwe kusengaphambili. Umyalo uzosusa ububanzi obushiwo nge-offset ephezulu. Uhlelo lokusebenza luzokwenza kube nokwenzeka ukunciphisa isikhathi esichithiwe futhi wenqabe izenzo ezingadingekile ngosizo ibhokisi lengxoxo elibizwa ngalo. Kungenzeka ukusheshisa inqubo yokususa imigqa usebenzisa okhiye abashisayo, noma kunjalo, ngale njongo, uzodinga ukwenza izinyathelo ezi-2. Okokuqala, gcina i-macro, bese unikeza ukukhishwa kwayo kwinhlanganisela ethile yezinkinobho.
Ilondoloza imakhro
Ngokusebenzisa ikhodi ye-macro ukuze ususe into engaphakathi komugqa, kungenzeka ukuyisusa ngaphandle kokusebenzisa i-mouse pointer. Umsebenzi uzosiza ekunqumeni inombolo yento esemgqeni lapho umaka wokukhetha ekhona futhi ususe umugqa onokushintsha phezulu. Ukuze wenze isenzo, awudingi ukukhetha i-elementi ngokwayo ngaphambi kwenqubo. Ukudlulisa ikhodi enjalo ku-PC, kufanele uyikopishe futhi uyinamathisele ngqo kumojula yephrojekthi.
Yabela isinqamuleli sekhibhodi kumakhro
Kungenzeka ukusetha ama-hotkeys akho, ukuze inqubo yokususa imigqa izosheshisa ngandlela-thile, noma kunjalo, ngale njongo, izenzo ezi-2 ziyadingeka. Ekuqaleni, udinga ukugcina i-macro encwadini, bese ulungisa ukusebenza kwayo ngenhlanganisela yokhiye elula. Indlela ecatshangelwayo yokususa imigqa ifaneleka kakhulu kubasebenzisi abathuthuke kakhulu bomhleli we-Excel.
Kubalulekile! Kumele kuqashelwe ukuthi kuyadingeka ukukhetha okhiye abashisayo ukuze ususe imigqa ngokucophelela, ngoba inani lezinhlanganisela selivele lisetshenziswe uhlelo lokusebenza lwe-Excel ngokwalo.
Ngaphezu kwalokho, umhleli uhlukanisa izinhlamvu zohlamvu olushiwo, ngakho-ke, ukuze ungagxili ekwakhiweni ngenkathi usebenzisa i-macro, kungenzeka ukuyikopisha ngegama elihlukile bese ukhetha inhlanganisela yokhiye kuyo usebenzisa inkinobho efanayo.
Imakhro yokususa imigqa ngokwemibandela
Kukhona futhi amathuluzi athuthukile okusebenzisa inqubo okukhulunywa ngayo, ongadingi ukugxila kuyo ekutholeni imigqa ezosuswa. Isibonelo, singathatha i-macro esesha futhi isuse izici ezingaphakathi komugqa eziqukethe umbhalo oshiwo umsebenzisi, kanye nesengezo se-Excel. Isusa imigqa enezimo eziningi ezahlukene kanye nekhono lokuyisetha ebhokisini lengxoxo.
Isiphetho
Ukuze ususe izakhi ezingaphakathi komugqa kusihleli se-Excel, kunamathuluzi amaningana awusizo. Ungasebenzisa ama-hotkeys ukwenza umsebenzi onjalo, futhi udale i-macro yakho ukuze ususe izakhi ezisemgqeni etafuleni, into esemqoka ukulandela i-algorithm yezenzo ngendlela efanele.