Yuav ua li cas txav cov kab hauv Excel

Cov txheej txheem:

Yuav ua li cas txav cov kab hauv Excel
Yuav ua li cas txav cov kab hauv Excel
Anonim

Yuav Paub

  • Txoj hauv kev yooj yim tshaj plaws kom txav ib kem hauv Excel yog qhov tseem ceeb rau nws, nias Shift, thiab luag nws mus rau qhov chaw tshiab.
  • Koj tuaj yeem siv txiav & muab tshuaj txhuam lossis ua Cov Ntaub Ntawv Sort kom rov kho txhua kab los ntawm cov ntaub ntawv tab.
  • Kem uas yog ib feem ntawm pawg sib koom ua ke ntawm cov hlwb yuav tsis txav mus.

Kab lus no hais txog yuav ua li cas txav ib kem hauv Excel siv tus nas, txiav thiab muab tshuaj txhuam ib kem, thiab rov kho cov kab uas siv Data Sort function. Cov lus qhia no siv rau Microsoft Excel 2019 thiab 2016 nrog rau Excel hauv Office 365.

Yuav ua li cas txav cov kab hauv Excel

Muaj ntau txoj hauv kev los kho cov kab hauv Excel, tab sis ib qho yooj yim dua li lwm tus. Nws tsuas yog siv lub ntsiab lus tseem ceeb thiab rub-thiab-poob suab. Nov yog yuav ua li cas txav kab hauv Excel siv koj tus nas.

  1. Nyob rau hauv daim ntawv ua haujlwm uas koj xav rov nruab kab, tso koj tus cursor rau saum kab koj xav txav. Koj yuav tsum pom koj tus cursor hloov mus rau ib tug xub. Thaum nws ua li ntawd, nyem rau qhov tseem ceeb ntawm kab.

    Image
    Image
  2. Tom ntej no, nias thiab tuav lub Shift tus yuam sij ntawm cov keyboard thiab tom qab ntawd nyem thiab tuav ntawm sab xis lossis sab laug ciam teb ntawm kab koj xav txav thiab rub mus rau sab xis los yog sab laug.

    Thaum koj rub koj tus cursor hla txhua kab, koj yuav pom ciam teb tsaus nti kom pom qhov twg kab tshiab yuav tshwm sim. Thaum koj txaus siab rau qhov chaw, tso tus nas nyem.

    Image
    Image
  3. Koj kem yuav raug tsiv mus rau qhov chaw qhia ntawm tus ciam teb tsaus nti.

    Image
    Image

Yuav ua li cas txav ib kab hauv Excel nrog txiav thiab muab tshuaj

Txoj hauv kev yooj yim tshaj plaws tom ntej kom txav ib kem hauv Excel yog txiav thiab muab kab ntawv los ntawm qhov chaw qub mus rau qhov tshiab. Qhov no ua haujlwm ntau npaum li koj xav tau.

  1. Highlight rau kab koj xav txav, thiab tom qab ntawd nias Ctrl + Xntawm koj cov keyboard kom txiav kem ntawm nws qhov chaw tam sim no. Koj yuav pom "ntiaj teb taug kev" nyob ib ncig ntawm kab los qhia tias nws tau raug txiav los ntawm nws qhov chaw tam sim no.

    Image
    Image
  2. Tom ntej no, taw qhia ib kab rau sab xis ntawm qhov chaw koj xav txav kab txiav mus rau, thiab nyem rau sab xis. Hauv cov ntawv qhia zaub mov, xaiv Insert Cut Cells.

    Image
    Image
  3. Kab tshiab tau muab tso rau sab laug ntawm kab xaiv.

    Image
    Image

Yuav ua li cas txav cov kab hauv Excel Siv cov ntaub ntawv txheeb

Tsiv kab nrog cov ntaub ntawv txheeb xyuas tej zaum tsis yog txoj hauv kev yooj yim tshaj plaws los txav khoom ncig yog tias koj tsuas muaj ib lossis ob kab uas yuav tsum tau txav mus, tab sis yog tias koj muaj daim ntawv loj loj thiab koj xav hloov qhov kev txiav txim ntawm ntau kab, qhov kev ua kom yuam kev me me no tuaj yeem txuag lub sijhawm loj.

Txoj kev no yuav tsis ua haujlwm yog tias koj muaj Cov Ntaub Ntawv Siv Tau rau hauv qhov chaw ntawm koj cov kab uas twb muaj lawm. Txhawm rau txuas ntxiv, koj yuav tsum tshem tawm cov ntaub ntawv siv tau. Txhawm rau ua li ntawd, taw qhia cov hlwb nrog cov ntaub ntawv siv tau, xaiv Data Validation > Settings > Clear All, thiab nias OK

  1. Txhawm rau pib, koj yuav tsum tau ntxiv ib kab rau saum koj daim ntawv tshaj tawm. Txhawm rau ua qhov no, nyem rau ntawm kab thawj zaug thiab xaiv Insert los ntawm cov ntawv qhia zaub mov.

    Image
    Image
  2. Ib kab tshiab tau muab tso rau saum koj kab saum toj kawg nkaus. Cov kab no yuav tsum nyob rau sab saum toj ntawm nplooj ntawv, saum toj no tag nrho lwm cov kab header lossis kab cov ntaub ntawv.

    Nkag mus rau koj daim ntawv tshaj tawm thiab suav cov kab hauv qhov kev txiav txim koj xav kom lawv tshwm hauv daim ntawv nthuav dav los ntawm kev nkag mus rau tus lej hauv kab tshiab. Nco ntsoov tus lej txhua kab uas koj siv.

    Image
    Image
  3. Tom ntej, xaiv tag nrho cov ntaub ntawv hauv daim ntawv nthuav dav uas koj xav rov teeb tsa. Tom qab ntawd ntawm Data tab, hauv Sort & Filter pawg, nyem Sort.

    Image
    Image
  4. In the Sort dialog box, nyem Options.

    Image
    Image
  5. Nyob rau hauv Xaiv xaiv dialog box, nyem lub xov tooj cua ntawm ib sab ntawm Saib laug mus rau sab xis thiab tom qab ntawd nyem OK.

    Image
    Image
  6. Koj xa rov qab mus rau Sort dialog box. Nyob rau hauv Sort By drop down menu xaiv Raw 1 thiab ces nias OK.

    Image
    Image
  7. Qhov no yuav tsum txheeb koj kab raws li tus lej koj tau teev nyob rau hauv thawj kab. Tam sim no koj tuaj yeem nyem rau thawj kab thiab xaiv Delete kom tshem tau nws.

    Image
    Image

Pom zoo: