Delete yakavanzika mitsara muExcel. Imwe uye zvese kamwechete

MuMicrosoft Office Excel, unogona kukurumidza kubvisa akavanzika, mitsara isina chinhu inopambadza kutaridzika kweyadhia. Maitiro ekuita izvi zvichaudzwa muchinyorwa chino.

Maitiro Ekuzivisa Kwazvo Nzvimbo Dzakavanzika Mukuratidzira

Pane nzira dzinoverengeka dzekuita kuti basa riitwe uchishandisa standard chirongwa zvekushandisa. Tevere, izvo zvinowanzoitika kwavari zvichakurukurwa.

Nzira 1. Maitiro ekubvisa mitsara patafura imwe kuburikidza nemusoro menyu

Kuti utsungirire nekuvhiya uku, zvinokurudzirwa kushandisa iyo inotevera algorithm:

1. Sarudza mutsara waunoda we tafura yakarongeka yeiyo lkm.
2. Dzvanya pane chero nzvimbo iyo yakagoverwa nzvimbo kurudyi-tinya.
3. Mune mamiriro emamenyu, tinya pane izwi rekuti "Delete ...".

Nzira yekudzvanywa hwindo remasero muMicrosoft Office Excel

1. Muwindo rinovhura, isa chando chinachinja padyo ne "tambo" paramende uye tinya pane zvakanaka.

Sarudza sarudzo chaiyo kuti ubvise mutsara patafura

1. Tarisa uone mhedzisiro yacho. Tambo yakasarudzwa inofanira kunge isina kuvharwa.
2. Ita izvi maitiro nezvimwe zvinhu zveposvo.

Nzira 2. Imwechete isina kusarudzika tambo kuburikidza nesarudzo mune yechirongwa tepi

Excel ine zvigadziko zvemidziyo yekubvisa tafura masero emasero. Kuti uvashandise kuti ubvise mitsara, iwe unofanirwa kuita seizvi:

1. Sarudza chero sero mumutambo waunoda kudzima.
2. Enda kune "Imba" tab mune excel yepamusoro panel.
3. Tsvaga iyo Delete bhatani uye isaira iyi sarudzo nekudzvanya pamukuru kurudyi.
4. Sarudza sarudzo "Delete mitsara kubva papepa".

Algorithm yekudzimwa kwemutsara wakasarudzwa kubva kune yakashanda pepa kuburikidza neyakajairika chirongwa chechirongwa

1. Ita shuwa kuti stitch yakasarudzwa kare yaive isina kuvharwa.

Maitiro 3. Maitiro ekubvisa zvese zvakavanzika mitsara pakarepo

Iko kudengenyeka kunoitawo mukana weboka risina kusarudzika kwezvinhu zvakasarudzwa zvezvinhu zvakasarudzwa zvekutakura tafura. Iyi sarudzo inokutendera kuti ubvise mitsara isina chinhu yakapararira munzvimbo dzakasiyana dzeplate. Kazhinji, maitiro asina kunaka akapatsanurwa mune inotevera nhanho:

1. Nehurongwa hwakafanana, swachinja kuTabha Home Tab.
2. Munzvimbo inovhura, mu "Editing" chikamu "tinya pane" Tsvaga uye kugovera "bhatani.
3. Mushure mekuita zvakapfuura chiito, mamiriro emusoro achaonekwa, mune iyo mushandisi anozoda kudzvanya pamutsetse "kusarudza boka remasero ...".

Kugoverwa kwemitsetse yese isina chinhu mune array nekukurumidza kuburikidza ne "Tsvaga uye kugovera" sarudzo muExcel

1. Muwindo rakaratidzwa, iwe unofanirwa kusarudza zvinhu kuti zviratidze. Mumamiriro ezvinhu aya, iwe unofanirwa kuisa iyo tggle switch inotevera kune "isina chinhu cell" paramende uye tinya pane "ok". Iye zvino muTafura yeTafura inofanira kujairika zvinhu zvese zvisina chinhu zvisinei nenzvimbo yavo.

