01 ka 01
Vimbela ukungena okungavumelekile kwedatha
Ukusebenzisa ukuqinisekiswa kwedatha ukuvimbela ukungena okungavumelekile kwedatha
Izinketho zokuqinisekiswa kwedatha ye-Excel zingasetshenziswa ukulawula uhlobo kanye nenani lwedatha elifakwe kumaseli athile kushidi lokusebenzela .
Amazinga ahlukahlukene okulawula angasetshenziswa afaka:
- ukubonisa umlayezo osheshayo lapho iseli equkethe imingcele yokuqinisekiswa kwedatha icindezelwe kodwa ngaphandle kwemingcele yedatha eseliweni ngokwalo
- ukukhawulela uhlobo nolwazi lwemininingwane engangena esitokisini
- usebenzisa ifomula esendaweni ehlukile ukucacisa ukuthi uma idatha ingena esitokisini ivumelekile
Lokhu kufundisa kuhlanganisa ukhetho lwesibili lokukhawulela uhlobo nolunye lwedatha olungangena esitokisini kwiphepha lokusebenzela le-Excel.
Ukusebenzisa umlayezo wokuzisola wephutha
Ngaphezu kokubeka imingcele yedatha engangena esitokisini, umyalezo we- Alert Alert ungaboniswa uchaza imingcele uma idatha engavumelekile ingenisiwe.
Kunezinhlobo ezintathu zesaziso sokuphutha esingaboniswa futhi uhlobo olunyuliwe luyathinta kanjani ukuthi imingcele iphoqelelwe kangakanani:
- Misa - kuvimbela ukungena kwedatha engavumelekile
- Isexwayiso - ixwayisa ukuthi idatha engavumelekile ingenwe esitokeni enezinketho zokudlula imikhawulo
- Ulwazi - luza abasebenzisi ukuthi idatha engavumelekile ingeniswe esitokisini kodwa ayivimbeli ukungena kwayo
Iphutha Lokungavumeleli Kokuxwayisa
Iphutha Izaziso zikhonjiswa kuphela uma idatha ifakwe esitokisini. Awuveli uma:
- Idatha engavumelekile ikopiwe esitokisini noma ingenwe ngokusebenzisa isibambo sokugcwalisa
- ifomula esitokisini sinquma umphumela ongavumelekile
- i- macro ingena idatha engavumelekile esitokisini
Isibonelo: Ukuvimbela ukungena okungavumelekile kwedatha
Njengoba kuboniswe esithombeni ngenhla, lesi sibonelo sizo:
- setha izinketho zokuqinisekiswa kwedatha ezivumela kuphela izinamba eziphelele ngenani elingaphansi kuka-5 ukungena esitokisini D1;
- uma idatha engavumelekile ingeniswe esitokisini, isaziso se- Stop yephutha sizoboniswa.
Ukuvula ibhokisi lokungena lokuqinisekisa idatha
Zonke izinketho zokuqinisekiswa kwedatha ku-Excel zisethwe ngokusebenzisa ibhokisi lengxoxo yokuqinisekisa idatha.
- Chofoza kuseli D1 - indawo lapho ukuqinisekiswa kwedatha kuzosetshenziswa khona
- Chofoza kuthebhu yedatha
- Khetha Ukuqinisekiswa Kwedatha kusuka kubhebhoni ukuvula uhlu lokudonsa phansi
- Chofoza ku- Validation Data kuluhlu ukuvula ibhokisi lengxoxo yokuqinisekisa idatha
Ithebhu yezilungiselelo
Lezi zinyathelo zivimbela uhlobo lwemininingwane engangena esitokisini D1 kuya ezinombolo zonke ezinenani elingaphansi kwamahlanu.
- Chofoza ku- Izilungiselelo ithebhu ebhokisini lengxoxo
- Ngaphansi kwe- Vumela: inketho khetha i- Whole Number ohlwini
- Ngaphansi kweDatha: inketho khetha okungaphansi kunalolu hlu
- Kubukhulu: uhlobo lomugqa inombolo 5
Ithebhu Alert Alert
Lezi zinyathelo zikhomba ukuthi loluhlobo lwesiphambeko sokuphazamiseka okufanele luboniswe kanye nomlayezo oqukethe.
- Chofoza kuthebhu ye- Alert Iphutha ebhokisini lengxoxo
- Qinisekisa ukuthi "Bonisa isaziso sephutha ngemuva kokuthi idatha engavumelekile efakwe" ibhokisi lihloliwe
- Ngaphansi kwesitayela: inketho khetha u- Stop ohlwini
- Esihlokweni : Uhlobo lomugqa: Inani leDatha elingavumelekile
- Emlayezo wephutha: uhlobo lomugqa: Izinamba kuphela ezinenani elingaphansi kuka-5 zivunyelwe kule seli
- Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela
Ukuhlola izilungiselelo zokuqinisekisa idatha
- Chofoza kuseli D1
- Thayipha inombolo 9 kuseli D1
- Cindezela ukhiye wokungena kwikhibhodi
- Ibhokisi lomlayezo womlayezo wesiphazamiso se- Stop kumele livele esikrinini ngoba le nombolo ingaphezu kwenani eliphakeme elibekwe ebhokisini lengxoxo
- Chofoza ku-Inkinobho yokuzama kabusha ebhokisini lomlayezo we-alert alert
- Thayipha inombolo 2 kuseli D1
- Cindezela ukhiye wokungena kwikhibhodi
- Idatha kufanele yamukelwe esitokisini ngoba ingaphansi kwenani eliphakeme elibekwe ebhokisini lengxoxo