Mmene Mungapangire / Chotsani Kutsika Mndandanda mu Excel

Mndandanda wotsika kapena mndandanda ukhoza kupangidwa ku Excel kuti athetse deta yomwe ingalowerere mu selo yapadera kuti ikhale yolembedweramo mndandanda wa zolembazo. Phindu logwiritsa ntchito ndondomeko yochotsera deta yolondola ndi monga:

• kupanga zovuta zosavuta;
• kupewa zolakwika zolowera;
• kuletsa chiwerengero cha malo olowa mu deta.

Mndandanda wa malo ndi Deta

Deta yomwe yawonjezedwa ku mndandanda wotsika pansi ingakhale pa:

1. tsamba lomwelo monga mndandanda.
2. pa pepala limodzi lolembedwa m'buku lomweli la Excel .
3. mu bukhu losiyana la Excel.

Zomwe Zingakuthandizeni Kupanga Pansi Mndandanda

Njira zomwe zimagwiritsidwa ntchito popanga mndandanda wotsimikiziridwa mu selo B3 (mitundu yoko) mu chithunzi pamwambapa ndi:

1. Dinani pa selo B3 kuti mupange selo yogwira ntchito ;
2. Dinani pa tabu la Data la riboni ;
3. Dinani pa Kuvomerezeka kwa Data kuti mutsegule masewera otsika pansi a zosankha;
4. Mu menyu, dinani pa Validation Data kuti mubweretse bokosi lachidziwitso cha Deta;
5. Dinani pazithunzi Zamakono mu dialog box;
6. Dinani pa Njira Yolandirira mu bokosi lakulumikiza kuti mutsegule masewera otsika-mtengo wapatali ndiwopindulitsa;
7. Mu menyu iyi, dinani List ;
8. Dinani pa Chitsime cha mzere mu bokosi la dialog;
9. Onetsetsani maselo E3 - E10 mu tsamba lothandizira kuti muwonjezere deta mu maselo ambirimbiri ku list;
10. Dinani OK kuti mutseke bokosi la bokosi ndikubweranso ku tsamba la ntchito;
11. Mtsinje wotsika uyenera kupezeka pafupi ndi selo B3 posonyeza kupezeka kwandandanda;
12. Mukasindikiza pavivi mndandanda wotsika udzatsegulidwa kuti uwonetse mayina asanu ndi atatu a cookie;

Zindikirani: Mtsinje wotsika womwe ukuwonetsa kukhalapo kwa mndandanda wotsika pansi umawonekera pamene seloyo imapangidwa selo yogwira ntchito.

Chotsani Chotsitsa Pansi Mndandanda mu Excel

Mukamaliza ndi mndandanda wazitsulo, mukhoza kuchotsedwa mosavuta pa selo lamasewera la ntchito pogwiritsa ntchito bokosi lachidziwitso la deta monga momwe taonera pa chithunzi pamwambapa.

Zindikirani : Ngati mukusintha mndandanda wa deta kapena deta yanu kumalo atsopano pa tsamba limodzi, sikufunika kufuta ndi kubwezeretsanso mndandanda wotsikirapo monga Excel idzasintha mwatsatanetsatane mndandanda wa deta yogwiritsidwa ntchito pandandanda .

Kuchotsa mndandanda wotsika pansi:

1. Dinani pa selo liri ndi mndandanda wotsika pansi kuti muchotsedwe;
2. Dinani tsambalo la Data labambo;
3. Dinani chizindikiro cha Validation Cha Data pa Riboni kuti mutsegule menyu otsika;
4. Dinani Chidziwitso cha Data pa menyu kuti mutsegule bokosi lachidziwitso cha Deta;
5. Mu bokosi la bokosi, dinani pa Tsatanetsatane tab - ngati kuli kofunikira;
6. Dinani Botani Yonse Yonse kuti muchotse mndandanda wotsika pansi monga momwe taonera pa chithunzi pamwambapa;
7. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito.

Mndandanda wamasewera omwe wasankhidwa tsopano ayenera kuchotsedwa pa selo losankhidwa, koma deta iliyonse yalowa mu selo isanayambe kuchotsedwa mndandanda idzakhalapo ndipo iyenera kuchotsedwa payekha.

Chotsani Zolemba Zonse Pansi pa Zolemba

Kuchotsa ndondomeko zonse zochotsera zomwe zili pa tsamba limodzi pa nthawi imodzi:

1. Chitani masitepe amodzi kupitilira asanu mmunsimu;
2. Onetsetsani kuti Ikani kusintha kwa maselo ena onse omwe ali ndi bokosi lofanana pa Masitimu a Zamkatimu a dialog;
3. Dinani pa Chotsani Chotsani Chotsani kuti muchotse mndandanda wa zolemba zonse zomwe zili pakali pano.
4. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito.