AutoFilter basa muExcel. Application uye setting

Paunenge uchida kuwana mitsara imwe chete kana kupfuura mutafura huru, unofanira kupedza nguva yakawanda uchipeta pepa uye uchitsvaga masero akakodzera nemaziso ako. Iyo yakavakirwa-mukati Microsoft Excel sefa inoita kuti zvive nyore kuwana data pakati pemasero mazhinji. Ngationei nzira yekugonesa nekudzima iyo otomatiki sefa, uye ongorora mikana yainopa vashandisi.

Maitiro ekugonesa AutoFilter muExcel

Pane nzira dzakawanda dzekutanga kushandisa sarudzo iyi. Ngationgororei chimwe nechimwe chazvo zvakajeka. Mhedzisiro yekubatidza sefa kuchave kutaridzika kwebhatani resikweya rine museve padivi pesero rega rega mumusoro wetafura.

1. The Home tab ine zvikamu zvakati. Pakati pavo - "Editing", uye unofanira kuiteerera.
2. Sarudza sero ichagadzirirwa sefa, wobva wadzvanya bhatani rekuti "Ronga uye Sefa" muchikamu chino.
3. Menyu diki ichavhura kwaunoda kusarudza iyo "Sefa" chinhu.

1. Yechipiri nzira inoda imwe tebhu muMicrosoft Excel menyu - inonzi "Data". Iine chikamu chakasiyana chakachengeterwa kuronga uye mafirita.
2. Zvekare, tinya pane yaunoda sero, vhura "Data" uye tinya pa "Sefa" bhatani nemufananidzo wefunnel.

Zvinokosha! Unogona kushandisa sefa chete kana tafura ine musoro. Kuisa sefa patafura pasina misoro kunozokonzera kurasikirwa kwedata mumutsara wepamusoro - ivo vanonyangarika kubva pakuona.

Kugadzira sefa netafura data

Sefa inowanzoshandiswa mumatafura makuru. Inodiwa kuti ikurumidze kuona mitsetse yechikamu chimwe chete, ivaparadzanise kwenguva pfupi kubva kune rumwe ruzivo.

1. Iwe unogona chete kusefa data ne column data. Vhura menyu nekudzvanya pane museve uri mumusoro wekoramu yakasarudzwa. Rondedzero yezvaungasarudza ichaonekwa yekuronga nayo data.
2. Kutanga, ngatiedzei chinhu chakareruka - bvisa macheki mashoma, uchisiya imwe chete.
3. Nekuda kweizvozvo, tafura inongove nemitsara ine kukosha kwakasarudzwa.
4. Iyo funnel icon ichaonekwa padivi pemuseve, zvichiratidza kuti sefa yakagoneswa.

Kuronga kunoitwa zvakare nemavara kana manhamba mafirita. Iyo purogiramu ichasiya mitsetse papepa inosangana nezvinodiwa zvakasimbiswa. Semuenzaniso, chinyorwa chekunyora "yakaenzana" chinoparadzanisa mitsara yetafura neshoko rakataurwa, "kwete kuenzana" rinoshanda neimwe nzira - kana iwe ukatsanangura izwi muzvirongwa, hapazovi nemitsara nayo. Pane mavara mafirita anoenderana nemavara ekutanga kana ekupedzisira.

Nhamba dzinogona kurongwa nemasefa “akakura kupfuura kana akaenzana”, “zvishoma pane kana zvakaenzana”, “pakati”. Iyo purogiramu inokwanisa kuratidza nhamba dzekutanga dzegumi, sarudza data pamusoro kana pasi peavhareji kukosha. Rondedzero yakazara yemasefa yezvinyorwa uye ruzivo rwenhamba:

Kana maseru akaiswa shaded uye kodhi yemuvara ikaiswa, kugona kuronga nemuvara kunovhura. Masero eruvara rwakasarudzwa anoenda kumusoro. Iyo sefa nemuvara inobvumidza iwe kuti usiye pane iyo skrini mitsara ine masero ane mavara mumumvuri akasarudzwa kubva pane iyo rondedzero.

Zvinokosha! Kusiyana, zvakakosha kucherechedza basa re "Advanced ..." muchikamu che "Ronga uye Sefa". Yakagadzirirwa kuwedzera masimba ekusefa. Uchishandisa sefa yepamusoro, unogona kuseta mamiriro acho nemaoko sebasa.

