Matafura mairi pane mitsara isina chinhu, usataridzika chaizvo. Mukuwedzera, nekuda kwemitsara isina kukodzera, kufamba pamusoro pavo kunogona kuve kwakaomarara, sezvaunofanira kupururudza kuburikidza nehuremu hwakawanda hwekutama kubva pakutanga petafura kusvika kumagumo. Ngatitsvagei nzira dzine nzira dzekubvisa mitsara isina chinhu muMicrosoft Excel chirongwa, uye kuti vangabvisa sei nekukurumidza uye nyore.
Standard kubviswa
Nzira yakakurumbira uye yakakurumbira yekubvisa mitsara isina chinhu ndeyekushandisa iyo mamiriro emenyu yeiyo Excel chirongwa. Kuti ubvise tambo nenzira iyi, sarudza mhando yemasero iyo isina data, uye nekudzvanya bhatani rekurudyi re mbeva. Mukubvisa mamiriro menyu, tinoita shanduko ku "Delete ...". Iwe haugone kufonera mamiriro emenyu, asi kufona iyo "Ctrl + -" khibhodi pane kabhodhi.
Iwindo diki rinooneka, umo iwe unofanirwa kutaurira izvo chaizvo zvatiri kuda kubvisa. Edza chhindu kune "tambo" chinzvimbo. Dzvanya pane "OK" bhatani.
Mushure meizvozvo, mitsara yese yeiyo yakagoverwa huwandu ichadzimwa.
Seimwe sarudzo, unogona kusarudza masero mumitsetse yakakodzera, uye uchiri mu "imba" tab, tinya "bhatani" rinowanikwa mu "cellbar pamusuwo. Mushure meizvozvo, zvichangobviswa pasina mamwe dialog mabhokisi.
Ehe, iyo nzira iri nyore uye inozivikanwa. Asi, inguva yakawanda kwazvo, nekukurumidza uye yakachengeteka?
Kuronga
Kana mitsara isina chinhu iri munzvimbo imwechete, ipapo kubviswa kwavo kuchave kwakachena. Asi kana vakapararira patafura, kutsvaga kwavo uye kubviswa kunogona kutora nguva yakawanda. Mune ino kesi, kurongedza kunofanira kubatsira.
Isu tinosimbisa nzvimbo yese yeTabular. Ini ndinodzvanya pairi kurudyi mbeva bhatani, uye sarudza "Ronga" mune mamiriro menyu. Mushure meizvozvo, imwe menyu inoonekwa. Mukati maro, iwe unofanirwa kusarudza chimwe chezvinhu zvinotevera: "Ronga kubva kuZ," "kubva pane zvishoma kusvika kune yakakwirira", kana "kubva kune chitsva kusvika chekare". Ndechipi chimwe chezvinhu zvakanyorwa zvichave mune menyu, zvinoenderana nemhando yedata iyo inoiswa mumasero tafura.
Mushure mekushanda kuri pamusoro apa, masero asina chinhu ese anoenda kuzasi kwetafura. Zvino, tinogona kubvisa masero aya neipi idzo nzira idzodzo dzaikurukurwa muchikamu chekutanga chechidzidzo.
Kana maitiro ekuisa masero ari patafura ane mhosva, saka asati agadzira kurongedza, isa imwe ikorumurwa pakati petafura.
Masero ese eiyi column nhamba akarongeka.
Zvadaro, isu tinoburitsa kurongedza chero imwe ikholamu, uye bvisa iyo sero racho ichifamba pasi, sezvakatotsanangurwa pamusoro apa.
Mushure meizvozvo, kuitira kuti udzorere kurongeka kwemitsetse kune iyo yanga yatove isati yarongedza, isu tinoita iyo yekugadzirisa mukaro nehuwandu hwetambo "kubva kune zvishoma kusvika kune yakakwira".
Sezvauri kuona, iwo mitsara yakavharirwa muhurongwa hwakafanana, kusasanganisa zvisina chinhu, izvo zvinobviswa. Zvino, isu tinogona chete kubvisa iyo ikhoramu yakawedzerwa ine nhamba dzekuteerera. Isu tinosimbisa iyi ikholamu. Wobva wadzvanya pane bhatani riri paRibbon "Delete". Mumhando yakavhurika, sarudza iyo "Delete makoramu kubva papepa" chinhu. Mushure meizvozvo, ikhongedzo yadikanwa ichadzimwa.
Chidzidzo: Kuronga muMicrosoft Excel
Kushandiswa kwefaira
Imwe sarudzo yekuviga masero asina chinhu ndiko kushandiswa kwefaira.
Isu tinoratidza nzvimbo yese yenzvimbo, uye, kuwana munzvimbo yeimba yeTab, ita iyo iyo tinya pane iyo "Sort uye Filter" bhatani, iyo iri mune yekugadzirisa marongero. Mune menyu inoonekwa, isu tinoita shanduko kune "firita" chinhu.
Chiratidzo chehunhu chinoonekwa mumapepa etafura petafura. Dzvanya pane iri icon mune chero kune yako sarudzo yekoramu.
Mune menyu inoonekwa, bvisa bhokisi rekutarisa kubva ku "isina" chinhu. Dzvanya pane "OK" bhatani.
Sezvauri kuona, shure kwaizvozvo, tambo dzese dzisina chinhu dzakanyangarika, sezvavakadeurwa.
Chidzidzo: Mashandisiro Aungaita Autofilter muMicrosoft Excel
Kusarudzwa kwemasero
Imwe nzira yekubvisa inoshandisa kusarudzwa kweboka remasero asina chinhu. Kuti ushandise nzira iyi, tanga kugovera tafura yese. Zvadaro, kuva mu "Imba" tab, tinya pane "Tsvaga uye sarudza" bhatani, iyo iri patepi mune editing toolbar boka. Mune menyu inoonekwa, tinya pane chinhu "kuzviparadzanisa neboka remasero ...".
Hwindo rinovhura maunogadzirazve iyo switch kune iyo "masero asina chinhu" chinzvimbo. Dzvanya pane "OK" bhatani.
Sezvatinoona, mushure meizvozvo, mitsara yese ine masero asina chinhu akapatsanurwa. Zvino dzvanya "Delete" bhatani ratoziva isu, iri patepi mu "masero emasero" boka.
Mushure meizvozvo, mitsara yese isina chinhu ichabviswa patafura.
Kutaura kwakakosha! Iyo yekupedzisira nzira haigone kushandiswa mumatafura neyekupaza mapoka, uye nemasero asina chinhu ari mumitsetse ipo data iripo. Mune ino kesi, kudzikama cell kunogona kuitika, uye tafura ichatyora.
Sezvatinoona, pane nzira dzinoverengeka dzekubvisa masero asina chinhu kubva patafura. Nderipi nzira iri nani yekuishandisa, zvinoenderana nekuoma kwetafura, uye kuti tambo dzisina chinhu dzakapararira pamwe nahwo (dziri mune imwe block, kana yakasanganiswa nemitsara yakazadzwa nedata).