Yuav ua li cas rau Alphabetize hauv Excel

Tsi cov ntaub ntawv raws nraim li koj xav tau

Excel tus zoo huv si, ua ke zoo thiab muaj kev sib raug zoo nrog lwm qhov chaw ua haujlwm hauv MS Office ua kom nws zoo rau kev nkag thiab khaws cia cov ntawv teev npe. Thaum koj muaj tag nrho cov ntaub ntawv nkag, koj tuaj yeem txhawm rau kom tau raws li koj cov kev xav tau tsis pub ntau tshaj ob ntu ntawm nas.

Kev kawm paub yuav ua li cas thiaj li yuav alphabetize hauv Excel thiab lwm txoj kev los txhawm rau cov ntawv nyeem tau txuag tau koj cov sij hawm thiab muab kev tswj ntxiv rau cov ntaub ntawv koj yuav tsum tau siv.

Nrhiav cov kauj ruam rau txhua tus version of Microsoft Excel nrog rau 2016, 2013, 2010, 2007 thiab 2003 los yog dhau los ua ke, thiab Excel rau Mac 2016, 2011, 2008 thiab 2004. Koj tuaj yeem ua qee cov kev sau ua haujlwm siv Excel online nrog Office 365.

Yuav ua li cas los txheeb Elphabetically hauv Excel

Qhov yoojyim tshaj plaws los mus ua ib kem hauv Excel yog siv cov Kev Xaiv Fab. Qhov twg koj pom no feature yog nyob ntawm version of Excel koj siv.

Hauv Excel 2003 thiab 2002 rau Lub Tuam Txhab lossis Excel 2008 thiab 2004 rau Mac , ua raws li cov theem no.

1. Yuav tsum nco ntsoov tsis muaj hlwb dawb nyob rau hauv daim ntawv.
2. Nyem ntawm txhua lub xovtooj ntawm kem koj xav kom txheeb.
3. Xaiv cov ntaub ntawv ntawm qhov toolbar thiab xaiv Tsi . Lub Thawv Tshawb xyuas yuav qhib.
4. Xaiv lub kem koj xav kom hloov nyob rau hauv lub Thawv Xaiv, xaiv Ascending .
5. Nias OK txhawm rau xaiv lub npe alphabetically.

Nyob hauv Excel 2016, 2013, 2010 thiab 2007 rau Windows; Excel 2016 thiab 2011 rau Mac; thiab Office Excel Online, sorting yog yooj yim thiab.

1. Yuav tsum nco ntsoov tsis muaj hlwb dawb nyob rau hauv daim ntawv.
2. Tshuav Ntaus & Lim hauv Txoj Kev Kho Vaj Tse hauv tsev.
3. Xaiv A kom Z mus rau koj daim ntawv teev npe.

Tsi ua los ntawm ntau yam

Yog hais tias koj xav mus alphabetize ib thaj tsam ntawm cov hlwb hauv Excel siv ntau tshaj ib kem, Qhov Kev Txheeb feature ua rau koj ua tau li, zoo li.

Hauv Excel 2003 thiab 2002 rau Lub Tuam Txhab lossis Excel 2008 thiab 2004 rau Mac , ua raws li cov theem no.

1. Xaiv txhua lub hlwb uas koj xav hloov los ntawm kev xaiv los yog ob los sis ntau dua cov npe hauv qhov khoob.
2. Xaiv cov ntaub ntawv ntawm qhov toolbar thiab xaiv Tsi . Lub Thawv Tshawb xyuas yuav qhib.
3. Xaiv lub txheej kab ntawv uas koj xav kom hloov cov ntaub ntawv hauv qhov Tshaj Lij Xaiv thiab xaiv Ascending .
4. Xaiv ob kem ntawm qhov uas koj xav muab qhov khwv yees ntawm ntau lub hlwb hauv Daim Ntawv Teev Tom Qab. Koj tuaj yeem hloov tau mus txog rau peb kab.
5. Xaiv cov Header Loop radio khawm yog tias koj daim ntawv muaj ib lub hau rau sab saum toj.
6. Nias OK txhawm rau xaiv lub npe alphabetically.

