Yuav Ua Li Cas Tshem Cov Lim hauv Excel: 8 Kauj Ruam (nrog Duab)

Cov txheej txheem:

Yuav Ua Li Cas Tshem Cov Lim hauv Excel: 8 Kauj Ruam (nrog Duab)
Yuav Ua Li Cas Tshem Cov Lim hauv Excel: 8 Kauj Ruam (nrog Duab)

Video: Yuav Ua Li Cas Tshem Cov Lim hauv Excel: 8 Kauj Ruam (nrog Duab)

Video: Yuav Ua Li Cas Tshem Cov Lim hauv Excel: 8 Kauj Ruam (nrog Duab)
Video: Saib Mis paub Poj niam (hluas nkauj) tus yam ntxwv lub siab 2024, Tej zaum
Anonim

Qhov wikiHow qhia koj li cas tshem cov ntaub ntawv lim los ntawm kab ntawv lossis tag nrho cov ntawv ua haujlwm hauv Microsoft Excel.

Cov kauj ruam

Txoj Kev 1 ntawm 2: Ntxuav cov ntxaij lim dej hauv ib kem

Ntshiab lim hauv Excel Kauj Ruam 1
Ntshiab lim hauv Excel Kauj Ruam 1

Kauj Ruam 1. Qhib koj daim ntawv nthuav tawm hauv Excel

Koj tuaj yeem ua qhov no los ntawm ob-nias cov ntawv hauv koj lub computer.

Ntshiab lim hauv Excel Kauj Ruam 2
Ntshiab lim hauv Excel Kauj Ruam 2

Kauj Ruam 2. Mus rau ntawm daim ntawv uas koj xav tshem cov lim

Cov ntawv ua haujlwm tab nyob hauv qab ntawm daim ntawv tam sim no.

Clear Filters hauv Excel Kauj Ruam 3
Clear Filters hauv Excel Kauj Ruam 3

Kauj Ruam 3. Nyem rau tus xub xub nyob ib sab ntawm kab lus kab lus

Hauv qee qhov kev ua tau zoo, koj yuav pom lub cim me me ntawm lub cim tom ntej ntawm tus xub.

Clear Filters hauv Excel Kauj Ruam 4
Clear Filters hauv Excel Kauj Ruam 4

Kauj Ruam 4. Nyem Clear Filter from (column name)

Tam sim no lub lim tau raug tshem tawm ntawm kab ntawv.

Txoj Kev 2 ntawm 2: Tshem tag nrho cov lim hauv daim ntawv ua haujlwm

Clear Filters hauv Excel Kauj Ruam 5
Clear Filters hauv Excel Kauj Ruam 5

Kauj Ruam 1. Qhib koj daim ntawv nthuav tawm hauv Excel

Koj tuaj yeem ua qhov no los ntawm ob-nias cov ntawv hauv koj lub computer.

Clear Filters hauv Excel Kauj Ruam 6
Clear Filters hauv Excel Kauj Ruam 6

Kauj Ruam 2. Mus rau ntawm daim ntawv uas koj xav tshem cov lim

Cov ntawv ua haujlwm tab nyob hauv qab ntawm daim ntawv tam sim no.

Ntshiab lim hauv Excel Kauj Ruam 7
Ntshiab lim hauv Excel Kauj Ruam 7

Kauj Ruam 3. Nyem rau Cov Ntaub Ntawv tab

Nws nyob rau sab saum toj ntawm qhov screen.

Clear Filters hauv Excel Kauj Ruam 8
Clear Filters hauv Excel Kauj Ruam 8

Kauj Ruam 4. Nyem Clear hauv ntu “Sort & Filter”

Nws nyob ze ntawm qhov chaw nruab nrab ntawm lub cuab yeej nyob rau sab saum toj ntawm lub vijtsam. Tag nrho cov ntxaij lim dej hauv daim ntawv ua haujlwm tam sim no raug tshem tawm.

Pom zoo: