Kev lim dej yog txoj hauv kev yooj yim thiab ntseeg tau los nrhiav thiab tswj cov ntaub ntawv spreadsheet. Koj tuaj yeem lim cov ntaub ntawv siv AutoFilter feature hauv Excel 2007 kom pom tsuas yog cov ntaub ntawv uas ua tau raws cov txheej txheem tshwj xeeb. Cov ntaub ntawv lim tau tuaj yeem theej, hloov pauv, thiab luam tawm yam tsis tas yuav txav nws mus rau nplooj ntawv tshiab. Siv AutoFilter, koj tuaj yeem lim cov ntaub ntawv los ntawm kev xaiv cov txheej txheem los ntawm cov npe, los ntawm cov lej, lossis xim. Nov yog yuav siv AutoFilter feature li cas hauv Excel 2007.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Thov lim dej
Kauj Ruam 1. Qhib daim ntawv nthuav qhia uas koj xav lim cov ntaub ntawv
Kauj Ruam 2. Npaj koj cov ntaub ntawv rau Excel 2007 AutoFilter
Excel tuaj yeem lim cov ntaub ntawv hauv txhua lub xov tooj uas tau xaiv hauv ib kab, tsuav yog tsis muaj kab lossis kab nyob hauv kab uas tau xaiv tseg. Thaum ntsib kab lossis kab tsis pom kev, lim dej nres. Yog tias cov ntaub ntawv hauv thaj tsam koj xav kom lim tau cais los ntawm kab lossis kab uas tsis muaj dab tsi, tshem tawm lawv ua ntej txuas nrog AutoFilter.
- Hloov pauv, yog tias muaj cov ntaub ntawv ntawm daim ntawv ua haujlwm uas koj tsis xav ua ib feem ntawm cov ntaub ntawv lim, cais cov ntaub ntawv uas siv ib lossis ntau kab uas tsis muaj kab lossis kab tsis muaj kab. Yog tias cov ntaub ntawv koj tsis xav lim nyob hauv qab cov ntaub ntawv yuav tsum tau lim, siv tsawg kawg ib kab uas tsis muaj qhov kawg kom xaus qhov lim. Yog tias cov ntaub ntawv koj tsis xav lim yog nyob rau sab xis ntawm cov ntaub ntawv kom raug lim, siv kab uas tsis muaj dab tsi kiag li.
- Nws tseem yog qhov kev coj ua zoo kom muaj kab lus kab lus nyob hauv thaj tsam ntawm cov ntaub ntawv raug lim.
Kauj Ruam 3. Nyem rau ib lub xovtooj twg hauv thaj tsam uas koj xav lim
Kauj Ruam 4. Nyem rau "Data" tab ntawm Microsoft Excel ribbon
Kauj Ruam 5. Nyem "Lim" los ntawm "Sort & Filter" pab pawg
Cov xub poob qis yuav tshwm nyob rau sab saud ntawm txhua kab ntawv. Yog tias qhov ntau ntawm cov cell muaj kab ntawv kab lus, cov xub poob qis yuav tshwm nyob rau hauv kab ntawv.
Kauj Ruam 6. Nyem rau kab ntawv sab laug ntawm kab ntawv uas muaj cov txheej txheem xav tau los lim
Ua ib qho ntawm cov hauv qab no:
- Txhawm rau lim cov ntaub ntawv los ntawm cov txheej txheem, nyem kom tshem tawm lub pob "(Xaiv Txhua)". Tag nrho lwm lub npov yuav raug tshem tawm. Nyem rau xaiv lub npov ntawm cov txheej txheem uas koj xav kom tshwm hauv cov npe lim. Nyem "OK" txhawm rau lim qhov ntau los ntawm cov qauv xaiv.
- Txhawm rau teeb tsa tus lej lim, nyem "Tus lej lim dej" thiab tom qab ntawd nyem qhov xav tau tus neeg teb xov tooj sib piv los ntawm cov npe uas tshwm. Lub "Custom AutoFilter" dialog box tshwm. Hauv lub npov rau sab xis ntawm kev xaiv tus neeg teb xov tooj sib piv, xaiv tus lej uas xav tau los ntawm lub npov uas teev cia lossis sau tus nqi uas xav tau. Txhawm rau teeb tus lej xov tooj los ntawm ntau dua ib tus neeg teb xov tooj sib piv, nyem rau lub pob "Thiab" xov tooj cua kom qhia tias ob qho xwm txheej yuav tsum muaj tseeb, lossis nyem "lossis" khawm xov tooj cua los qhia tias tsawg kawg 1 tus qauv yuav tsum muaj tseeb. Xaiv tus neeg teb xov tooj sib piv thib ob, thiab tom qab ntawd xaiv lossis ntaus tus nqi uas xav tau hauv lub npov rau sab xis. Nyem "OK" txhawm rau siv tus lej lim rau qhov ntau.
- Txhawm rau lim cov ntaub ntawv los ntawm cov txheej txheem xim, nyem "Lim los ntawm Xim." Nyem qhov xim xav tau los ntawm "Lim los ntawm Font Xim" cov npe uas tshwm. Cov ntaub ntawv raug lim los ntawm cov xim uas tau xaiv.
Txoj Kev 2 ntawm 2: Tshem Tawm Cov Lim
Kauj Ruam 1. Nyem rau kab ntawv sab laug ntawm kab uas muaj cov lim thiab tom qab ntawd nyem "Clear Filter from Column Heading," kom tshem lim los ntawm ib kab
Kauj Ruam 2. Nyem rau "Data" tab ntawm Microsoft Excel ribbon thiab tom qab ntawd nyem "Clear" kom tshem cov lim los ntawm txhua kab
Yees duab - Los ntawm kev siv qhov kev pabcuam no, qee cov ntaub ntawv yuav raug muab qhia rau YouTube
Lub tswv yim
- Txhawm rau hloov kho cov txiaj ntsig ntawm kev lim rau cov ntaub ntawv, nyem rau "Cov Ntaub Ntawv" tab ntawm Microsoft Excel ribbon thiab tom qab ntawd nyem "Rov Thov dua."
- Thaum koj teeb tsa cov ntxaij lim dej, koj tseem tuaj yeem txheeb cov ntaub ntawv raws li xav tau. Koj tuaj yeem xaiv cov ntaub ntawv nyob hauv ascending "Sort A to Z" text order - "Sort Smallest to Largest" numerical order, descending "Sort Z to A" text order - "Sort Largest to Smallest" numerical order, or you can sort the data los ntawm xim xim
