3 Nzira dzekuchinja Hunhu Nyaya muExcel 2013, 2010 uye 2007

Muchinyorwa chino, ini ndoda kukuudza nezve nzira dzinoverengeka dzekuchinja nyaya yemavara muExcel kubva kumusoro kuenda kuzasi kana mashandisiro ezwi rimwe nerimwe. Iwe uchadzidza maitiro ekuita nemabasa akadaro nerubatsiro rwemabasa KUTONGA и CHIDUKU, uchishandisa VBA macros, uye zvakare uchishandisa Microsoft Word.

Dambudziko nderekuti Excel haipe yakakosha chishandiso chekushandura nyaya yezvinyorwa pane pepa rebasa. Chinoramba chiri chakavanzika nei Microsoft yakapa Shoko chinhu chine simba kudaro uye haina kuriwedzera kuExcel. Izvi zvaizoita kuti mabasa mazhinji ave nyore kune vazhinji vashandisi. Asi usamhanye kupenengura kunyorazve ese mameseji data etafura yako nemaoko! Sezvineiwo, kune dzimwe nzira dzakanaka dzekushandura hunhu hwemavara mumaseru kuenda kumusoro kana kuzasi makesi, kana kuita capitalize izwi rega rega. Rega ndikuudze nzira idzi.

• Excel inoshanda kushandura mameseji kesi
• Chinja zvinyorwa zvekunyoresa uchishandisa Microsoft Word
• Inochinjika kesi uchishandisa VBA macro

Excel inoshanda kushandura mameseji kesi

Microsoft Excel ine matatu makuru maficha aunogona kushandisa kushandura nyaya yezvinyorwa. it PAMUSORO (VAKANYORWA), CHIDUKU (PASI) uye ZVAKAITIKA (PROPANACH).

• basa PAMUSORO (UPPER) inoshandura mavara madiki kuti ave makuru.
• basa CHIDUKU (KUDZIDZA) kunoita kuti mavara makuru ave madiki.
• basa PROVia (PROPER) inoisa mavara ekutanga ezwi rega rega uye madiki mamwe ese.

Ese matatu emabasa aya anoshanda nenzira imwechete, saka ini ndichakuratidza kuti rimwe rawo rinoshanda sei. Ngatitorei basa semuenzaniso PAMUSORO (VAKANYORWA):

Kuisa formula muExcel

0. Isa mutsara mutsva (mubatsiri) padivi peiyo ine mavara aunoda kushandura.

Cherechedza: Danho iri nderokusarudza. Kana iyo tafura isiri yakakura, unogona kungoshandisa chero iri padyo isina chinhu column.

0. 
1. Isa chiratidzo chakaenzana (=) uye zita rekuita PAMUSORO (UPPER) kune sero riri padyo nekoromo itsva (B3).
2. Mumabhuraketi mushure mezita rebasa, isa yakakodzera cell reference (C3). Fomula yako inofanira kutaridzika seizvi:

   =UPPER(C3)

   =ПРОПИСН(C3)

   apo C3 ndiro sero rine mavara anofanira kushandurwa.

   

3. dzvanya pinda.Mufananidzo uri pamusoro unoratidza kuti muchitokisi B3 ine zvinyorwa zvakafanana nezviri mukati C3, nemabhii makuru chete.

Kopa fomula pasi pekoramu

Iye zvino iwe unofanirwa kukopa fomura kune mamwe ebetsero makolamu maseru:

4. Sarudza sero neformula.
5. Hover your mouse pointer pamusoro pediki diki (autofill marker) mukona yekurudyi yerudyi rwesero rakasarudzwa kuitira kuti chinongedzo chishanduke kuita muchinjikwa mutema.
6. Dzvanya uye bata pasi bhatani rekuruboshwe uye dhonza fomula pasi nemaseru ese kwaunoda kuikopa.
7. Regedza bhatani rembeva.

Cherechedza: Kana iwe uchida kuzadza zvizere koromo itsva (kusvika paurefu hwakazara hwetafura), saka unogona kusvetuka nhanho 5-7 uye kungodzvanya kaviri pane autofill marker.

Kubvisa chikamu chebetsero

Saka, iwe une makoramu maviri ane yakafanana mameseji data, anosiyana chete kana zvichiitika. Ini ndinofungidzira kuti iwe unoda kusiya chikamu nesarudzo yaunoda chete. Ngatitevedzerei kukosha kubva kuchikamu chemubatsiri uye tibvise.

