Yuav Paub
- Xaiv Home > Xaiv & lim > Filter. Xaiv cov ntawv qhia header drop-down thiab xaiv Number Filters los yog Text Filters los saib cov kev xaiv lim.
- Tshem tawm lub lim: Xaiv tib lub taub hau lub xub lim thiab xaiv Clear Filter.
- Cov lim dej ua haujlwm nrog cov ntaub ntawv lossis kab ntawm cov ntaub ntawv hauv daim ntawv ua haujlwm. Cov xwm txheej koj tau muab piv nrog ib lossis ntau qhov chaw hauv cov ntaub ntawv.
Kev lim cov ntaub ntawv hauv daim ntawv nthuav qhia tso cai tsuas yog qee cov ntaub ntawv los tso saib. Txoj haujlwm no muaj txiaj ntsig zoo thaum koj xav tsom mus rau cov ntaub ntawv tshwj xeeb hauv cov ntaub ntawv loj lossis rooj. Hauv phau ntawv qhia no, peb qhia koj yuav ua li cas lim cov ntaub ntawv hauv Excel 2019, Excel 2016, Excel 2013, Excel 2010, thiab Excel rau Microsoft 365, suav nrog kev lim dej ua haujlwm thiab qee qhov kev coj ua zoo tshaj plaws.
Yuav ua li cas lim cov ntaub ntawv hauv Excel
Yog tias koj xav lim cov ntaub ntawv hauv Excel spreadsheet, ntawm no yog yuav ua li cas.
-
Qhib daim ntawv nthuav qhia uas muaj cov ntaub ntawv koj xav lim.
Image -
Yog lub Tsev tab tseem tsis tau tshwm sim, ntawm kab ntawv xaiv Home. Hauv pawg Editing, xaiv Sort & Lim > Filter.
Image -
Txhua lub taub hau hauv koj daim ntawv nthuav qhia tam sim no qhia txog tus xub nqis me me. Xaiv ib qho arrow txhawm rau lim los ntawm cov ntaub ntawv hauv kab ntawv ntawd. Lub dialog box tshwm.
Image -
Xaiv Number Filters los yog Text Filters kom pom cov kev xaiv lim koj cov ntaub ntawv.
Image -
Ua piv txwv los ntawm saum toj no, raws li tus thawj tswj hwm muag koj xav xaiv cov neeg muag khoom uas nws Q4 cov nyiaj tau los ntau dua $ 19, 500. Los ntawm cov ntawv qhia zaub mov xaiv, xaiv Ntau dua.
Image -
In the Custom AutoFilter dialog box, nyob rau hauv lub Greater than teb, ntaus 19, 500. Xaiv OK.
Image -
Excel qhia tsuas yog cov ntaub ntawv uas nws Q4 tus nqi ntau dua $ 19, 500.
Daim ntawv ceeb toom nyob rau hauv kab lej mus rau sab laug sab laug muaj ob kab ntawm kab xov tooj yog cov kab ntawm cov ntaub ntawv tsis tshwm sim ntawm cov kab ntawd. Tsis tas li, pom tias tus xub nqes hauv Q4 header tam sim no qhia lub cim lim kom pom cov ntaub ntawv raug lim raws li cov ntaub ntawv hauv kab ntawv.
Image - Yog tias koj xav lim cov ntaub ntawv sib txawv, rov qab mus rau qib 5 thiab xaiv cov kev xaiv sib txawv ntawm cov ntawv qhia zaub mov. Tom qab ntawd, ua raws li qhov screen qhia kom lim koj cov ntaub ntawv raws li koj xav tau.
-
Yuav kom tshem tawm cov lim, xaiv tib lub xub lim thiab xaiv Clear Filter.
Image
Kev lim dej ua haujlwm li cas
Zoo tshaj plaws rau kev lim
Txuag koj tus kheej ib co hassle los ntawm kev ua raws li cov lus qhia zoo tshaj plaws rau kev ua haujlwm nrog cov ntaub ntawv lim:
- Tshwj tsis yog muaj laj thawj zoo rau nws, tsis txhob khaws cov ntawv sib koom nrog cov lim dej ua haujlwm. Lwm tus neeg siv yuav tsis pom tias cov ntaub ntawv raug lim.
- Txawm hais tias koj tuaj yeem lim ntawm ob peb kab ib txhij, cov lim dej no yog cov khoom ntxiv, tsis yog tshwj xeeb. Hauv lwm lo lus, lim cov npe hu los qhia txhua tus neeg hauv Xeev California uas laus dua 60 xyoo yuav ua rau txhua tus neeg muaj hnub nyoog tshaj 60 xyoo hauv California. Cov lim dej zoo li no yuav tsis pom koj tag nrho cov hnub nyoog 60 xyoo lossis tag nrho cov neeg California hauv koj daim ntawv teev npe.
- Cov ntawv lim tsuas ua haujlwm raws li cov ntaub ntawv hauv qab tso cai. Cov ntaub ntawv tsis sib xws ua rau muaj kev nkag siab yuam kev lossis tsis raug lim cov txiaj ntsig. Piv txwv li, kev lim dej rau cov neeg nyob hauv Illinois yuav tsis ntes cov ntaub ntawv rau cov neeg nyob hauv "IL" lossis sau tsis raug "Ilinois."
Siv ceev faj thaum xaiv cov ntaub ntawv lim. Kev txheeb xyuas cov ntaub ntawv ib nrab tuaj yeem ua rau rov tsim kho cov ntaub ntawv cov ntaub ntawv, uas tuaj yeem ua rau muaj teeb meem ntxiv. Yog tias koj yuav tsum txheeb cov ntaub ntawv lim dej, luam cov ntaub ntawv lim dej mus rau daim ntawv ua haujlwm tshiab thiab tom qab ntawd txheeb nws.
