Delete mitsara yakavanzika muExcel. Mumwe nemumwe uye zvese kamwechete

MuMicrosoft Office Excel, unogona kukurumidza kubvisa mitsara yakavanzika, isina chinhu inoshatisa kutaridzika kwetafura. Nzira yekuita izvi ichakurukurwa munyaya ino.

Maitiro ekubvisa mitsara yakavanzika muExcel

Pane nzira dzinoverengeka dzekuita basa racho, rinoitwa uchishandisa yakajairwa chirongwa maturusi. Iyo yakawanda kwazvo yazvo ichakurukurwa pasi apa.

Nzira 1. Maitiro ekudzima mitsara mutafura imwe neimwe kuburikidza nemenu yemukati

Kuti uite basa iri, zvinokurudzirwa kushandisa algorithm inotevera:

1. Sarudza mutsara waunoda weLMB tabular array.
2. Dzvanya chero munzvimbo yakasarudzwa nebhatani rekurudyi rembeva.
3. Mumenu yemukati, tinya pane izwi rekuti "Delete ...".

4. Muhwindo rinovhurwa, isa chinja chekushandura padivi pe "String" parameter uye tinya pa "OK".

5. Tarisa mhinduro. Mutsara wakasarudzwa unofanira kusunungurwa.
6. Ita zvakafanana kune zvimwe zvese zveplate elements.

Teerera! Iyo inofungidzirwa nzira inogonawo kubvisa mbiru dzakavanzwa.

Method 2. Single uninstallation yemitsara kuburikidza nesarudzo mubhabhoni yepurogiramu

Excel ine maturusi akajairwa ekudzima tafura array maseru. Kuti uzvishandise kudzima mitsetse, unofanirwa kuenderera sezvizvi:

1. Sarudza chero sero mumutsara waunoda kudzima.
2. Enda kune "Kumba" tebhu mupaneru yepamusoro yeExcel.
3. Tsvaga bhatani re "Delete" uye wedzera iyi sarudzo nekudzvanya pamuseve uri kurudyi.
4. Sarudza "Delete mitsara kubva papepa" sarudzo.

5. Ita shuwa kuti mutsara wakambosarudzwa wabviswa.

Nzira 3. Nzira yekubvisa sei mitsetse yose yakavanzwa kamwechete

Excel inoshandisawo mukana wekusunungurwa kweboka kwezvinhu zvakasarudzwa zvetafura yetafura. Ichi chimiro chinokubvumira kubvisa mitsetse isina chinhu yakapararira munzvimbo dzakasiyana dzeplate. Kazhinji, iyo uninstallation maitiro akakamurwa mumatanho anotevera:

1. Nenzira yakafanana, chinja kune "Kumba" tab.
2. Munzvimbo inovhura, muchikamu che "Editing", tinya bhatani rekuti "Tsvaga uye sarudza".
3. Mushure mekuita chiitiko chekare, menyu yemukati ichaonekwa umo mushandisi achada kudzvanya pamutsara "Sarudza boka remasero ...".

4. Muhwindo rinoonekwa, iwe unofanirwa kusarudza zvinhu zvekuratidza. Mumamiriro ezvinhu aya, isa shanduko padivi pe "Empty cell" parameter uye tinya "OK". Iye zvino mitsetse yose isina chinhu inofanira kusarudzwa panguva imwe chete mutafura yezvinyorwa, pasinei nenzvimbo yavo.

5. Tinya kurudyi pane chero mitsara yakasarudzwa.
6. Muchinyorwa chinyorwa hwindo, tinya pane izwi rekuti "Delete ..." uye sarudza iyo "String" sarudzo. Mushure mekudzvanya pa "OK" zvese zvakavanzika zvinhu zvinoburitswa.

Zvinokosha! Nzira yekubvisa muboka yakurukurwa pamusoro inogona kushandiswa chete kune mitsara isina chinhu. Izvo hazvifanirwe kunge zvine chero ruzivo, zvikasadaro kushandisa iyo nzira inotungamira kutyora kweiyo tafura chimiro.

Nzira 4: Isa kurongedza

Iyo chaiyo nzira, iyo inoitwa zvinoenderana neinotevera algorithm:

1. Sarudza musoro wetafura. Iyi ndiyo nzvimbo iyo data ichagadziriswa.
2. Mu "Kumba" tab, wedzera "Ronga uye Sefa" chikamu.
3. Mufafitera rinobuda, sarudza sarudzo ye "Custom sorting" nekudzvanya pairi neLMB.

4. Mune tsika yekuronga menyu, tarisa bhokisi riri padyo ne "Data yangu ine misoro" sarudzo.
5. MuKoramu yeOdha, tsanangura chero sarudzo dzekurongedza: kungave "A kusvika Z" kana "Z kusvika A".
6. Mushure mekupedza marongero ekugadzirisa, tinya pa "OK" pazasi pehwindo. Mushure meizvozvo, iyo data iri mutafura yetafura ichagadziriswa zvinoenderana neyakatsanangurwa criterion.

7. Zvinoenderana nechirongwa chakakurukurwa muchikamu chakapfuura chechinyorwa, sarudza mitsara yese yakavanzika uye woidzima.

Kuronga kukosha kunoisa otomatiki mitsara isina chinhu pamagumo etafura.

Mamwe Mashoko! Mushure mekugadzirisa ruzivo muhurongwa, zvinhu zvakavanzika zvinogona kuburitswa nekusarudza zvese nekudzvanya pane "Delete" chinhu mumenu yemukati.

Nzira 5. Kushandisa kusefa

MuExcel maspredishiti, zvinokwanisika kusefa yakapihwa array, ichisiya chete ruzivo rwakakosha mairi. Nenzira iyi unogona kubvisa chero mutsara kubva patafura. Zvakakosha kuita maererano ne algorithm:

1. Shandisa bhatani reruboshwe kuti usarudze musoro wetafura.
2. Enda kuchikamu che "Data" chiri pamusoro pemenu huru yechirongwa.
3. Dzvanya bhatani rekuti "Sefa". Mushure meizvozvo, miseve ichaonekwa mumusoro weiyo imwe neimwe column yearray.

4. Dzvanya LMB pane chero museve kuti uwedzere runyorwa rwemasefa aripo.
5. Bvisa macheki kubva kune zvakakosha mumitsetse inodiwa. Kuti usunungure mutsara usina chinhu, iwe uchada kutsanangura nhamba yayo ye serial mutafura yetafura.

6. Tarisa mhinduro. Mushure mekudzvanya pakanzi "OK", shanduko dzinofanira kuitika, uye izvo zvakasarudzwa zvinofanirwa kubviswa.

Teerera! Iyo data iri muakaunganidzwa tafura array inogona kukurumidza kusefa neakasiyana maitiro. Semuyenzaniso, neruvara rwesero, nemazuva, nemazita emakoramu, zvichingodaro. Ruzivo urwu rwakatsanangurwa mubhokisi rekusarudza sefa.

mhedziso

Saka, muMicrosoft Office Excel, kusunungura mitsara yakavanzika mutafura iri nyore. Iwe haufanirwe kuve wepamberi Excel mushandisi kuita izvi. Zvakakwana kushandisa imwe yenzira dziri pamusoro apa, iyo inoshanda pasinei neshanduro yepurogiramu.