Ngatitii takagadzira fomu rekuisa mushandisi, senge iri:
Paunenge uchipinda, pane nguva dzose mukana wekupinda ruzivo rusina kururama, iyo "human factor". Imwe yesarudzo yekuratidzwa kwayo ndeyekuwedzera nzvimbo. Mumwe munhu anovaisa zvisina tsarukano, mumwe munhu nemaune, asi, chero zvazvingava, kunyange imwe nzvimbo yekuwedzera ichakupa dambudziko mune ramangwana paunenge uchigadzirisa ruzivo rwakapinda. Imwezve "runako" ndeyekuti haisati yaonekwa, kunyangwe, kana iwe uchida chaizvo, unogona kuita kuti ionekwe uchishandisa macro.
Zvechokwadi, zvinogoneka uye zvakakosha "kuvhenganisa" ruzivo mushure mekupinda mairi nerubatsiro rwemabasa anokosha kana macros. Uye iwe unogona kuratidza zvisizvo yakapinda data mukati mekuzadza fomu, nekukasira kusaina kukanganisa kumushandisi. Nokuda kweizvi:
- Simbisa nzvimbo dzekuisa paunoda kutarisa kune dzimwe nzvimbo (yero maseru mumuenzaniso wedu).
- Sarudza pa huru command tab Conditional Formatting - Gadzira Rule (Kumba - Conditional Formatting - Gadzira Rule).
- Sarudza rudzi rwemutemo Shandisa fomula kuti uone kuti ndeapi maseru ekufomatidza (Shandisa fomula kuona kuti ndeapi maseru ekufomatidza) uye isa inotevera fomula mumunda:
uko D4 ndiyo kero yesero iripo (isina "$" zviratidzo).
Mushanduro yeChirungu ichave, zvakateerana =G4<>TRIM(G4)
basa TRIM (TRIM) inobvisa dzimwe nzvimbo kubva pane zvinyorwa. Kana iyo yepakutanga yemukati yesero iripo isingaenzane ne "combed" nebasa TRIM, saka kune dzimwe nzvimbo muchitokisi. Ipapo munda wekuisa unozadzwa nemuvara unogona kusarudzwa nekudzvanya pabhatani Framework (Format).
Ikozvino, pakuzadza nzvimbo dzekuwedzera "zverunako", minda yedu yekuisa inozoratidzwa mutsvuku, ichinongedza kumushandisi kuti ari kukanganisa:
Heino hunyanzvi hwakapusa asi hwakanaka hwandakashandisa kakawanda mumapurojekiti angu. Ndinovimba iwe unozviwana zvichibatsirawo 🙂
- Kuchenesa zvinyorwa kubva munzvimbo dzekuwedzera, mavara asiri-adhinda, mavara echiLatin, nezvimwe.
- Zvishandiso zvekubvisa dzimwe nzvimbo kubva kune PLEX yekuwedzera
- Chengetedza mapepa, mabhuku ebasa uye mafaera muMicrosoft Excel