Umsebenzi we-AutoFilter ku-Excel. Uhlelo lokusebenza nesilungiselelo

Uma udinga ukuthola umugqa owodwa noma eminingi etafuleni elikhulu, kufanele uchithe isikhathi esiningi upheqa eshidini futhi ubheka amaseli alungile ngamehlo akho. Isihlungi esakhelwe ngaphakathi se-Microsoft Excel senza kube lula ukuthola idatha phakathi kwamaseli amaningi. Ake sithole ukuthi sivumela futhi sikhubaze kanjani isihlungi esizenzakalelayo, futhi sihlaziye amathuba esiwanikeza abasebenzisi.

Uyenza kanjani i-AutoFilter isebenze ku-Excel

Kunezindlela ezimbalwa zokuqalisa ukusebenzisa le nketho. Ake sihlaziye ngayinye yazo ngokucacile. Umphumela wokuvula isihlungi uzoba ukubonakala kwenkinobho eyisikwele enomcibisholo eduze kweseli ngalinye kunhlokweni yethebula.

1. Ithebhu ethi Ikhaya iqukethe izigaba ezimbalwa. Phakathi kwabo - "Ukuhlela", futhi udinga ukukunaka.
2. Khetha iseli okuzosethelwa lona isihlungi, bese uchofoza inkinobho ethi “Hlunga futhi Hlunga” kulesi sigaba.
3. Imenyu encane izovuleka lapho udinga khona ukukhetha into ethi "Hlunga".

1. Indlela yesibili idinga enye ithebhu kumenyu ye-Microsoft Excel - ibizwa ngokuthi "Idatha". Inesigaba esihlukile ebekelwe ukuhlunga nezihlungi.
2. Futhi, chofoza iseli oyifunayo, vula "Idatha" bese uchofoza inkinobho ethi "Hlunga" enesithombe sefaneli.

Kubalulekile! Ungasebenzisa kuphela isihlungi uma ithebula linesihloko. Ukusetha isihlungi etafuleni ngaphandle kwezihloko kuzoholela ekulahlekeni kwedatha kumugqa ophezulu - zizonyamalala ekubukeni.

Ukusetha isihlungi ngedatha yethebula

Isihlungi sivame ukusetshenziswa kumathebula amakhulu. Kudingeka ukuze ubuke ngokushesha imigqa yesigaba esisodwa, uyihlukanise okwesikhashana kolunye ulwazi.

1. Ungahlunga kuphela idatha ngekholomu yedatha. Vula imenyu ngokuchofoza umcibisholo osekhanda lekholomu ekhethiwe. Uhlu lwezinketho luzovela ozohlunga ngalo idatha.
2. Okokuqala, ake sizame into elula kakhulu – susa omaka abambalwa, kusale eyodwa kuphela.
3. Njengomphumela, ithebula lizoqukatha kuphela imigqa equkethe inani elikhethiwe.
4. Isithonjana sefaneli sizovela eduze komcibisholo, okubonisa ukuthi isihlungi sinikwe amandla.

Ukuhlunga futhi kwenziwa ngezihlungi zombhalo noma izinombolo. Uhlelo luzoshiya imigqa eshidini ehlangabezana nezidingo ezimisiwe. Isibonelo, isihlungi sombhalo "esilingana" sihlukanisa imigqa yetafula ngegama elishiwo, "akulingani" kusebenza ngenye indlela - uma ucacisa igama kuzilungiselelo, ngeke kube khona imigqa nalo. Kukhona izihlungi zombhalo ezisuselwe kuhlamvu lokuqala noma lokugcina.

Izinombolo zingahlungwa ngezihlungi “ezinkulu noma ezilinganayo”, “zincane noma zilingana”, “phakathi”. Uhlelo luyakwazi ukugqamisa izinombolo zokuqala eziyi-10, khetha idatha ngenhla noma ngaphansi kwenani elimaphakathi. Uhlu olugcwele lwezihlungi zombhalo nolwazi lwezinombolo:

Uma amaseli enziwe umthunzi futhi ikhodi yombala isethiwe, ikhono lokuhlunga ngombala liyavuleka. Amaseli ombala okhethiwe aya phezulu. Isihlungi ngombala sikuvumela ukuthi ushiye kumigqa yesikrini amaseli awo anemibala emthunzini okhethwe ohlwini.

Kubalulekile! Ngokwehlukana, kufanelekile ukuqaphela umsebenzi othi "Okuthuthukisiwe ..." engxenyeni ethi "Hlunga futhi Hlunga". Iklanyelwe ukwandisa amandla okuhlunga. Ngokusebenzisa isihlungi esithuthukisiwe, ungasetha izimo mathupha njengomsebenzi.

Isenzo sokuhlunga sisethwa kabusha ngezindlela ezimbili. Indlela elula ukusebenzisa umsebenzi othi “Hlehlisa” noma cindezela inhlanganisela yokhiye “Ctrl + Z”. Enye indlela ukuvula ithebhu yedatha, thola ingxenye ethi "Hlunga futhi Hlunga" bese uchofoza inkinobho ethi "Sula".

Isihlungi Ngokwezifiso: Enza ngendlela oyifisayo ngokwemibandela

Ukuhlunga idatha kuthebula kungahlelwa ngendlela elungele umsebenzisi othile. Ukwenza lokhu, inketho ethi "Isihlungi ngokwezifiso" inikwe amandla kumenyu yesihlungi esizenzakalelayo. Ake sibone ukuthi iwusizo kanjani nokuthi ihluke kanjani ezindleleni zokuhlunga ezishiwo uhlelo.

1. Vula imenyu yokuhlunga yeyodwa yamakholomu bese ukhetha ingxenye ethi “Isihlungi ngokwezifiso…” kumenyu yesihlungi sombhalo/inombolo.
2. Iwindi lezilungiselelo lizovuleka. Kwesokunxele kukhona inkambu yokukhetha isihlungi, kwesokudla kunedatha ngesisekelo sokuthi yikuphi ukuhlunga okuzosebenza. Ungakwazi ukuhlunga ngemibandela emibili ngesikhathi esisodwa - yingakho kukhona amapheya amabili ezinkambu efasiteleni.

3. Isibonelo, ake sikhethe isihlungi esithi "equals" kuyo yomibili imigqa bese sibeka amanani ahlukene - isibonelo, 39 emgqeni owodwa no-79 komunye.
4. Uhlu lwamanani lusohlwini oluvulekayo ngemva kokuchofoza umcibisholo, futhi luhambisana nokuqukethwe kwekholomu lapho kuvulwe khona imenyu yesihlungi. Udinga ukushintsha ukukhetha kokugcwalisa imibandela ukusuka kokuthi “kanye” kuye kokuthi “noma” ukuze isihlungi sisebenze, futhi singasusi yonke imigqa yethebula.
5. Ngemva kokuchofoza inkinobho ethi "KULUNGILE", ithebula lizobukeka okusha. Kukhona kuphela leyo migqa lapho intengo isethelwe ku-39 noma 79. Umphumela ubukeka kanje:

Ake sibheke umsebenzi wezihlungi zombhalo:

1. Ukuze wenze lokhu, vula imenyu yokuhlunga kukholamu enedatha yombhalo bese ukhetha noma yiluphi uhlobo lwesihlungi - isibonelo, "iqala ngokuthi ...".
2. Isibonelo sisebenzisa umugqa owodwa wokuhlunga, kodwa ungasebenzisa okubili.

Khetha inani bese uchofoza inkinobho ethi "OK".

3. Ngenxa yalokho, imigqa emibili eqala ngohlamvu olukhethiwe ihlala esikrinini.

Ikhubaza i-AutoFilter ngeMenu ye-Excel

Ukuze uvale isihlungi etafuleni, udinga ukuvula imenyu ngamathuluzi futhi. Kunezindlela ezimbili zokwenza lokhu.

1. Ake sivule ithebhu "Idatha", phakathi nendawo yemenyu kukhona inkinobho enkulu ethi "Hlunga", eyingxenye yesigaba "Hlunga futhi Hlunga".
2. Uma uchofoza le nkinobho, izithonjana zemicibisholo zizonyamalala kunhlokweni, futhi ngeke kwenzeke ukuhlunga imigqa. Ungakwazi ukuvula izihlungi futhi uma kudingeka.

Enye indlela ayidingi ukuhamba kumathebhu - ithuluzi olifunayo litholakala "Ekhaya". Vula ingxenye ethi “Hlunga futhi Hlunga” kwesokudla bese uchofoza entweni ethi “Hlunga” futhi.

Iseluleko! Ukuze unqume ukuthi ukuhlunga kuvuliwe noma kuvaliwe, awukwazi ukubheka isihloko setafula kuphela, kodwa futhi nakwimenyu. Into ethi "Hlunga" igqanyiswa ngowolintshi uma ivuliwe.

Isiphetho

Uma isihlungi esizenzakalelayo silungiselelwe kahle, sizokusiza ukuthi uthole ulwazi kuthebula elinesihloko. Izihlungi zisebenza ngedatha yezinombolo neyombhalo, esiza umsebenzisi ukuthi enze umsebenzi ube lula ngespredishithi se-Excel.