Phakathi kwemisebenzi ehlukahlukene yeMicrosoft Excel, umsebenzi we-autofilter kufanele uqokonyiswe. Kuyasiza ukuhlunga idatha engadingekile, futhi ushiye kuphela lokho okudingeka umsebenzisi okwamanje. Ake sibheke izici zomsebenzi nezilungiselelo ze-autofilter ku-Microsoft Excel.
Hlunga
Ukuze usebenze ngezilungiselelo zokuhlunga okuzenzakalelayo, okokuqala, udinga ukunika amandla isihlungi. Kunezindlela ezimbili zokwenza lokhu. Chofoza kunoma isiphi iseli etafuleni ofuna ukufaka kulo isihlungi. Ngemuva kwalokho, kuthebhu ethi "Ikhaya", chofoza inkinobho ethi "Hlunga Nokuhlunga", ebekwe kubha yamathuluzi "Ukuhlela" kubhali. Kumenyu evulayo, khetha into ethi "Hlunga".
Ukuze unike amandla isihlungi ngendlela yesibili, iya kuthebhu ethi "Idatha". Ngemuva kwalokho, njengasekuqaleni, kudingeka uchofoze kwelinye lamaseli etafuleni. Esigabeni sokugcina, kufanele uchofoze inkinobho ethi "Hlunga", etholakala kubha yamathuluzi "Hlunga Nokuhlunga" kubambo.
Uma usebenzisa noma iyiphi yalezi zindlela, umsebenzi wokuhlunga uzonikwa amandla. Lokhu kuzofakazelwa ukubonakala kwezimpawu esitokisini ngasinye setafula, ngendlela yezikwele ngemicibisholo ebhaliwe ekhomba phansi.
Kusetshenziswa isihlungi
Ukuze usebenzise isihlungi, vele uchofoze isithonjana esinjalo kukholomu inani laso ofuna ukuhlunga. Ngemuva kwalokho, imenyu ivula lapho ungatholwa khona amanani esidinga ukuwafihla.
Ngemuva kokuthi lokhu kwenziwe, chofoza inkinobho "OK".
Njengoba ukwazi ukubona, etafuleni yonke imigqa enamanani esisuka kukho esinganyathwanga siyanyamalala.
Ukusethwa Kokuhlunga Okuzenzakalelayo
Ukuze ulungiselele i-autofilter, ngenkathi usemenyu efanayo, iya entweni "Izihlungi Zombhalo" "Izihlungi zeNumeri", noma "Izihlungi ngedethi" (ngokuya ngesakhiwo samaseli wekholomu), bese ubhalwe ukuthi "Isihlungi Sokuhlunga ..." .
Ngemuva kwalokho, i-autofilter yomsebenzisi iyavula.
Njengoba ukwazi ukubona, ku-autofilter yomsebenzisi, ungahlunga idatha kwikholamu ngamanani amabili ngasikhathi sinye. Kepha, uma kusihlungi esijwayelekile ukukhethwa kwamanani kukholomu kungenziwa kuphela ngokuqeda amanani angenasidingo, khona-ke lapha ungasebenzisa i-arriers yonke yamapharamitha angeziwe. Usebenzisa i-autofilter yangokwezifiso, ungakhetha noma yimaphi amanani amabili kukholamu ezinkambeni ezihambisanayo, bese usebenzisa amapharamitha alandelayo kuzo:
- Ngokulinganayo;
- Ayilingani;
- Okuningi;
- Ngaphansi
- Okukhulu kune noma okulingana ngakho;
- Ngaphansi noma ilingane ne;
- Kuqala nge;
- Akuqali nge;
- Iyaphela;
- Akupheli;
- Kuqukethe;
- Akuqukethe.
Ngasikhathi sinye, singakhetha ukufaka amanani asheshayo wemininingwane emibili kumaseli wekholomu ngasikhathi sinye, noma okukodwa kuwo. Ukukhetha imodi kungenziwa kusethe kusetshenziswa inkinobho ethi "kanye / noma".
Isibonelo, kukholamu emayelana namaholo sizosetha i-autofilter yomsebenzisi ngokusho kwenani lokuqala "ngaphezulu kwe-10000", futhi ngokusho kwesibili "okungaphezulu noma okulingana no-12821", kufaka phakathi imodi "ne".
Ngemuva kokuthi sichofoze inkinobho ethi "kulungile", yilowo kuphela omugqa ozohlala ethebulethi ukuthi emangqamuzaneni akukholamu ethi "Inani lemholo" anenani elikhulu kuneli noma alingana no-12821, ngoba zombili lezi zinqubo kumele kuhlangatshezwane nazo.
Faka inkinobho kwimodi "noma", bese uchofoza inkinobho "Kulungile".
Njengoba ukwazi ukubona, kuleli cala, imigqa efana nomkhombandlela owodwa osunguliwe iwela emiphumeleni ebonakalayo. Yonke imigqa enenani elingaphezu kuka-10,000 izowela kuleli thebula.
Sisebenzisa isibonelo, sithole ukuthi i-autofilter iyithuluzi elilula lokukhetha idatha kusuka kulwazi olungadingekile. Kusetshenziswa i-autofilter echazwa ngumsebenzisi ngokwezifiso, ukuhlunga kungenziwa ngenani elikhudlwana lamapharamitha kunakwindlela ejwayelekile.
