Yuav ua li cas txheeb cov npe hauv Microsoft Excel: 15 Kauj Ruam (nrog Duab)

Cov txheej txheem:

Yuav ua li cas txheeb cov npe hauv Microsoft Excel: 15 Kauj Ruam (nrog Duab)
Yuav ua li cas txheeb cov npe hauv Microsoft Excel: 15 Kauj Ruam (nrog Duab)

Video: Yuav ua li cas txheeb cov npe hauv Microsoft Excel: 15 Kauj Ruam (nrog Duab)

Video: Yuav ua li cas txheeb cov npe hauv Microsoft Excel: 15 Kauj Ruam (nrog Duab)
Video: txoj kev nyuab siab. By. Nkaujhnub yaj 2024, Plaub Hlis Ntuj
Anonim

Excel zoo rau cov lus ntawm cov ntaub ntawv, tab sis koj tuaj yeem tswj hwm thiab teeb tsa nws li cas kom ua tau raws li qhov koj xav tau? Cov cuab yeej xaiv tso cai rau koj los txheeb cov kab ntawv sai los ntawm ntau yam qauv, lossis tsim koj tus kheej kev cai cais rau ntau kab thiab hom ntaub ntawv. Siv Sort muaj nuj nqi los txheeb xyuas koj cov ntaub ntawv thiab ua kom nkag siab thiab siv tau yooj yim.

Cov kauj ruam

Ntu 1 ntawm 3: Txheeb cais tus lej lossis Tus lej

Sort a List in Microsoft Excel Kauj Ruam 1
Sort a List in Microsoft Excel Kauj Ruam 1

Kauj Ruam 1. Xaiv koj cov ntaub ntawv

Koj tuaj yeem nyem thiab rub kom xaiv kab ntawv uas koj xav txheeb, lossis koj tuaj yeem nyem ib qho ntawm cov cell hauv kab ntawv kom nws ua haujlwm thiab cia Excel xaiv cov ntaub ntawv cia.

Txhua yam ntawm koj cov ntaub ntawv hauv kab ntawv yuav tsum tau muab ua ib yam nkaus los txhawm rau txheeb (piv txwv li ntawv, lej, hnub tim)

Sort a List in Microsoft Excel Kauj Ruam 2
Sort a List in Microsoft Excel Kauj Ruam 2

Kauj Ruam 2. Nrhiav Sort nyees khawm

Cov no tuaj yeem pom hauv Cov Ntaub Ntawv tab hauv ntu "Sort & Filter". Txhawm rau ua kom nrawm, koj yuav siv cov "AZ ↓" thiab "AZ ↑" cov nyees khawm.

Sort a List in Microsoft Excel Kauj Ruam 3
Sort a List in Microsoft Excel Kauj Ruam 3

Kauj Ruam 3. Txheeb koj kab ntawv los ntawm nias lub pob tsim nyog

Yog tias koj tau txheeb cov lej, koj tuaj yeem txheeb los ntawm qis tshaj rau siab tshaj ("AZ ↓") lossis siab tshaj plaws mus rau qis tshaj ("AZ ↑"). Yog tias koj tab tom txheeb cov ntawv, koj tuaj yeem txheeb qhov kev txiav txim siab tus lej lej ("AZ ↓") lossis xaj kom tus lej lej qis ("AZ ↑"). Yog tias koj tab tom xaiv cov hnub lossis sijhawm, koj tuaj yeem txheeb xyuas txij thaum ntxov mus rau tom qab ("AZ ↓") lossis tom qab mus rau ntxov dua ("AZ ↑").

Yog tias muaj lwm kab ntawv ntawm cov ntaub ntawv nyob ib sab ntawm ib qho uas koj tau txheeb, koj yuav raug nug yog tias koj xav suav nrog cov ntaub ntawv ntawd hauv cov khoom. Qhov kev xaiv tseem yuav yog kab uas koj xaiv thaum xub thawj, tab sis cov kab ntawv sib txuam ntawm cov ntaub ntawv yuav raug txheeb nrog nws

