Mwa ntchito zosiyanasiyana za Microsoft Excel, ntchito ya autofilter iyenera kuwunikiridwa. Zimathandizira kusefa deta yosafunikira, ndikusiya zokhazo zomwe wogwiritsa ntchito akufunika. Tiyeni tiwone mawonekedwe a ntchito ndi zoikamo za autofilter mu Microsoft Excel.
Sefa
Kuti mugwire ntchito ndi zoikika pa autofilter, choyambirira, muyenera kulola zosefera. Pali njira ziwiri zochitira izi. Dinani pa khungu lililonse pagome pomwe mukufuna kusefera. Kenako, pa "Home" tabu, dinani batani la "Sort and Filter", lomwe lili "Zida Zosintha" pazida. Pazosankha zomwe zimatsegulira, sankhani "Zosefera".
Kuti mupeze zosefera m'njira yachiwiri, pitani pa tabu ya "Data". Kenako, monga momwe zimakhalira poyamba, muyenera kudina imodzi mwa maselo omwe ali pagome. Pomaliza, muyenera dinani batani la "Zosefera" lomwe lili "Zida ndi Zosefera" pazida.
Mukamagwiritsa ntchito zonsezi, njira zosefera zidzatha. Izi zikuwonetsedwa ndikuwoneka kwa zithunzi m'chipinda chilichonse cha mitu ya tebulo, momwe mabwalo ali ndi mivi olembedwa akulozera pansi.
Kugwiritsa ntchito fyuluta
Kuti mugwiritse ntchito zosefera, dinani chizindikiro chonga chimenecho chomwe chili mgulu lomwe mukufuna kusefa. Pambuyo pake, menyu umatsegulidwa pomwe mutha kuzindikira zomwe tikufuna kubisa.
Mukamaliza izi, dinani batani "Chabwino".
Monga mukuwonera, patebulopo mizere yonse yokhala ndi mfundo zomwe tidadutsamo zimatha.
Makulidwe Oseketsa Magalimoto
Kuti musinthe ma autofilter, mukadali menyu omwewo, pitani pazinthu "Zosunga Zolemba" "Zosefera za Numeric", kapena "Zosefera mwa Tsiku" (kutengera mtundu wa maselo), kenako pa cholembedwa "Zosefera Mwama ..." .
Pambuyo pake, wogwiritsa ntchito payokha amatsegula.
Monga mukuwonera, mukazigwiritsa ntchito, mutha kusefa deta m'mizere ndi mfundo ziwiri nthawi imodzi. Koma, ngati mu fayilo yokhazikika kusankhidwa kwa mfundo mu kola kungapangike pokhapokha pakuchotsa zosafunikira, ndiye apa mutha kugwiritsa ntchito zida zonse zowonjezera. Pogwiritsa ntchito chizolowezi chopanga, mutha kusankha maulalo awiri m'mizere yolumikizana, ndikugwiritsa ntchito zigawo zotsatirazi:
- Mofananamo;
- Osofanana;
- Zambiri;
- Zochepa
- Chachikulu kuposa kapena chofanana;
- Zochepera kapena zofanana ndi;
- Iyamba ndi;
- Zosayamba ndi;
- Zimatha;
- Sizimatha;
- Muli;
- Mulibe.
Nthawi yomweyo, titha kusankha kuyika mfundo ziwiri za ma cell awiri nthawi imodzi, kapena chimodzi mwazomwezo. Masankhidwe amakanema akhoza kukhazikitsidwa pogwiritsa ntchito kusintha kwa "ndi / kapena".
Mwachitsanzo, pamzere wonena za malipiro tidzakhazikitsa ogwiritsa ntchito molingana ndi mtengo woyamba "kupitirira 10000", ndipo malinga ndi wachiwiri "wopitilira kapena wofanana ndi 12821", kuphatikiza mawonekedwe "ndi".
Tikadina batani la "OK", mizere yokhayo ndi yomwe ingatsalire patebulopo yomwe m'maselo omwe ali "Mulipiro wa malipiro" ali ndi phindu lalikulu kuposa kapena lofanana ndi 12821, popeza njira zonse ziyenera kukwaniritsidwa.
Ikani kusintha kwa "kapena", ndikudina "batani".
Monga mukuwonera, pankhaniyi, mizere yomwe ikugwirizana ngakhale imodzi mwazomwe zidakhazikitsidwa zimagwera pazowoneka. Mizere yonse yokhala ndi mtengo woposa 10,000 igwera patebulopo.
Pogwiritsa ntchito, tidapeza kuti autofilter ndi chida chosavuta posankha deta kuchokera kuzidziwitso zosafunikira. Kugwiritsa ntchito autofilter yofotokozedwa ndi ogwiritsa ntchito, kusefa kumatha kuchitidwa ndi ziwerengero zochulukirapo za magawo kuposa mumachitidwe wamba.