8. Sarudza maseru ane formula uye tinya Ctrl + Ckuvakopa.
9. Tinya-kurudyi pachisero chekutanga muchikamu chekutanga.
10. Mumenu yezvinyorwa pasi Paste Options (Namira Sarudzo) sarudza Values (Values).Sezvo isu tichingoda zvinyorwa zvemavara chete, isu tichasarudza iyi sarudzo kuti tidzivise zvikanganiso mumafomula mune ramangwana.
11. Tinya-kurudyi pane chero sero yekoramu yekubatsira uye sarudza rairo kubva pane yemukati menyu Kudzima (Delete).
12. Mubhokisi rehurukuro Kudzima (Delete Cells) sarudza sarudzo Koramu yese (Column) uye tinya OK.

Yakaitwa!

Mukutaura, izvi zvingaita sezvakanyanya kuoma. Zorora uye edza ese aya matanho uri wega. Iwe uchaona kuti kuchinja kesi neExcel mabasa hakuna kuoma zvachose.

Chinja nyaya yezvinyorwa muExcel uchishandisa Microsoft Word

Kana iwe usingade kuvhiringa nemaformula muExcel, unogona kushandura kesi muIzwi. Heino mashandiro anoita nzira iyi:

1. Sarudza huwandu hwepaExcel worksheet yaunoda kushandura iyo text case.
2. dzvanya Ctrl + C kana kudzvanya-kurudyi uye sarudza murairo kubva pane zviri mukati menyu mufananidzo (Kopi).
3. Gadzira gwaro idzva reShoko.
4. dzvanya Ctrl + V kana kudzvanya-kurudyi pane peji isina chinhu uye sarudza rairo kubva pane yemukati menyu kudya (Insert). Tafura yeExcel ichakopwa kuIzwi.
5. Sarudza mavara aunoda kushandura kesi.
6. Pa Advanced tabo Home (Kumba) muchikamu Font (Font) tinya icon Change Case (Register).
7. Sarudza imwe ye5 kesi sarudzo kubva pane yekudonha-pasi runyorwa.

Cherechedza: Mukuwedzera, iwe unogona kudzvanya musanganiswa Shift + F3kusvikira manyorerwo aidiwa aiswa. Nemakiyi aya, unogona kusarudza chete epamusoro neakaderera makesi, pamwe nekesi semumitsara.

Iye zvino une tafura muShoko ine zvinyorwa zvinyorwa zvakachinjwa. Ingoikopa woiisa munzvimbo yayo yekutanga muExcel.

Chinja text case neVBA macro

Iwe unogonawo kushandisa VBA macros muExcel 2010 uye 2013. Usanetseka kana ruzivo rwako rweVBA ruchisiya zvakawanda zvingadiwa. Ini ndanga ndisingazive zvakawanda nezve izvi nguva yadarika, uye ikozvino ndinogona kugovera matatu akareruka macros anoshandura kese yemavara kune makuru, madiki, kana capitalize izwi rega rega.

Ini handisi kuzosiya musoro uye kukuudza nzira yekuisa nekumhanyisa VBA kodhi muExcel, sezvo izvi zvinotsanangurwa zvinoshamisa mune zvimwe zvinyorwa pane yedu saiti. Ini ndichangoratidza macros aunogona kukopa nekunamira mubhuku rako.

• Kana iwe uchida kushandura mavara kuti ave makuru, shandisa inotevera VBA macro:

Sub Uppercase() Yesero Imwe neimwe Mukusarudza Kana Isiri Cell.HasFormula Then Cell.Value = UCase(Cell.Value) End Kana Next Cell End Sub

• Kuti uise tsamba shoma kune data rako, shandisa kodhi inoratidzwa pazasi:

Sub Lowercase() Yesero Imwe neimwe Mukusarudza Kana Isiri Cell.HasFormula Ipapo Cell.Value = LCase(Cell.Value) End Kana Inotevera Cell End Sub

• Heino macro inoita kuti mazwi ese ari murugwaro atange nebhii guru:

Sub Propercase() Yesero rega rega Irikusarudzwa Kana Isiri Cell.HasFormula Then Cell.Value = _ Application _ .WorksheetFunction _ .Yakakodzera(Cell.Value) End Kana Next Cell End Sub

Ndinovimba kuti ikozvino zvaunoziva akati wandei manomano ekuchinja kesi muExcel, basa iri richakuitira nyore. Excel mabasa, Microsoft Shoko, VBA macros anogara ari pabasa rako. Pane zvishoma zvasara kuti uite - sarudza kuti ndezvipi zvezvishandiso izvi zvaunoda zvakanyanya.