Sort a List in Microsoft Excel Kauj Ruam 4
Sort a List in Microsoft Excel Kauj Ruam 4

Kauj Ruam 4. Troubleshoot ib kem uas yuav tsis txheeb

Yog tias koj tab tom ua yuam kev thaum koj sim txheeb, feem ntau qhov ua phem yog teeb meem teeb meem nrog cov ntaub ntawv.

  • Yog tias koj tab tom txheeb cov lej, nco ntsoov tias txhua lub cell tau ua cov ntawv zoo li tus lej thiab tsis yog cov ntawv. Cov lej tuaj yeem raug yuam ua txawv tebchaws raws li cov ntawv los ntawm qee qhov kev pabcuam nyiaj txiag.
  • Yog tias koj tau txheeb cov ntawv, qhov ua yuam kev tuaj yeem tshwm sim los ntawm qhov chaw ua haujlwm lossis cov ntawv tsis zoo.
  • Yog tias koj tau txheeb cov hnub lossis sijhawm, cov teeb meem feem ntau yog los ntawm kev teeb tsa koj cov ntaub ntawv. Txhawm rau kom Excel txheeb ua tiav los ntawm hnub tim, koj yuav tsum xyuas kom meej tias txhua cov ntaub ntawv raug khaws cia ua hnub tim.

Ntu 2 ntawm 3: Sorting with Multiple Criteria

Sort a List in Microsoft Excel Kauj Ruam 5
Sort a List in Microsoft Excel Kauj Ruam 5

Kauj Ruam 1. Xaiv koj cov ntaub ntawv

Cia peb hais tias koj muaj daim ntawv teev npe nrog cov npe cov neeg siv khoom nrog rau lub nroog uas lawv nyob hauv. Ua kom koj lub neej yooj yim dua, koj xav txheeb thawj cov tsiaj ntawv los ntawm lub nroog, thiab tom qab ntawd txheeb txhua tus neeg siv khoom raws tus lej hauv txhua lub nroog. Tsim kom muaj kev sib txawv tuaj yeem ua qhov ntawd.

Sort a List in Microsoft Excel Kauj Ruam 6
Sort a List in Microsoft Excel Kauj Ruam 6

Kauj Ruam 2. Nyem rau khawm Sort

Qhov no tuaj yeem pom nyob hauv "Sort & Filter" ntu ntawm Cov Ntaub Ntawv tab. Qhov Sort window yuav qhib, tso cai rau koj los tsim kev cai cais nrog ntau yam kev ntsuas.

Yog tias koj kab ntawv muaj lub taub hau hauv thawj lub xovtooj, xws li "Lub Nroog" thiab "Lub Npe", nco ntsoov xyuas lub thawv "Kuv cov ntaub ntawv muaj headers" nyob rau sab saud sab laug ntawm lub qhov rai cais

Sort a List in Microsoft Excel Kauj Ruam 7
Sort a List in Microsoft Excel Kauj Ruam 7

Kauj Ruam 3. Tsim koj thawj txoj cai

Nyem rau "Sort by" menu kom xaiv kab ntawv uas koj xav tau. Hauv qhov ua piv txwv no, koj yuav xub xaiv los ntawm lub nroog, yog li xaiv kab ntawv tsim nyog los ntawm cov ntawv qhia zaub mov.

  • Khaws "Sort on" teeb tsa rau "Values".
  • Teem qhov kev txiav txim rau "A rau Z" lossis "Z rau A" nyob ntawm seb koj xav txheeb li cas.
Sort a List in Microsoft Excel Kauj Ruam 8
Sort a List in Microsoft Excel Kauj Ruam 8

Kauj Ruam 4. Tsim koj txoj cai thib ob

Nyem rau "Ntxiv Qib" khawm. Qhov no yuav ntxiv txoj cai hauv qab thawj qhov. Xaiv kab thib ob (Lub Npe Lub npe hauv peb qhov piv txwv) thiab tom qab ntawd xaiv qhov kev txiav txim cais (kom yooj yim nyeem, xaiv tib qhov kev txiav txim raws li koj thawj txoj cai).