Nyob hauv Excel 2016, 2013, 2010 thiab 2007 rau Windows los yog Excel 2016 thiab 2011 rau Mac, sorting yog yooj yim thiab. (Qhov no tsis muaj nyob rau hauv Office 365 Excel Online.)

1. Xaiv txhua lub hlwb uas koj xav hloov los ntawm kev xaiv los yog ob los sis ntau dua cov npe hauv qhov khoob.
2. Tshuav Ntaus & Lim hauv Txoj Kev Kho Vaj Tse hauv tsev.
3. Xaiv Kev Cai Tsi . Ib qho kev xaiv ntawm lub dialog yuav qhib.
4. Xaiv Kuv Cov Ntaub Ntawv Muaj Headers kos lub thawv yog tias koj lub npe muaj cov hau kev rau saum toj.
5. Xaiv lub txheej kab ntawv uas koj xav kom alphabetize cov ntaub ntawv hauv Tsi los ntawm lub thawv.
6. Xaiv cov Ntaus Xovtooj hauv qhov Tshaj Xaiv rau hauv lub thawv.
7. Xaiv A rau Z hauv lub Thawv Txiav.
8. Nias Qib Qib ntxiv rau saum lub thawv ntawv.
9. Xaiv kab thib ob uas koj xav tau cov ntawv sau cov npe hauv cov Tsab Npe Raws.
10. Xaiv cov Ntaus Xovtooj hauv qhov Tshaj Xaiv rau hauv lub thawv.
11. Xaiv A rau Z hauv lub Thawv Txiav.
12. Ndliv Ntxiv Qeb kom txheeb los ntawm lwm kem, yog xav tau. Nyem OK thaum koj npaj txhij mus alphabetize koj cov lus.

Kev Xaiv Advanced hauv Excel

Nyob rau hauv qee qhov xwm txheej, kev faib sorting yuav cia li tsis ua. Piv txwv li, koj tuaj yeem muaj daim ntawv teev npe ntev uas muaj cov npe ntawm lub hlis lossis hnub ua haujlwm hnub uas koj xav xaiv khawm. Excel yuav tackle no rau koj, thiab.

Hauv Excel 2003 thiab 2002 rau lub Xeev lossis Excel 2008 thiab 2004 rau Mac , xaiv cov npe uas koj xav xaiv.

1. Xaiv cov ntaub ntawv ntawm qhov toolbar thiab xaiv Tsi . Lub Thawv Tshawb xyuas yuav qhib.
2. Nias khawm Options rau hauv qab ntawm lub thawv ntawv sib tham.
3. Nias qhov nqes taw qhia hauv thawj daim ntawv teev npe thawj zaug thiab xaiv qhov kev xaiv xaiv uas koj xav siv.
4. Nyem OK ob zaug kom txheeb koj cov npe chronologically.

Hauv Excel 2016, 2013, 2010 lossis 2007 rau Windows thiab Excel 2016 thiab 2011 rau Mac, xaiv cov npe uas koj xav xaiv. sorting yog yooj yim thiab. (Qhov no tsis muaj nyob rau hauv Office 365 Excel Online.)

1. Tshuav Ntaus & Lim hauv Txoj Kev Kho Vaj Tse hauv tsev.
2. Xaiv Kev Cai Tsi . Lub Thawv Tshawb xyuas yuav qhib.
3. Nias qhov xub xa tuaj rau hauv Daim Ntawv Thov kev txiav txim thiab xaiv Cov Ntawv Sau Npe . Tus Npe Xaiv Cov Kev Sib Tham yuav qhib.
4. Xaiv qhov kev xaiv xaiv uas koj xav siv.
5. Nyem OK ob zaug kom txheeb koj cov npe chronologically.

Txawm Ntau Tsi Muaj Nta

Excel muab ntau txoj hauv kev los nkag, txheeb thiab ua haujlwm nrog txhua yam ntawm cov ntaub ntawv. Xyuas kom paub 6 Txoj Cai Faib Cov Ntaub Ntawv hauv Excel rau cov tswv yim thiab cov lus qhia ntxiv.