Maitiro ekusefa nedate muExcel

Matafura akagadzirwa muMicrosoft Office Excel anogona kusefa nemazuva. Nekuisa sefa yakakodzera, mushandisi anozokwanisa kuona mazuva aanoda, uye hurongwa pachahwo huchaderedzwa. Ichi chinyorwa chichakurukura maitiro ekuseta sefa nemazuva muExcel uchishandisa maturusi akavakirwa muchirongwa.

Maitiro ekuisa sefa nemazuva kune tafura array

Kune akati wandei nzira dzakajairwa dzekuita basa, imwe neimwe ine nuances yayo. Kuti uwane kunzwisisa kwakakwana kwechinyorwa, zvinodikanwa kutsanangura nzira imwe neimwe zvakasiyana.

Nzira 1. Kushandisa "Sefa" sarudzo

Iyo iri nyore nzira yekusefa tabular data muExcel, iyo inoreva inotevera algorithm yezviito:

1. Gadzira tafura inoda kusefa nemazuva. Mutsara uyu unofanirwa kunge uine mazuva chaiwo emwedzi.

2. Sarudza tafura yakaunganidzwa nebhatani rekuruboshwe.
3. Enda kune "Kumba" tebhu mubharu repamusoro reExcel main menu.
4. Dzvanya bhatani re "Sefa" mune yesarudzo pane inooneka. Uyewo muchikamu chino pane "Ronga" basa, rinoshandura kurongeka kwekuratidzira kwemitsara kana makoramu mutafura yezvinyorwa, kuaronga neimwe parameter.

5. Mushure mekuita manyepo ekare, sefa ichaiswa patafura, kureva kuti miseve midiki ichaonekwa mumazita emakoramu akarongeka, nekudzvanya paunogona kuvhura sarudzo dzekusefa. Pano iwe unofanirwa kudzvanya pane chero museve.

6. Mune menyu yemukati inovhura, tsvaga chikamu che "Tsvaga nzvimbo" uye sarudza mwedzi uchaitwa kusefa. Mwedzi iyo chete iri muhurongwa hwetafura yekutanga ndiyo inoratidzwa pano. Mushandisi anofanira kutarisa bhokisi riri pedyo nemwedzi unoenderana uye tinya pa "OK" pazasi pehwindo. Zvinokwanisika kusarudza nzira dzakawanda panguva imwe chete.

7. Tarisa mhinduro. Tafura ichange iine ruzivo chete pamwedzi yakasarudzwa nemushandisi pahwindo rekusefa. Nekuda kweizvozvo, data rakawandisa richanyangarika.

Teerera! Mune iyo sefa pamusoro pemenu, unogona kusefa iyo data negore.

Nzira 2. Kushandisa "Filter by date" sarudzo

Iri ibasa rakakosha iro rinokutendera kuti ubve wasefa ruzivo mune tafura array nemazuva. Kuti uite activate, unofanirwa kutevera matanho mashoma:

1. Isa sefa kutafura yepakutanga nenzira imwecheteyo.
2. Muhwindo rekusefa, tsvaga mutsara wekuti "Sefa nemazuva" uye shandisa bhatani rekuruboshwe kudzvanya pamuseve uri kurudyi kwairi.
3. Menyu yekudonhedza ichavhurwa. Hedzino sarudzo dzekusefa data nemazuva.

4. Semuenzaniso, tinya pakanzi "Pakati ...".
5. Iyo Custom AutoFilter hwindo ichavhura. Pano, mumutsara wekutanga, unofanira kutsanangura zuva rekutanga, uye mumutsetse wechipiri, zuva rekupedzisira.

6. Tarisa mhinduro. Chete tsika dziri pakati pemazuva akatarwa dzichasara mutafura.

Method 3: Manual kusefa

Iyi nzira iri nyore kushandisa, asi inotora nguva yakawanda kubva kumushandisi, kunyanya kana iwe uchifanira kushanda nematafura makuru. Kuti usete sefa nemaoko, unofanira:

1. Mune yekutanga tafura rondedzero, tsvaga mazuva asingade mushandisi.
2. Sarudza mitsetse yakawanikwa nebhatani rekuruboshwe.
3. Dzvanya bhatani re "Backspace" kubva pakhibhodi yekombuta kuti udzime zvakasarudzwa.

Mamwe Mashoko! MuMicrosoft Office Excel, unogona kusarudza mitsara yakati wandei mutafura yakarongwa panguva imwe chete kuitira kuti uibvise ipapo kuti uchengetedze mushandisi nguva.

Method 4. Kushandisa advanced filter by date

Pamusoro, iyo nzira yekusefa kukosha mune tafura array yakavakirwa pane "Pakati ..." sarudzo yakatariswa. Kuti uwane kuburitswa kuzere kwechinyorwa, zvinodikanwa kukurukura akati wandei sarudzo dzepamusoro sefa. Hazvina kufanira kufunga marudzi ese esefa mukati megadziriro yechinyorwa chino. Kuisa imwe kana imwe sefa nemazuva patafura, unofanirwa:

1. Isa sefa patafura kuburikidza ne "Kumba" tab. Nzira yekuita izvi yakatsanangurwa pamusoro apa.
2. Wedzera rondedzero yekudonhedza pasi mumusoro wechero koramu patafura uye tinya LMB pamutsara we "Sefa nemazuva".
3. Taura chero sarudzo. Somuenzaniso, tinya mutsara "Nhasi".

4. Ruzivo rwuri muhurongwa huchapepetwa nezuva rakatarwa. Avo. iyo data chete ine zuva ranhasi icharamba iri patafura. Kana uchiseta sefa yakadaro, Excel inotungamirwa nezuva rakaiswa pakombuta.
5. Nekusarudza iyo "Zvimwe ..." sarudzo, mushandisi anozofanira kuisa imwe nhamba. Mushure meizvozvo, tafura yetafura ichange iine misi yakakura kupfuura yakataurwa. Humwe hunhu hwese huchadzimwa.

Zvinokosha! Dzimwe sarudzo dzepamusoro dzekusefa dzinoshandiswa zvakafanana.

Maitiro ekubvisa sei sefa muExcel

Kana mushandisi ataura netsaona sefa nemusi, wozoidzima, unozofanirwa kuita anotevera matanho:

1. Sarudza LMB ndiro iyo kusefa inoshandiswa.
2. Enda kuchikamu che "Kumba" uye tinya bhatani re "Sefa". Menyu yekudonhedza ichavhurwa.
3. Mune menyu yezvinyorwa, tinya bhatani rekuti "Bvisa". Mushure mekuita chiitiko ichi, kusefa kuchadzimwa uye tafura yetafura inodzokera kune yayo yekutanga.

Teerera! Unogona kumisa chiitiko chapfuura uchishandisa "Ctrl + Z" mabhatani.

mhedziso

Nekudaro, iyo sefa nemazuva muMicrosoft Office Excel inobvumidza iwe kukurumidza kubvisa zvisina basa mazuva emwedzi kubva patafura. Nzira huru dzekusefa dzakatsanangurwa pamusoro apa. Kuti unzwisise musoro wacho, unofanira kunyatsoaverenga.