Sort a List in Microsoft Excel Kauj Ruam 9
Sort a List in Microsoft Excel Kauj Ruam 9

Kauj Ruam 5. Nyem OK

Koj cov npe yuav raug txheeb raws li koj cov cai. Koj yuav tsum pom cov nroog teev npe ua tus ntawv, thiab tom qab ntawd cov npe cov neeg siv khoom tau txheeb raws tus lej hauv txhua lub nroog.

Qhov piv txwv no yog ib qho yooj yim thiab tsuas suav nrog ob kab lus. Txawm li cas los xij, koj tuaj yeem ua kom koj cov nyom nyuaj raws li koj xav tau, thiab suav nrog ntau kab

Ntu 3 ntawm 3: Sorting by Cell lossis Font Color

Sort a List in Microsoft Excel Kauj Ruam 10
Sort a List in Microsoft Excel Kauj Ruam 10

Kauj Ruam 1. Xaiv koj cov ntaub ntawv

Koj tuaj yeem nyem thiab rub kom xaiv kab ntawv uas koj xav txheeb, lossis koj tuaj yeem nyem ib qho ntawm cov cell hauv kab ntawv kom nws ua haujlwm thiab cia Excel xaiv cov ntaub ntawv cia.

Sort a List in Microsoft Excel Kauj Ruam 11
Sort a List in Microsoft Excel Kauj Ruam 11

Kauj Ruam 2. Nyem rau khawm Sort

Lub khawm xaiv tuaj yeem pom nyob hauv Cov Ntaub Ntawv tab hauv ntu "Sort & Filter". Qhov no yuav qhib qhov Sort window. Yog tias koj muaj lwm kab ntawv ntawm cov ntaub ntawv nyob ib sab ntawm ib qho uas koj tau txheeb, koj yuav raug nug yog tias koj xav suav nrog cov ntaub ntawv ntawd hauv cov khoom.

Sort a List in Microsoft Excel Kauj Ruam 12
Sort a List in Microsoft Excel Kauj Ruam 12

Kauj Ruam 3. Xaiv "Cell Color" lossis "Font Color" hauv "Sort On" menu

Qhov no yuav tso cai rau koj xaiv thawj xim uas koj xav tau los ntawm.

Sort a List in Microsoft Excel Kauj Ruam 13
Sort a List in Microsoft Excel Kauj Ruam 13

Kauj Ruam 4. Xaiv cov xim twg koj xav txheeb ua ntej

Hauv kab ntawv "Order", koj tuaj yeem siv cov ntawv qhia zaub mov nco tseg kom xaiv cov xim twg koj xav tso ua ntej lossis zaum kawg hauv kev xaiv. Koj tsuas tuaj yeem xaiv cov xim uas muaj nyob hauv kab ntawv.

Tsis muaj qhov xaj xaj ua ntej rau kev txheeb xim. Koj yuav tsum tau txheeb xyuas qhov kev txiav txim koj tus kheej

Sort a List in Microsoft Excel Kauj Ruam 14
Sort a List in Microsoft Excel Kauj Ruam 14

Kauj Ruam 5. Ntxiv lwm xim

Koj yuav tsum tau ntxiv lwm txoj cai rau txhua xim hauv kab uas koj tau txheeb. Nyem rau "Ntxiv Qib" txhawm rau ntxiv lwm txoj cai rau kev txheeb xyuas. Xaiv cov xim tom ntej uas koj xav txheeb los ntawm, thiab tom qab ntawv xaj uas koj xav txheeb.

Nco ntsoov tias txhua qhov kev txiav txim zoo ib yam rau txhua txoj cai. Piv txwv li, yog tias koj tau xaiv los ntawm sab saum toj mus rau hauv qab, xyuas kom tseeb "Tshooj" ntu rau txhua txoj cai hais tias "Nyob saum"

Sort a List in Microsoft Excel Kauj Ruam 15
Sort a List in Microsoft Excel Kauj Ruam 15

Kauj Ruam 6. Nyem OK

