Ake sithi sidale ifomu lokufaka komsebenzisi, njengaleli:
Lapho kungena, kuhlale kunethuba lokufakwa kolwazi olungalungile, “isici somuntu”. Enye yezinketho zokubonakaliswa kwayo izikhala ezengeziwe. Othile uwabeka ngokungahleliwe, othile ngenhloso, kodwa, kunoma yikuphi, ngisho nesikhala esisodwa esingeziwe sizokwethula inkinga esikhathini esizayo lapho sicubungula ulwazi olufakiwe. "I-charm" eyengeziwe ukuthi azikabonakali, nakuba, uma ufuna ngempela, ungazenza zibonakale usebenzisa i-macro.
Yiqiniso, kungenzeka futhi kudingekile "ukuhlanganisa" ulwazi ngemuva kokulufaka ngosizo lwemisebenzi ekhethekile noma ama-macros. Futhi ungagqamisa idatha efakwe ngokungalungile ngesikhathi sokugcwalisa ifomu, ubonise iphutha kumsebenzisi. Kwalokhu:
- Gqamisa izinkambu zokufaka lapho udinga ukuhlola izikhala ezengeziwe (amaseli aphuzi esibonelweni sethu).
- Khetha The main ithebhu yomyalo Ukufometha Okunemibandela - Dala Umthetho (Ikhaya - Ukufometha Okunemibandela - Dala Umthetho).
- Khetha uhlobo lomthetho Sebenzisa ifomula ukuze unqume ukuthi yimaphi amaseli ozofometha (Sebenzisa ifomula ukuze unqume ukuthi yimaphi amaseli ozofometha) bese ufaka ifomula elandelayo ensimini:
lapho i-D4 iyikheli leseli yamanje (ngaphandle kwezimpawu ezithi “$”).
Enguqulweni yesiNgisi kuzoba, ngokulandelana =G4<>TRIM(G4)
Umsebenzi I-TRIM (TRIM) ikhipha izikhala ezengeziwe embhalweni. Uma okuqukethwe kwasekuqaleni kweseli yamanje kungalingani "nokukanywa" nomsebenzi I-TRIM, ngakho-ke kunezikhala ezengeziwe kuseli. Khona-ke inkambu yokufaka igcwaliswa ngombala ongakhethwa ngokuchofoza inkinobho Framework (Ifomethi).
Manje, lapho sigcwalisa izikhala ezingeziwe “zobuhle”, izinkambu zethu zokufaka zizogqanyiswa ngokubomvu, ziqondise kumsebenzisi ukuthi unephutha:
Nali iqhinga elilula kodwa elihle engisebenzise izikhathi eziningi kumaphrojekthi ami. Ngethemba ukuthi nawe ukuthole kuwusizo 🙂
- Ukuhlanza umbhalo kusuka ezikhaleni ezengeziwe, izinhlamvu ezingaphrintiwe, izinhlamvu zesiLatini, njll.
- Amathuluzi okukhipha izikhala ezengeziwe kusengezo se-PLEX
- Vikela amashidi, izincwadi zokusebenza namafayela ku-Microsoft Excel