Kugwiritsa Ntchito Kuvomerezeka kwa Deta kuti Pewani Kulowa Kosavuta Kwambiri mu Excel

01 ya 01

Pewani Kulowa Kwadongosolo Kwambiri

Kugwiritsa Ntchito Kutsimikizika kwa Deta Kuti Pewani Kulowa Kopanda Deta

Zosankha za deta za Excel zingagwiritsidwe ntchito poyang'anira mtundu ndi kufunika kwa deta lolowetsedwera m'maselo ena pa tsamba .

Mipangidwe yambiri yolamulira yomwe ingagwiritsidwe ntchito ikuphatikizapo:

• kuwonetsa uthenga wouza mtima pamene maselo omwe ali ndi malamulo ovomerezeka a deta akudodometsedwa koma popanda zoletsa deta pa selo lokha
• kuletsa mtundu ndi deta zambiri zimene zingalowe mu selo
• pogwiritsa ntchito ndondomeko yomwe ili pamalo osiyana kudziwa ngati deta inalowa mu selo ndi yoyenera

Phunziroli limaphatikizapo njira yachiwiri yopezera mtundu ndi deta yomwe ingathe kulowa mu selo limodzi mu Excel sheet.

Pogwiritsa ntchito Uthenga Wozindikira Wolakwitsa

Kuphatikiza pa kuika malire pa deta yomwe ingalowerere mu selo, Uthenga Wosamvetsetsa Wosakayika ukhoza kusonyeza kufotokozera zoletsedwa pamene deta yosavomerezeka yalowa.

Pali mitundu itatu ya zolakwitsa zomwe zingathe kuwonetsedwa ndipo mtundu wosankhidwa umakhudza momwe zoletsedwazo zikutsatiridwa:

• Imani - imaletsa kulowa kwa deta yosayenera
• Chenjezo - limachenjeza kuti deta yosayenerera yalowa mu selo ndi mwayi wosokoneza zoletsedwazo
• Zambiri - zimadziwitsa ogwiritsa ntchito kuti deta yosavomerezeka yalowa mu selo koma imalepheretsa kulowa

Zosokonezeka Zowonetsera Zozindikira

Zolakwa Zochenjeza zimangowonekera kokha pamene deta ikuyimira mu selo. Iwo samawoneka ngati:

• Deta yosavomerezeka imakopilidwa mu selo kapena imalowa muzogwiritsira ntchito
• ndondomeko mu selo imatengera zotsatira zosayenera
• chilolezo chimalowa deta yosaloledwa mu selo

Chitsanzo: Kuteteza Kulowa Kwadongosolo Kwambiri

Monga momwe tawonetsera pa chithunzi pamwambapa, chitsanzo ichi:

1. sungani zosankha zokhudzana ndi deta zomwe zimalola nambala zonse zokhala ndi mtengo wosachepera 5 kulowa mu selo D1;
2. ngati deta yosavomerezeka yalowa mu selo, kuchenjeza kwachinyengo koyang'ana kudzawonetsedwa.

Kutsegula Bokosi la Mauthenga Ovomerezeka la Data

Zosankha zonse zokhudzana ndi deta mu Excel zimagwiritsidwa ntchito pogwiritsa ntchito deta yolondola.

1. Dinani pa selo D1 - malo kumene kudalitsika kwa deta kudzagwiritsidwe ntchito
2. Dinani pa tsamba la Data
3. Sankhani Kutsimikizira Kwadongosolo kuchokera paboni kuti mutsegule ndondomeko yotsika pansi
4. Dinani pa Kuvomerezeka kwa Data mundandanda kuti mutsegule bokosi lachidziwitso la deta

Makhalidwe a Tab

Zotsatirazi zikuletsa mtundu wa deta yomwe ingalowe mu selo D1 ku nambala zonse ndi mtengo wa zosachepera zisanu.

1. Dinani pa Zikhazikiko tabu mu bokosi la bokosi
2. Pansi pa Chilolezo: kusankha kusankha Nambala Yonse kuchokera pa mndandanda
3. Pansi pa Data: chosankha chisankhire chochepa kusiyana ndi mndandanda
4. Muyeso : mtundu wa mzere nambala 5

Tsatanetsatane Yowonekera Alendo

Zochitika izi zimatsimikizira kuti mtundu wa zolakwikazo zindikirani kuti ziwonetsedwe ndi uthenga womwe uli nawo.

1. Dinani pa Zolakwika Tcheru Alert mu bokosi la dialog
2. Onetsetsani kuti "Onetsani zolakwitsa zowonongeka pambuyo poti deta yosavomerezeka yalowa" bokosi liwunika
3. Pansi pazomweyi: osankha kusankha Osasiya pandandanda
4. Mutu: Mzere wa mndandanda: Invalid Data Value
5. Mu uthenga wolakwitsa: mtundu wa mndandanda: Nambala zokha zomwe zili ndi phindu la zosachepera zisanu zimaloledwa mu selo ili
6. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito

Kuyesa Mapulogalamu Ovomerezeka

1. Dinani pa selo D1
2. Lembani nambala 9 mu selo D1
3. Dinani ku key lolowamo pa khibhodi
4. Bokosi la mauthenga alangizi a Stop Stop ayenera kuwonekera pawindo chifukwa chiwerengero ichi n'choposa chiwerengero chapamwamba chomwe chili mu bokosi la bokosi
5. Dinani pa batani Retry pa bokosi lodziwitsira zolakwika
6. Lembani nambala 2 mu selo D1
7. Dinani ku key lolowamo pa khibhodi
8. Deta iyenera kuvomerezedwa mu selo popeza ili yocheperapo mtengo wapatali womwe uli mubox