Daga cikin ayyukan daban-daban na Microsoft Excel, dole ne a lura da aikin autofilter musamman. Yana taimaka wajen sako fitar da bayanai marasa mahimmanci, kuma ya bar abin da mai amfani yake buƙatar yanzu. Bari mu fahimci siffofin aikin da saituna autofilter a Microsoft Excel.
A kashe tace
Don aiki tare da saitunan autofilter, da farko, kana buƙatar kunna tace. Ana iya yin hakan a hanyoyi biyu. Danna kan kowane salula a cikin teburin da kake son amfani da tace. Bayan haka, kasancewa a cikin Home shafin, danna maɓallin Bincike da Filter, wanda aka samo a cikin kayan aiki mai gyare-gyare kan rubutun. A cikin menu da ya buɗe, zaɓi "Filter".
Don taimakawa tacewa a hanya ta biyu, je zuwa shafin "Data". Sa'an nan kuma, kamar yadda a cikin akwati na farko, kana buƙatar danna kan ɗaya daga cikin sel a cikin tebur. A mataki na karshe, kana buƙatar danna kan button "Filter" dake cikin "Tooling and Filter" kayan aiki akan rubutun.
Lokacin amfani da kowane daga cikin waɗannan hanyoyin, za a kunna tace. Wannan zai nuna ta bayyanar gumakan a cikin kowane tantanin halitta na launi, a cikin nau'i na murabba'ai da kiban da aka rubuta a cikinsu, yana nuna ƙasa.
Yi amfani da tace
Domin yin amfani da tace, kawai danna gunkin a cikin shafi, darajar da kake son tacewa. Bayan haka, menu yana buɗe inda za ka iya gano abubuwan da muke buƙatar ɓoyewa.
Bayan an gama wannan, danna kan maballin "Ok".
Kamar yadda kake gani, duk layuka tare da dabi'u waɗanda muka cire alamar bincike sun ɓace daga tebur.
Saiti na Autofilter
Domin saita samfurin ta atomatik, yayin da yake cikin wannan menu, je zuwa abu "Rubutun rubutun", "Rubutun zane-zane", ko "Filters ta kwanan wata" (ya dogara da tsarin tantanin halitta na shafi), sa'an nan kuma ta kalmomin "Tacewa ta customizable ..." .
Bayan haka, mai amfani autofilter ya buɗe.
Kamar yadda kake gani, a mai amfani autofilter za ka iya tace bayanai a cikin shafi a lokaci guda ta dabi'u biyu. Amma, idan a tace tace zaɓin zaɓin dabi'u a cikin wani shafi za a iya yin kawai ta hanyar kawar da dabi'u marasa mahimmanci, to, zaka iya amfani da dukan ƙarfin ƙarin sigogi. Ta amfani da al'ada autofilter, za ka iya zaɓar kowane dabi'u biyu a cikin shafi a cikin shafuka masu dacewa, da kuma amfani da wadannan sigogi masu zuwa:
- Daidaita;
- Ba daidai ba;
- Ƙari;
- Kadan
- Mafi girma ko daidai;
- Kasa ko ko daidai;
- Fara da;
- Ba fara da;
- Ƙarewa;
- Bai ƙare ba;
- Ya ƙunshi;
- Ba ya ƙunshi.
A wannan yanayin, zamu iya zaɓar yin amfani da ma'aunin bayanai biyu a cikin ɓangaren shafi a lokaci ɗaya, ko ɗaya daga cikinsu. Za'a iya saita zaɓin yanayin ta amfani da "da / ko" canji.
Alal misali, a cikin shafi na albashi, muna saita mai amfani autofilter don darajar farko "fiye da 10,000", kuma na biyu "mafi girma ko kuma daidai da 12821", tare da yanayin "kuma" ya kunna.
Bayan danna maɓallin "OK", kawai layuka waɗanda suka fi girma ko kuma daidai da 12821 a cikin sel a cikin ginshiƙan "Ƙimar Farawa" za su kasance a cikin tebur, tun da dole ne a cika waɗannan ma'auni.
Sanya sauyawa a yanayin "ko", kuma danna maballin "Ok".
Kamar yadda kake gani, a wannan yanayin, layin da ke dacewa da ɗaya daga cikin ka'idodin da aka kafa ya fada cikin sakamakon da aka gani. A cikin wannan tebur zai sami dukkan layuka, darajar adadin yawan fiye da 10,000.
Amfani da misali, mun gano cewa autofilter wani kayan aiki mai dacewa ne don zaɓar bayanai daga bayanan da basu dace ba. Tare da taimakon wani takarda na al'ada customizable, za'a iya yin gyare-gyare a kan mafi yawan lambobin sifa fiye da daidaitattun yanayin.
