Phakathi kwemisebenzi ehlukahlukene ye-Microsoft Excel, umsebenzi we-autofilter kufanele uqashe ngokukhethekile. Kuyasiza ukukhula kolwazi olungadingekile, futhi ushiye kuphela lokho umsebenzisi okwamanje adinga. Ake siyiqonde izici zomsebenzi womsebenzi nezilungiselelo ze-autofilter ku-Microsoft Excel.
Nika amandla isihlungi
Ukuze usebenze nezilungiselelo ze-autofilter, okokuqala, udinga ukunika amandla isihlungi. Lokhu kungenziwa ngezindlela ezimbili. Chofoza kunoma iyiphi iseli etafuleni ofuna ukuyisebenzisa. Khona-ke, ekubeni kuthebhu yaseKhaya, chofoza inkinobho yoHlunga nokuhlunga, esitholakala kubha yamathuluzi e-Hlela ku-Ribbon. Emenyu evula, khetha "Ihlunga".
Ukuze unike amandla isihlungi ngendlela yesibili, iya kuthebhu "YeDatha". Khona-ke, njengokuqala, kufanele uchofoze kwenye yamaseli asetafuleni. Esigabeni sokugcina, udinga ukuchofoza inkinobho ethi "Hlunga" esebhokisini lamathuluzi ethi "Ukuhlunga nokuhlunga" ebhebheni.
Uma usebenzisa noma iyiphi yalezi zindlela, ukuhlunga kuzonikwa amandla. Lokhu kuzoboniswa ukubukeka kwezithonjana esitokisini ngasinye setafula elibhekene, ngesimo sezikwele ngemicibisholo ebhalwe kuwo, ekhomba phansi.
Sebenzisa isihlungi
Ukuze usebenzise isihlungi, chofoza nje kwisithonjana kukholomu, inani ofuna ukulihlunga. Ngemuva kwalokho, imenyu ivula lapho ungahlola khona amanani esiwadingayo ukufihla.
Emva kwalokhu kwenziwa, chofoza inkinobho ethi "Kulungile".
Njengoba ubona, yonke imigqa ngamanani esasisuse kuwo amakhredithi amasheke ayanyamalala etafuleni.
Ukusetha kwe-Autofilter
Ukuze usethe ukuhlunga kwe-auto, ngenkathi kusemenyu efanayo, iya entweni "Izihlungi zombhalo", "Izihlungi zamanani", noma "Izihlungi ngosuku" (kuye ngokuthi ifomethi yeseli yekholomu), bese kuthi ngamagama "Isihlungi sokwemvelo ..." .
Emva kwalokho, i-autofilter yomsebenzisi ivula.
Njengoba ungabona, ku-autofilter yomsebenzisi ungakwazi ukuhlunga idatha kukholomu ngesikhathi esisodwa ngamanani amabili. Kodwa, uma kusihlungi esivamile ukukhethwa kwamagugu kukholomu kungenziwa kuphela ngokuqeda amanani angadingekile, bese ungasebenzisa yonke imingcele yemingcele eyengeziwe. Ukusebenzisa i-autofilter yangokwezifiso, ungakhetha noma yimaphi amanani amabili kukholomu ezindaweni ezifanele, bese usebenzise le mingcele elandelayo kubo:
- Kulingana;
- Akulingani;
- Okuningi;
- Okuncane
- Okukhulu noma elinganayo;
- Ngaphansi kokulingana noma okulingana;
- Iqala nge;
- Awuqali nge;
- Iphela;
- Akupheli;
- Iqukethe;
- Awuqukethe.
Kulokhu, singakhetha ukusebenzisa amanani amabili wedatha kumaseli ekholomu ngesikhathi esisodwa, noma eyodwa kuphela. Ukukhethwa kwendlela kungasethiwe ngokusebenzisa "futhi / noma" ukushintsha.
Isibonelo, kukholomu kumholo, sisa i-autofilter yomsebenzisi ngenani lokuqala "elikhulu kunezingu-10,000", futhi okwesibili "likhulu kunokulingana no-12821", nemodi "futhi" inikwe amandla.
Emva kokuchofoza inkinobho ethi "Kulungile", kuphela imigqa emikhulu kunaleyo noma elingana no-12821 kumaseli "Amakholomu Amanani" eyohlala etafuleni, ngoba kokubili imigomo kufanele ihlangane.
Beka inkinobho "kwimodi" noma "imodi" bese uchofoza inkinobho ethi "Kulungile".
Njengoba ungabona, kulokhu, imigqa efanisa ngisho neyodwa yezinqubo ezibekiwe iwela emiphumeleni ebonakalayo. Kulesi sithebula uzothola yonke imigqa, inani lenani elingaphezu kuka-10 000.
Sisebenzisa isibonelo, sithole ukuthi i-autofilter iyithuluzi elihle lokukhetha idatha kusuka kolwazi olungadingekile. Ngesiza sesihlungi sokwejwayela ngokwezifiso, ukuhlunga kungenziwa ngenani elikhulu kakhulu lemingcele kunemodi evamile.
