Yuav Paub
- Xaiv xov tooj > Hometab > Sort & Filter > Filter. Tom ntej no, xaiv ib tug kab header xublos lim lossis txheeb cov ntaub ntawv.
- Tiv thaiv cov ntaub ntawv yuam kev, tsis txhob cia cov kab lossis kab nyob hauv lub rooj.
Daim ntawv Excel tuaj yeem tuav cov ntaub ntawv ntau heev; Excel muaj cov cuab yeej built-in los pab koj nrhiav cov ntaub ntawv tshwj xeeb thaum koj xav khaws nws. Nov yog yuav ua li cas los tsim, lim, thiab txheeb xyuas cov ntaub ntawv teev npe hauv Excel 2019, 2016, 2013, 2010; Excel rau Microsoft 365; Excel Online; thiab Excel rau Mac.
Create a Data List in Excel
Tom qab koj tau nkag mus rau cov ntaub ntawv kom raug rau hauv lub rooj thiab suav nrog cov headers kom raug, hloov lub rooj mus rau ib daim ntawv teev npe.
- Xaiv ib lub xovtooj ntawm lub rooj.
- Xaiv Tsev > Saib & lim > Filter.
-
Kom header xub tshwm rau sab xis ntawm txhua lub header.
Image - Thaum koj xaiv ib kab ntawv sau hauv qab, cov ntawv qhia lim yuav tshwm. Cov ntawv qhia zaub mov no muaj cov kev xaiv los txheeb cov npe los ntawm ib qho ntawm cov npe teb thiab tshawb nrhiav cov npe rau cov ntaub ntawv uas haum rau qee yam qauv.
- Qhia koj cov ntaub ntawv teev npe kom pom cov ntaub ntawv tshwj xeeb uas koj xav khaws.
Nco ntsoov tias ib lub rooj ntawm cov ntaub ntawv yuav tsum muaj tsawg kawg yog ob cov ntaub ntawv sau ua ntej ib daim ntawv teev npe.
Basic Excel Table Information
hom ntawv yooj yim rau khaws cov ntaub ntawv hauv Excel yog lub rooj. Hauv ib lub rooj, cov ntaub ntawv nkag mus rau hauv kab. Txhua kab yog hu ua cov ntaub ntawv. Thaum ib lub rooj tau tsim, siv Excel cov ntaub ntawv cov cuab yeej los tshawb nrhiav, txheeb xyuas, thiab lim cov ntaub ntawv kom pom cov ntaub ntawv tshwj xeeb.
Kawm
Thaum kab hauv lub rooj raug xa mus rau cov ntaub ntawv, cov kab ntawv hu ua teb. Txhua kem xav tau ib nqe lus los txheeb xyuas cov ntaub ntawv nws muaj. Cov npe no yog hu ua cov npe teb. Cov npe teb yog siv los xyuas kom meej tias cov ntaub ntawv rau txhua cov ntaub ntawv tau nkag mus rau tib lub sijhawm.
Nco ntsoov nkag mus rau cov ntaub ntawv hauv kem siv hom ntawv zoo ib yam. Piv txwv li, Yog hais tias tus lej raug sau ua tus lej (xws li 10 lossis 20,) khaws cia; tsis txhob hloov ib feem ntawm thiab pib sau cov lej ua cov lus (xws li "kaum" lossis "nees nkaum").
Nws tseem ceeb heev uas yuav tsum tsis txhob tso tseg tsis muaj kab nyob hauv lub rooj, thiab nco ntsoov tias lub rooj yuav tsum muaj tsawg kawg yog ob kab ua ntej ib daim ntawv teev npe.
Tiv thaiv cov ntaub ntawv yuam kev
Thaum tsim lub rooj, xyuas kom cov ntaub ntawv nkag mus kom raug. Cov ntaub ntawv yuam kev tshwm sim los ntawm cov ntaub ntawv tsis raug yog qhov muaj ntau yam teeb meem ntsig txog kev tswj cov ntaub ntawv. Yog tias cov ntaub ntawv nkag mus rau qhov raug thaum pib, koj yuav tau txais cov txiaj ntsig koj xav tau.
Txhawm rau tiv thaiv cov ntaub ntawv yuam kev, tsis txhob tso cov kab dawb paug hauv lub rooj uas raug tsim, tsis txawm nyob nruab nrab ntawm cov npe thiab thawj kab ntawm cov ntaub ntawv. Xyuas kom tseeb tias txhua cov ntaub ntawv muaj cov ntaub ntawv hais txog ib yam khoom tshwj xeeb, thiab txhua cov ntaub ntawv muaj tag nrho cov ntaub ntawv hais txog cov khoom ntawd. Tsis tuaj yeem muaj cov ntaub ntawv hais txog ib yam khoom hauv ntau tshaj ib kab.
