Tsvaga uye Kutsiva muExcel chishandiso chine simba uye chiri nyore chinokutendera kuti uwane, uye, kana zvichidikanwa, tsiva ruzivo pane pepa rebasa. Sechikamu chechidzidzo ichi, iwe uchadzidza kutsvaga munzvimbo yakapihwa yeExcel gwaro, pamwe nekushandura ruzivo rwakawanikwa kune yaunoda kukosha.
Paunenge uchishanda nehuwandu hwe data muExcel, dzimwe nguva zvakaoma kuwana chero ruzivo rwakananga. Uye, sekutonga, kutsvaga kwakadaro kunotora nguva yakareba kwazvo. Excel inopa chishandiso chikuru chekutsvaga. Unogona kuwana zviri nyore chero ruzivo rwaunoda mubhuku rekushanda reExcel uchishandisa iyo Tsvaga kuraira, iyo inobvumidza iwe kuti uchinje iyo data uchishandisa Tsvaga uye Kutsiva chishandiso.
Kutsvaga Dhata muExcel Masero
Mumuenzaniso wedu, isu tichashandisa iyo Tsvaga kuraira kuti uwane zita raunoda murunyorwa rurefu rwevashandi.
Kana ukasarudza sero rimwe chete usati washandisa iyo Tsvaga command, Excel ichatsvaga bepa rese rebasa. Uye kana huwandu hwemasero, saka chete mukati merudzi urwu
- PaKumba tebhu, shandisa Tsvaga uye Sarudza kuraira, uye wobva wasarudza Tsvaga kubva pane yekudonhedza pasi.
- Iyo Tsvaga uye Kutsiva dialog box inooneka. Isa iyo data ichatsvakwa. Mumuenzaniso wedu, tichaisa zita remushandi.
- Click Find Next. Kana data iripo pane pepa, ichasimbiswa.
- Kana ukadzvanya bhatani re Tsvaga Inotevera zvakare, uchaona sarudzo inotevera yekutsvaga. Iwe unogona zvakare kusarudza Tsvaga Zvese kuti uone ese sarudzo dzawanikidzwa neExcel kwauri.
- Kana wapedza kutsvaga, shandisa bhatani reKuvhara kubuda mubhokisi rebhokisi reKutsvaga uye Kutsiva.
Iwe unogona kuwana iyo Tsvaga kuraira neiyo keyboard nzira yekudimbudzira Ctrl+F.
Kuti uone zvimwe Tsvaga uye Tsiva sarudzo, tinya bhatani reSarudzo mu Tsvaga uye Tsiva dialog box.
Kutsiva maseru zvirimo muExcel
Pane dzimwe nguva apo kukanganisa kunoitwa kunodzokororwa mukati meExcel workbook. Somuenzaniso, zita romumwe munhu haripererwi, kana kuti rimwe shoko kana kuti chirevo chinoda kuchinjwa kuti chive chimwe. Unogona kushandisa Tsvaga uye Kutsiva chishandiso kukurumidza kugadzirisa. Mumuenzaniso wedu, tichashandisa Replace command kugadzirisa rondedzero yemakero eemail.
- PaKumba tebhu, tinya Tsvaga uye Sarudza, wobva wasarudza Tsiva kubva pane yekudonhedza pasi.
- Iyo Tsvaga uye Kutsiva dialog box inooneka. Isa zvinyorwa zvauri kutsvaga mundima yekutsvaga.
- Nyora mavara aunoda kutsiva akawanikwa mavara muReplace nebhokisi. Wobva wadzvanya Find Next.
- Kana kukosha kwawanikwa, sero rine mariri richaratidzwa.
- Tarisa chinyorwa uye ita shuwa kuti wabvuma kuchitsiva.
- Kana uchibvuma, sarudza imwe yedzimwe sarudzo dzekutsiva:
- Tsiva: Inogadzirisa kukosha kumwe panguva.
- Tsiva Zvese: Inogadzirisa ese akasiyana ezvinyorwa zvakatsvakwa mubhuku rebasa. Mumuenzaniso wedu, tichashandisa iyi sarudzo kuchengetedza nguva.
- Bhokisi renhaurirano richaonekwa richisimbisa nhamba yezvinotsiva zvichaitwa. Dzvanya OK kuti uenderere mberi.
- Zviri mukati memasero zvichatsiviwa.
- Kana wapedza, tinya Close kuti ubude mu Tsvaga uye Tsiva dialog box.