Inhlanganisela yezinkinobho ezishisayo iyindlela lapho kungenzeka khona ukushayela inhlanganisela ethile kwikhibhodi, lapho ungathola khona ngokushesha kwizici ezithile zesihleli se-Eksel. Kulesi sihloko, cabanga ngezindlela zokususa imigqa etafuleni lomhleli usebenzisa okhiye abashisayo.
Ukususa intambo ngekhibhodi ngezikhiye ezishisayo
Indlela yokususa esheshayo yimininingwane eminingi ukusetshenziswa kwenhlanganisela yezinkinobho ezishisayo. Ukuze ususe into ye-Line usebenzisa inhlanganisela yokhiye, udinga kuphela ukuchofoza izinkinobho ezi-2, enye yazo "Ctrl", kanye neyesibili "-".
Kufanele futhi kwaziwe ukuthi umugqa (noma izinto eziningana) zidinga ukwabiwa kusengaphambili. Umyalo uzosusa uhla olubekiwe ngokususwa. Isicelo sizonikeza ithuba lokunciphisa isikhathi esichithwa futhi silahlile izenzo ezingadingekile lapho ibhokisi lengxoxo libizwa ngalo. Kungenzeka ukusheshisa inqubo yokususa izintambo nge-hotkeys, kodwa ngale njongo uzodinga ukwenza izenzo ezi-2. Okokuqala, gcina ama-macro, bese uhlanganisa ukubulawa kwalo ngenhlanganisela ethile yezinkinobho.
Ukulondolozwa kweMacroNgokusebenzisa ikhodi yesoftware ye-macro ukususa into yomugqa, kungenzeka ukuyikhipha ngaphandle kokuhamba ngebhayisekili isikhombisi segundane. Umsebenzi uzosiza ekutholeni inani lento yomugqa lapho umaka we-isolation etholakala futhi asuse umugqa nge-offset. Ukusebenzisa isenzo, ngeke udinge ukwaba into uqobo lwayo. Ukudlulisa ikhodi enjalo kwi-PC, kufanele uyikopishe bese unamathisela ngqo kwimodyuli yephrojekthi.
2 Ukunikeza inhlanganisela yokhiye macroKungenzeka ukucacisa ama-hotkeys abo, ukuze inqubo yokususa izosheshiswa ngandlela thile, kepha ngenxa yale nhloso 2 izenzo ziyadingeka. Kuqala, udinga ukonga ama-macro encwadini, bese uhlanganisa noma iyiphi inhlanganisela yokhiye elula yokubulawa kwayo. Indlela yokususa izintambo ilungele kakhulu abasebenzisi abathuthukile bomhleli we-Eksel.
Ngaphezu kwalokho, umhleli uhlukaniswa ngezinhlamvu zencwadi ebekiwe, ngoba hhayi ukugcizelela ekwakhekeni ngesikhathi sokuqalisa iMacro, kungenzeka ukukopisha ngegama elihle kakhulu bese ukhetha inhlanganisela yokhiye ngakho usebenzisa inkinobho efanayo .
Macro ukususa izintambo ngesimo
Kukhona namathuluzi athuthukile wokuqaliswa kwenqubo ebhekwayo, okusetshenziswayo okungeke adinge ukugxila ekutholeni imigqa ezosuswa. Isibonelo, ungathatha i-macro efuna futhi ethambisa izinto ezincane eziqukethe umbhalo ochazwe ngumsebenzisi, kanye nesengezo se-Excel. Isusa imigqa ngezimo eziningi ezahlukahlukene kanye nekhono lokuzibeka ebhokisini lengxoxo.Ukugcina
Ukususa izakhi ezisezingeni eliphansi kumhleli we-Excel Kunamathuluzi ambalwa alula. Ungasebenzisa izinkinobho ezishisayo zokusebenzisa umsebenzi onjalo, futhi udale i-macro yakho ukuze ususe izinto ezisezingeni eliphansi etafuleni, into esemqoka ukuhambisana ne-algorithm yezenzo.
Umlayezo we-hotkey "Sula umugqa" etafuleni le-Excel uvele kuqala kubuchwepheshe bolwazi.