Ntawm ntau lub zog ntawm Microsoft Excel, autofilter kev ua haujlwm yuav tsum tau tshwj xeeb tshaj yog sau. Nws pabcuam tawm cov ntaub ntawv tsis tseem ceeb, thiab tawm tsuas yog cov uas tus neeg siv tam sim no xav tau. Wb to taub cov yam ntxwv ntawm kev ua hauj lwm thiab kev siv autofilter hauv Microsoft Excel.
Pab lim
Ua hauj lwm nrog cov chaw autofilter, ua ntej txhua yam, koj yuav tsum tau ua kom lub lim. Qhov no yuav ua tau nyob rau hauv ob txoj kev. Nias ntawm txhua lub xov tooj ntawm lub rooj uas koj xav thov lub lim. Tom qab ntawd, tab tom nyob hauv lub Tsev tab, nias rau qhov Tsi thiab Lim khawm, uas nyob hauv Txoj Kev Kho Dua Tshiab rau ntawm txoj kab. Hauv daim ntawv qhia tawm, xaiv "Lim".
Txhawm rau kom lub lim nyob rau hauv txoj kev thib ob, mus rau "Cov Ntaub Ntawv" tab. Tom qab ntawd, raws li nyob rau hauv thawj cov ntaub ntawv, koj yuav tsum tau nyem rau ntawm ib lub hlwb nyob rau hauv lub rooj. Ntawm theem kawg, koj yuav tsum tau nyem rau ntawm "Lim" khawm nyob rau hauv qhov "Sorting and Filter" toolbox nyob rau ntawm daim qauv.
Thaum siv ib qho ntawm cov hau kev no, yuav tsum ua kom tiav filtering. Qhov no yuav raug qhia los ntawm cov tsos ntawm cov cim hauv txhua lub xov tooj ntawm lub rooj taw qhia, hauv daim ntawv plaub fab nrog cov xib xub sau nyob rau hauv lawv, taw nqes.
Siv lim
Yuav kom siv cov lim, cia li nias ntawm lub cim hauv kem, qhov nqi uas koj xav lim. Tom qab ntawd, lub tshuab raj qhib qhov twg uas koj tuaj yeem tsis pom qhov tseem ceeb uas peb yuav tsum tau nkaum.
Tom qab qhov no tiav, nias qhov "OK" khawm.
Raws li koj tau pom, tag nrho cov kab nrib nrog qhov tseem ceeb uas peb tau tshem tawm ntawm cov cim kos ntawm lub rooj.
Autofilter teeb
Txheeb kom pib ib qho kev pib lim, thaum tseem nyob hauv tib qho zaub mov, mus rau cov khoom "Cov ntawv nyeem lim", "Numeric lim", los yog "Cov ntxaij lim dej hnub" (nyob ntawm seb lub hom xovtooj ntawm sab), thiab tom qab ntawd los ntawm cov lus "Customizable filter ..." .
Tom qab ntawd, tus neeg siv autofilter opens.
Raws li koj tau pom, nyob hauv tus neeg siv neeg autofilter koj tuaj yeem lim cov ntaub ntawv nyob rau hauv kem ib zaug los ntawm ob qhov tseem ceeb. Tab sis, yog hais tias nyob hauv ib qho kev lim cov kev xaiv ntawm qhov tseem ceeb hauv kem yuav ua tau tsuas yog los ntawm tshem qhov tsis tseem ceeb qhov tseem ceeb, ces koj tuaj yeem siv tag nrho cov arsenal ntawm kev tsis ntxiv. Siv ib qho kev cai autofilter, koj tuaj yeem xaiv ob qhov tseem ceeb hauv kem hauv cov cheeb tsam uas tsim nyog, thiab siv cov lus hauv qab no rau lawv:
- Sib npaug rau;
- Tsis sib npaug;
- Ntau ntxiv;
- Tsawg
- Ntau dua lossis sib npaug;
- Tsawg dua lossis sib npaug;
- Pib nrog;
- Tsis pib nrog;
- Ends rau;
- Tsis xaus rau;
- Muaj;
- Tsis muaj.
Hauv qhov no, peb tuaj yeem xaiv cov ntaub ntawv ob qhov tseem ceeb hauv cov hlwb ntawm ib kab tib lub sij hawm, los yog tsuas yog ib qho ntawm lawv xwb. Hom kev xaiv yuav raug teem siv cov "thiab / lossis" hloov.
Piv txwv, hauv kem ntawm cov nyiaj ua haujlwm, peb muab tus neeg siv tshuab autofilter rau thawj tus nqi "ntau dua 10,000", thiab rau tus thib ob "ntau dua los yog sib npaug rau 12821", nrog rau hom "thiab" enabled.
Tom qab txhaj rau "OK" khawm, tsuas yog cov kab uas ntau dua los yog sib npaug rau 12821 nyob rau hauv lub hlwb hauv "Cov Nyiaj Hli" nqi yuav nyob hauv lub rooj, vim hais tias ob qho tib si yuav tsum ua kom tiav.
Muab tus tes hloov qhov "lossis" hom, thiab nyem rau ntawm "OK" khawm.
Raws li koj tau pom, qhov no, cov kab uas phim txawm tias ib qho ntawm cov txheej txheem uas tsim tau poob rau hauv cov kev tshwm sim pom. Nyob rau hauv lub rooj no yuav tau txais tag nrho cov kab, qhov nqi ntawm qhov nyiaj ntau tshaj 10,000.
Siv ib qho piv txwv, peb pom tias cov autofilter yog ib lub cuab tam yooj yim rau kev xaiv cov ntaub ntawv los ntawm cov ntaub ntawv tsis tseem ceeb. Nrog kev pab los ntawm cov lim kev cai customizable, filtering tuaj yeem ua tau ntawm ntau ntau dua tsis tshaj hauv cov txheej txheem.