Iyo sefa chiito inogadzwa patsva nenzira mbiri. Nzira iri nyore ndeye kushandisa "Undo" basa kana kudzvanya kiyi musanganiswa "Ctrl + Z". Imwe nzira ndeyekuvhura iyo data tab, tsvaga "Ronga uye Sefa" chikamu uye tinya bhatani re "Bvisa".

Tsika Sefa: Gadzirisa neCriteria

Kusefa data mutafura kunogona kugadzirwa nenzira yakanakira mumwe mushandisi. Kuti uite izvi, iyo "Custom sefa" sarudzo inogoneswa mune iyo autofilter menyu. Ngationei kuti inobatsira sei uye kuti inosiyana sei nemodhi yekusefa inotsanangurwa nehurongwa.

1. Vhura menyu yemhando yeimwe yemakoramu uye sarudza iyo "Custom Filter ..." chikamu kubva pane zvinyorwa / nhamba sefa menyu.
2. Hwindo rezvirongwa richavhurika. Kuruboshwe ndiko kusarudzwa kwesefa, kurudyi kune data pahwaro hwekuronga kuchashanda. Iwe unogona kusefa nemaitiro maviri kamwechete - ndosaka paine maviri maviri eminda muhwindo.

3. Semuyenzaniso, ngatisarudzei "yakaenzana" sefa pamitsara miviri uye tiise maitiro akasiyana - semuenzaniso, 39 pane mumwe mutsara uye 79 kune mumwe.
4. Rondedzero yezvakakosha iri murondedzero inovhurwa mushure mekudzvanya pamuseve, uye inoenderana nezviri mukati mecolum pakavhurwa iyo sefa menyu. Iwe unofanirwa kushandura sarudzo yekuzadzisa mamiriro kubva ku "uye" kuenda ku "kana" kuitira kuti sefa ishande, uye isingabvisi mitsara yese yetafura.
5. Mushure mekudzvanya bhatani rekuti "OK", tafura inotora chimiro chitsva. Pane mitsara iyo chete iyo mutengo wakaiswa ku39 kana 79. Chigumisiro chinotaridzika seizvi:

Ngatitarisei basa remasefa emavara:

1. Kuti uite izvi, vhura iyo sefa menyu mukoramu ine zvinyorwa zvinyorwa uye sarudza chero mhando yefirita - semuenzaniso, "inotanga ne ...".
2. Muenzaniso unoshandisa imwe autofilter mutsara, asi unogona kushandisa maviri.

Sarudza kukosha uye tinya bhatani "OK".

3. Nekuda kweizvozvo, mitsetse miviri inotanga netsamba yakasarudzwa inoramba iri pachiratidziri.

Kudzima AutoFilter kuburikidza neExcel Menu

Kuti udzime sefa patafura, unofanirwa kutendeukira kumenyu nemidziyo zvakare. Pane nzira mbiri dzekuita izvi.

1. Ngativhure "Data" tab, pakati pemenyu pane bhatani guru re "Sefa", iro chikamu chechikamu che "Sort and Filter".
2. Kana ukadzvanya bhatani iri, zvidhori zvemiseve zvinonyangarika kubva kumusoro, uye hazvizogoneke kuronga mitsara. Unogona kudzorera mafirita zvakare kana zvichidikanwa.

Imwe nzira haidi kufamba nematabo - chishandiso chinodiwa chiri pa "Kumba". Vhura chikamu che "Ronga uye Sefa" kurudyi uye tinya pane "Sefa" chinhu zvakare.

Zano! Kuti uone kana kurongedza kuri kuvharika kana kuvharwa, iwe unogona kutarisa kwete chete pamusoro wetafura, asiwo pane menyu. Chinhu che "Sefa" chinoratidzwa neorenji kana chabatidzwa.

mhedziso

Kana iyo autofilter yakagadziriswa nemazvo, ichakubatsira iwe kuwana ruzivo mutafura ine musoro. Mafirita anoshanda nenhamba uye yezvinyorwa data, izvo zvinobatsira mushandisi kurerutsa basa neExcel spreadsheet.