AutoFilter ntchito mu Excel. Kugwiritsa ntchito ndi kukhazikitsa

Mukafuna kupeza mizere imodzi kapena zingapo patebulo lalikulu, muyenera kuthera nthawi yambiri mukudutsa papepala ndikuyang'ana maselo oyenera ndi maso anu. Zosefera za Microsoft Excel zomwe zimapangidwira zimapangitsa kuti zikhale zosavuta kupeza deta pakati pa maselo ambiri. Tiyeni tiwone momwe tingatsegulire ndikuletsa zosefera zokha, ndikuwunika mwayi womwe umapatsa ogwiritsa ntchito.

Momwe mungayambitsire AutoFilter mu Excel

Pali njira zingapo zoyambira kugwiritsa ntchito njirayi. Tiyeni tipende bwinobwino iliyonse mwa izo. Zotsatira za kuyatsa fyuluta kudzakhala mawonekedwe a batani lalikulu ndi muvi pafupi ndi selo iliyonse pamutu wa tebulo.

1. The Home tabu ili ndi zigawo zingapo. Pakati pawo - "Kusintha", ndipo muyenera kulabadira.
2. Sankhani selo lomwe fyulutayo idzakhazikitsidwe, kenako dinani batani la "Sort and Selter" mu gawoli.
3. Menyu yaying'ono idzatsegulidwa pomwe muyenera kusankha chinthu cha "Zosefera".

1. Njira yachiwiri imafuna tabu ina mumndandanda wa Microsoft Excel - imatchedwa "Data". Ili ndi gawo losiyana losungidwa kuti lisankhidwe ndi zosefera.
2. Apanso, dinani pa cell yomwe mukufuna, tsegulani "Data" ndikudina batani la "Sefa" ndi chithunzi cha faneli.

Zofunika! Mutha kugwiritsa ntchito fyuluta ngati tebulo lili ndi mutu. Kuyika fyuluta patebulo popanda mitu kumabweretsa kutayika kwa deta pamzere wapamwamba - zidzasowa powonekera.

Kukhazikitsa zosefera ndi data ya tebulo

Zosefera nthawi zambiri zimagwiritsidwa ntchito pamatebulo akulu. Zimafunika kuti muwone msanga mizere ya gulu limodzi, kuwalekanitsa kwakanthawi ndi zina.

1. Mutha kungosefa ndi data yandalama. Tsegulani menyu podina muvi womwe uli pamutu wagawo losankhidwa. Padzawoneka mndandanda wa zosankha zomwe mungasankhire deta.
2. Poyamba, tiyeni tiyese chinthu chosavuta - chotsani zolembera zochepa, ndikusiya chimodzi chokha.
3. Zotsatira zake, tebulo lidzangokhala ndi mizere yokhala ndi mtengo wosankhidwa.
4. Chizindikiro cha fanulo chidzawonekera pafupi ndi muvi, kusonyeza kuti fyuluta ndiyoyatsidwa.

Kusanja kumachitikanso ndi zolemba kapena zosefera manambala. Pulogalamuyi idzasiya mizere papepala yomwe ikukwaniritsa zofunikira zomwe zakhazikitsidwa. Mwachitsanzo, fyuluta ya malemba "yofanana" imalekanitsa mizere ya tebulo ndi mawu otchulidwa, "osati ofanana" amagwira ntchito mosiyana - ngati mutchula mawu muzokonda, sipadzakhala mizere nayo. Pali zosefera zotengera zilembo zoyambira kapena zomaliza.

Manambala amatha kusanjidwa ndi zosefera "zazikulu kuposa kapena zofanana", "zocheperako kapena zofanana", "pakati". Pulogalamuyi imatha kuwonetsa manambala 10 oyambirira, sankhani deta pamwamba kapena pansi pa mtengo wapakati. Mndandanda wa zosefera zamawu ndi manambala:

Ngati maselo ali ndi mthunzi ndipo chizindikiro cha mtundu chakhazikitsidwa, luso losankha ndi mtundu limatsegulidwa. Maselo amtundu wosankhidwa amasunthira pamwamba. Zosefera potengera mtundu zimakulolani kuti muchoke pamizere ya zenera yomwe ma cell ake amapangidwa ndi mthunzi wosankhidwa pamndandanda.

Zofunika! Payokha, ndikofunika kuzindikira ntchito ya "Advanced ..." mu gawo la "Sort and Selter". Zapangidwa kuti ziwonjezere mphamvu zosefera. Pogwiritsa ntchito fyuluta yapamwamba, mukhoza kuyika mikhalidwe pamanja ngati ntchito.

Zosefera zimakhazikitsidwanso m'njira ziwiri. Njira yosavuta ndiyo kugwiritsa ntchito "Bwezerani" kapena dinani makiyi ophatikizira "Ctrl + Z". Njira ina ndikutsegula tabu ya data, pezani gawo la "Sort and Selter" ndikudina batani la "Chotsani".

Zosefera Mwamakonda: Sinthani Mwamakonda Anu ndi Zofunikira

Kusefa kwa data mu tebulo kungathe kukonzedwa m'njira yabwino kwa wogwiritsa ntchito. Kuchita izi, "Mwambo fyuluta" njira ndikoyambitsidwa mu autofilter menyu. Tiyeni tiwone momwe zimagwirira ntchito komanso momwe zimasiyanirana ndi zosefera zomwe zafotokozedwa ndi dongosolo.

1. Tsegulani mndandanda wamitundu imodzi mwazagawo ndikusankha gawo la "Zosefera Mwamakonda ..." kuchokera pazosefera zolemba/nambala.
2. Zenera la zoikamo lidzatsegulidwa. Kumanzere ndi gawo losankhira zosefera, kumanja kuli deta pamaziko omwe kusanja kudzagwira ntchito. Mutha kusefa ndi njira ziwiri nthawi imodzi - ndichifukwa chake pazenera pali magawo awiri a magawo.

3. Mwachitsanzo, tiyeni tisankhe "equals" fyuluta pa mizere yonse ndikuyika mfundo zosiyana - mwachitsanzo, 39 pamzere umodzi ndi 79 pa mzake.
4. Mndandanda wazomwe zili pamndandanda womwe umatsegulidwa pambuyo podina muvi, ndipo umagwirizana ndi zomwe zili mgawo pomwe zosefera zidatsegulidwa. Muyenera kusintha kusankha kukwaniritsa zikhalidwe kuchokera ku "ndi" kupita ku "kapena" kuti fyuluta igwire ntchito, osachotsa mizere yonse ya tebulo.
5. Mukadina batani la "Chabwino", tebulo lidzawoneka mwatsopano. Pali mizere yokhayo yomwe mtengo umayikidwa ku 39 kapena 79. Zotsatira zake zikuwoneka motere:

Tiyeni tiwone momwe zosefera zolemba zimagwirira ntchito:

1. Kuti muchite izi, tsegulani zosefera pagawo ndi zolemba ndikusankha zosefera zamtundu uliwonse - mwachitsanzo, "zikuyamba ndi ...".
2. Chitsanzo chimagwiritsa ntchito mzere umodzi wosefera, koma mutha kugwiritsa ntchito ziwiri.

Sankhani mtengo ndikudina batani "Chabwino".

3. Zotsatira zake, mizere iwiri yoyambira ndi chilembo chosankhidwa imakhalabe pazenera.

Kuletsa AutoFilter kudzera pa Menyu ya Excel

Kuti muzimitse fyuluta patebulo, muyenera kutembenukira ku menyu ndi zida kachiwiri. Pali njira ziwiri zochitira izi.

1. Tiyeni titsegule tabu "Data", pakati pa menyu pali batani lalikulu la "Sefa", lomwe lili gawo la gawo la "Sort and Selter".
2. Mukadina batani ili, zithunzi za mivi zidzazimiririka pamutu, ndipo sizingakhale zotheka kukonza mizere. Mutha kuyatsanso zosefera ngati pakufunika.

Njira ina sikutanthauza kusuntha ma tabu - chida chomwe mukufuna chili pa "Home". Tsegulani gawo la "Sort and Selter" kumanja ndikudinanso chinthu cha "Sefa".

Upangiri! Kuti mudziwe ngati kusanja kwatsekedwa kapena kuzimitsa, simungayang'ane pamutu wa tebulo lokha, komanso menyu. Chinthu cha "Sefa" chimawonetsedwa mulalanje chikayatsidwa.

Kutsiliza

Ngati autofilter yakonzedwa bwino, idzakuthandizani kupeza zambiri patebulo ndi mutu. Zosefera zimagwira ntchito ndi manambala ndi zolemba, zomwe zimathandiza wogwiritsa ntchito kuti achepetse ntchito ndi Excel spreadsheet.