Txhua txoj cai yuav siv ib los ntawm ib qho, thiab kab ntawv yuav raug txheeb raws cov xim uas koj tau hais tseg.

Lub tswv yim

  • Sim txheeb cov ntaub ntawv hauv ntau txoj kev; cov kev xav tshiab no tuaj yeem pom qhov sib txawv ntawm cov ntaub ntawv.
  • Yog tias koj daim ntawv nthuav tawm muaj tag nrho, qhov nruab nrab lossis lwm cov ntsiab lus hauv qab cov ntaub ntawv koj xav tau los txheeb, ua tib zoo tsis txhob txheeb cov ntawd ib yam.

Pom zoo:

Yuav Ua Li Cas Hloov Cov Npe Cov Npe hauv Bulk hauv Windows: 6 Cov Kauj Ruam

Yuav Ua Li Cas Hloov Cov Npe Cov Npe hauv Bulk hauv Windows: 6 Cov Kauj Ruam

Qhov wikiHow qhia koj yuav hloov pauv cov npe ntawm ntau cov ntaub ntawv ib zaug hauv Windows. Cov kauj ruam Kauj Ruam 1. Nias ⊞ Yeej+E qhib File Explorer Qhov no qhia cov npe ntawm cov tsav, cov ntawv tais ceev tseg, thiab cov ntaub ntawv hauv koj lub computer.

Yuav Ua Li Cas Ntxiv Cov Npe rau Cov Duab hauv Excel: 8 Kauj Ruam (nrog Duab)

Yuav Ua Li Cas Ntxiv Cov Npe rau Cov Duab hauv Excel: 8 Kauj Ruam (nrog Duab)

Microsoft Excel yog ntau dua li daim ntawv thov daim ntawv yooj yim; nws kuj tseem tso cai rau cov neeg siv los tsim cov lus teb nyuaj thiab teeb tsa cov ntaub ntawv tau zoo los ntawm kev siv cov pivot cov lus, kev ua haujlwm thiab cov duab.

Yuav Ua Li Cas Txheeb Xyuas Koj Cov Neeg Hauv Cov Teeb Meem Hauv Android: 7 Cov Kauj Ruam

Yuav Ua Li Cas Txheeb Xyuas Koj Cov Neeg Hauv Cov Teeb Meem Hauv Android: 7 Cov Kauj Ruam

Qhov wikiHow no qhia koj li cas los txheeb xyuas tias koj lub teeb liab hu rau tus lej encryption muaj kev nyab xeeb. Koj yuav tsum nyob hauv tib lub cev qhov chaw raws li tus neeg koj tab tom txheeb xyuas, vim tias ob tus neeg siv yuav tsum ua tiav cov theem no.

Yuav Sau Npe Li Cas Npe Npe ntawm Freenode: 7 Cov Kauj Ruam (nrog Duab)

Yuav Sau Npe Li Cas Npe Npe ntawm Freenode: 7 Cov Kauj Ruam (nrog Duab)

Freenode network yog lub tsev rau ntau tus neeg koom nrog hauv software dawb thiab cov phiaj xwm dawb (xws li wikis). Cov txheej txheem rau npe yog yooj yim thiab tsuas yog siv ob peb feeb. Nov yog cov kauj ruam. Cov kauj ruam Kauj Ruam 1.

Yuav Ua Li Cas Rho Tawm Ib Daim Ntawv Teev Npe iPhone Sau Npe Sau Npe: 7 Cov Kauj Ruam

Yuav Ua Li Cas Rho Tawm Ib Daim Ntawv Teev Npe iPhone Sau Npe Sau Npe: 7 Cov Kauj Ruam

Puas yog koj tus thawj coj ntxiv daim ntawv qhia hnub rau koj iCloud uas koj tsis xav pom? Tej zaum daim ntawv thov rub tawm tsis ntev los no tau ua zoo ib yam, thiab tam sim no koj tab tom tau txais kev thab plaub pop-ups ntawm koj iPhone. Los ntawm kev tshem tawm daim ntawv qhia hnub, koj tuaj yeem rov qab mus rau hom kev ceeb toom uas koj nyiam pom.