Excel yog cov cuab yeej nthuav dav siv los khaws thiab tswj cov ntawv thiab tus lej, thiab kev sau tus lej yog ib qho ntawm ntau cov txiaj ntsig ntawm kev siv Excel txij li nws tso cai rau koj kom sai sai npaj, nkag mus, thiab siv cov ntaub ntawv. Txhawm rau ua kom cov tsiaj ntawv nyob hauv Excel siv ob qhov nyem, hais txog qhov ntau ntawm cov cell thiab nyem rau ntawm "AZ sort" lossis "ZA sort" icon ntawm tus txheej txheem toolbar. Txhawm rau txheeb cov lej ntawm cov cell hauv Excel siv kev xaiv Sort advanced, qhia tag nrho cov ntawv ua haujlwm, nyem rau "Sort" los ntawm "Data" ntawv qhia zaub mov, tom qab ntawv xaiv kab ntawv thiab xaj koj xav tau los ntawm cov lus sib tham.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Tus lej hauv Ob Nyem Nyem
Kauj Ruam 1. Ntaus cov ntawv koj xav kom ua tus tsiaj ntawv rau hauv kab ntawv ntawm ib kab
Kauj Ruam 2. Qhib cov ntawv koj xav ua tus lej
Txhawm rau ua kom pom tseeb, nyem rau ntawm thawj lub xovtooj thiab rub mus rau lub cell kawg uas koj xav kom ua tus tsiaj ntawv. Koj tuaj yeem hais meej tag nrho kab ntawv los ntawm txhaj rau kab ntawv sau kab ntawv.
Kauj Ruam 3. Nrhiav qhov "AZ sort" lossis "ZA sort" icon pom ntawm tus txheej txheem cuab yeej, hauv qab Cov Ntaub Ntawv tab
Nyem rau "AZ sort" icon txhawm rau txhawm rau txhawm rau ua cov ntawv raws tus lej. Nyem rau "ZA sort" icon txhawm rau txheeb xyuas qhov nqis qis. Tam sim no koj cov xov tooj tseem ceeb yuav raug txheeb.
Yog tias koj tsis tuaj yeem nrhiav "AZ sort" icon koj tuaj yeem ntxiv tus txheej txheem txheej txheem toolbar los ntawm kev qhib "View" cov ntawv qhia zaub mov bar ces xaiv "Toolbars" thiab kos "Standard." Tam sim no tus txheej txheem txheej txheem yuav pom thiab yuav suav nrog "AZ sort" icon
Kauj Ruam 4. Tiav lawm
Txoj Kev 2 ntawm 2: Txheeb Ntawv Nrog Sort
Kauj Ruam 1. Sau daim ntawv Excel nrog koj cov ntawv
Kauj Ruam 2. Qhia tag nrho daim ntawv ua haujlwm
Txhawm rau ua qhov no siv cov yuam sij luv "Tswj + A" lossis "Command + A." Koj tseem tuaj yeem hais meej los ntawm kev nyem lub npov khoob ntawm nruab nrab ntawm kab thiab kab lus kab lus nyob rau sab saud.
Kauj Ruam 3. Qhib "Cov Ntaub Ntawv" ntawv qhia zaub mov ntawm lub cuab yeej, tom qab ntawd nyem rau "Xaiv" xaiv
Lub thawv "Sort" yuav tshwm sim. Yog tias koj tau sau cov kab ntawv, xaiv "Header row" xaiv hauv qab "Kuv cov npe muaj." Yog tias koj tsis tau sau cov kab ntawv, xaiv qhov "Tsis muaj kab ntawv header."
Kauj Ruam 4. Xaiv kab ntawv uas koj xav ua tus lej los ntawm kev xaiv nws hauv qab "เรียง los ntawm
" Yog tias koj xaiv "Header row" xaiv, cov kev xaiv hauv qab "Sort by" yuav yog koj kab lus kab lus. Yog tias koj tau xaiv "Tsis muaj kab hauv kab ntawv", cov kev xaiv yuav yog tus qauv kab ntawv kab ntawv kab taub hau.
Kauj Ruam 5. Xaiv "Ascending" txhawm rau txheeb xyuas kab ntawv xaiv hauv ascending order
Los yog xaiv "Descending" los txheeb cov kab ntawv xaiv hauv qhov kev txiav txim qis.
Kauj Ruam 6. Nyem "ok
Tam sim no koj cov cell yuav yog tus tsiaj ntawv.