Kusarudzwa kwemitsetse isina chinhu muwindo rekusarudza remapoka mapoka

1. Right-Key Manipulator Dzvanya pane chero yemitsetse yakasarudzwa.
2. MuCommukati Window Window Window, tinya pane izwi rekuti "Delete ..." uye sarudza iyo "tambo" sarudzo ". Mushure mekudzvanya pane "Zvakanaka", zvinhu zvese zvakavanzika hazvizivikanwe.

Boka risingaverengeki zvakavanzika zvinhu

Ndiro ine chimiro chakaputsika muExcel nzira 4. Kushandiswa kwekugadzirisa

Iyo chaiyo nzira inoitwa maererano neinotevera algorithm:

1. Sarudza iyo tafura cap. Iyi nharaunda umo data richagadziriswa.
2. MuTabha yeimba yeTab, bvisa rudzi uye filter subsection.
3. Muwindo rinoonekwa, sarudza sarudzo "inowanzogadziriswa kurongedza" nekudzvanya pairi neLKM.

Nzira yepahwindo yekugadzirisa tsika

1. Mune menyu yeiyo inogadziriswa yekugadzirisa, isa cheki chiratidzo pamberi peiyo "data rangu" paramende rine misoro.
2. Muclumn, taura chero sarudzo dzekugadzirisa: kana "kubva kuZ" kana "kubva kwandiri kusvika kune".
3. Pakupera kwekugadzirisa mamiriro, tinya pane "OK" pazasi pewindo. Mushure meizvozvo, iyo data iri muTafura Array icharongedzwa neiyo yakatarwa.

Zvinodiwa zviito mumenyu yeiyo inogadziriswa kuronga

1. Maererano nehurongwa hwakakurukurwa muchikamu chakapfuura chechinyorwa, govera mitsara yese yakavanzika uye kudzima.

Kugadzirisa kukosha kunofumura mitsara yese isina chinhu kusvika kumagumo emupiro.

Uninstalling mitsara isina chinhu, iyo yairamba ichitenderedza kusvika kumagumo etafura yakarongedza nzira yayo yekugadzirisa 5. Nyorera faira

Mukuridza matafura, zvinokwanisika kuendesa iyo yakataurwa yakarongedzwa, ichingosiya chete ruzivo rwunodiwa mariri. Nenzira iyi iwe unogona kubvisa chero tambo kubva patafura. Izvo zvakakosha kuti uite zvinoenderana nealgorithm:

1. Kiyi yeruboshwe yeanipulator iri kuratidza musoro wenyaya.
2. Enda kune "chikamu che data, chiri pamusoro pemenyu huru yechirongwa.
3. Dzvanya bhatani re "Filter". Pashure paizvozvo, miseve ichaonekwa mumusoro werudzi rwese rwevarongeka.

Kuisa iyo firita kune iyo tafura yekubva muExcel

1. Dzvanya iyo LKM pane chero museve kuti ubvise rondedzero yemashopu inowanikwa.
2. Bvisa cheki kubva kune tsika mumitsetse yaunoda. Kusunungura tambo isina chinhu, iwe uchafanirwa kutsanangura huwandu hwayo hwekutevedzana muTafura aronga.

Kubvisa mitsara isina kukodzera neFiltration nzira

1. Tarisa uone mhedzisiro yacho. Mushure mekudzvanya pa "Zvakanaka", shanduko dzinofanira kuiswa musimba, uye zvinhu zvakasarudzwa zvichabviswa.

Mhedziso

Nekudaro, muMicrosoft Office Excel Uninstall mitsara yakavanzika patafura iri nyore zvakakwana. Izvi hazvidikanwe kuve mushandisi ane ruzivo. Izvo zvinokwana kushandisa imwe yenzira dziri pamusoro apa dzinoshanda dzakazvimirira dzeSoftware Shanduro.

Mharidzo Bvisa nzvimbo dzakavanzika muExcel. Imwe uye zvese zvakabva zvaonekwa pakutanga pane tekinoroji yeruzivo.