Maitiro ekunyora mabhii ese muExcel. Nzira mbiri dzekutsiva maLowercase Letters neUppercase Letters muExcel

Vanhu vanoshanda nesimba muExcel vanowanzo gadzirira mishumo yeakasiyana masangano ehurumende, vanogara vachisangana nemamiriro ezvinhu apo zvinyorwa zvese kubva mugwaro, zvakanyorwa nemavara akajairwa, zvinoda kutsiviwa nemavara makuru. Unogona kuita izvi pachine nguva kana mashoko acho asati anyorwa. Ingo dzvanya "CapsLock" uye zadza maseru ese anodiwa nemavara makuru. Nekudaro, kana tafura yatove yakagadzirira, kushandura zvese nemaoko kune dambudziko, pane njodzi huru yekukanganisa. Kugadzirisa maitiro aya, unogona kushandisa imwe yenzira mbiri dziripo dzeExcel.

Maitiro ekushandura mavara madiki kuenda kune makuru

Kana tikaenzanisa maitirwo emaitiro aya muIzwi neExcel, mupepeti yemavara, zvinokwana kuita mashoma mabhatani kutsiva ese akajairwa mavara nemavara makuru. Kana tikataura nezvekuchinja data mutafura, zvese zvakanyanya kuomarara pano. Pane nzira mbiri dzekushandura mavara madiki kuita makuru:

1. Kuburikidza neyakakosha macro.
2. Kushandisa basa - UPPER.

Kuti udzivise chero matambudziko mukugadzirisa ruzivo, nzira mbiri dzinofanirwa kutariswa zvakadzama.

Ne macro

A macro chiitiko chimwe chete kana musanganiswa wavo unogona kuitwa nhamba huru yenguva. Muchiitiko ichi, zviito zvakawanda zvinoitwa nekudzvanya kiyi imwe chete.. Paunenge uchigadzira macros, keyboard uye mbeva makiyi anoverengwa.

Zvinokosha! Kuti iyo macro idzore mavara madiki nemavara makuru kuti ashande, iwe unofanirwa kutanga watarisa kana iyo macro function yakavhurwa muchirongwa kana kwete. Kana zvisina kudaro, nzira yacho ichava isina maturo.

Nzira:

1. Pakutanga, unofanirwa kumaka chikamu chepeji, chinyorwa chaunoda kuchinja. Kuti uite izvi, unogona kushandisa mbeva kana keyboard.

2. Kana kusarudzwa kwapera, unofanirwa kudzvanya kiyi yekubatanidza "Alt + F11".
3. Iyo macro editor inofanira kuonekwa pachiratidziro. Mushure meizvozvo, iwe unofanirwa kudzvanya inotevera kiyi musanganiswa "Ctrl + G".
4. Munzvimbo yakavhurwa yemahara "pakarepo" zvakakosha kunyora mutsara unoshanda "yega yega c mukusarudzwa:c.value=ucase(c):inotevera".

Chiito chekupedzisira kudzvanya bhatani rekuti "Enter". Kana mavara akaiswa nemazvo uye pasina kukanganisa, mavara madiki ese ari muchikamu chakasarudzwa anoshandurwa kuita mavara makuru.

Kushandisa UPPER basa

Chinangwa che UPPER basa ndechekutsiva mavara akajairwa nemavara makuru. Iine formula yayo: = UPPER (Variable text). Mune nharo chete yebasa iri, unogona kutsanangura 2 kukosha:

• zvinorongeka zvesero rine chinyorwa chinofanira kuchinjwa;
• mabhii anofanira kuchinjwa kuva mavara makuru.

Kuti unzwisise kuti ungashanda sei nebasa iri, zvakakosha kufunga nezvemumwe wemienzaniso inoshanda. Kunobva kunenge kuri tafura ine zvigadzirwa zvine mazita akanyorwa nemavara madiki, kunze kwemavara makuru ekutanga. Maitiro:

1. Maka neLMB nzvimbo iri patafura ichaunzwa basa racho.
2. Tevere, iwe unofanirwa kudzvanya bhatani rekuwedzera iyo "fx" basa.

3. Kubva pane Function Wizard menyu, sarudza iyo "Text" runyorwa.
4. Rondedzero yezvinyorwa zvemavara ichaonekwa, kubva paunoda kusarudza UPPER. Simbisa sarudzo nebhatani rekuti "OK".

5. Mufafitera renharo yebasa rinovhurwa, panofanirwa kuve nenzvimbo yemahara inonzi "Text". Mariri, iwe unofanirwa kunyora kurongeka kwesero rekutanga kubva pane rakasarudzwa, kwaunoda kutsiva akajairwa mavara nemavara makuru. Kana maseru akapararira kutenderedza tafura, iwe uchafanirwa kutsanangura macoordination emumwe nemumwe wavo. Dzvanya bhatani rekuti "OK".
6. Iwo mameseji atoshandurwa kubva musero, izvo zvinorongeka zvakatsanangurwa munharo yebasa, zvicharatidzwa musero rakafanosarudzwa. Mavara madiki ese anofanira kushandurwa kuita mavara makuru.
7. Zvadaro, unofanirwa kuisa chiito chebasa kune imwe neimwe sero kubva pane yakasarudzwa. Kuti uite izvi, unofanirwa kunongedza chitubu pachisero chine chinyorwa chakashandurwa, kumirira kusvikira muchinjikwa mutema uchionekwa mumucheto wayo wekuruboshwe. Dzvanya pairi neLMB, zvishoma nezvishoma dhonza pasi maseru akawanda sezvaunoda kushandura data mukati.

8. Mushure meizvozvo, koramu yakaparadzana ine ruzivo rwakatochinja inofanira kuoneka.

Nhanho yekupedzisira yebasa ndeyekutsiviwa kwekutanga kwemasero neiyo yakazobuda mushure mekunge zviito zvese zvapera.

1. Kuti uite izvi, sarudza maseru ane ruzivo rwakachinja.
2. Tinya-kurudyi pane rakasarudzwa, sarudza iyo "Copy" basa kubva pane yemukati menyu.
3. Nhanho inotevera ndeyekusarudza koramu ine ruzivo rwekutanga.
4. Dzvanya bhatani rekurudyi rembeva kuti ufonere menyu yemukati.
5. Muchinyorwa chinooneka, tsvaga "Paste Options" chikamu, sarudza sarudzo - "Values".
6. Mazita ese ezvigadzirwa akataridzwa achatsiviwa nemazita akanyorwa nemavara makuru.

Mushure mezvose zvakatsanangurwa pamusoro apa, hatifaniri kukanganwa pamusoro pekudzima mutsara wakapinda fomu, iyo yakashandiswa kugadzira ruzivo rutsva. Kana zvisina kudaro, ichavhiringidza kutarisa, kutora nzvimbo yakasununguka. Kuti uite izvi, unofanirwa kusarudza imwe nzvimbo nekubata pasi bhatani rekuruboshwe, tinya-kurudyi pane yakasarudzwa. Sarudza "Delete" kubva pane zviri mukati menyu.

mhedziso

Pakusarudza pakati pekushandisa macro kana UPPER basa, vanotanga vanowanzofarira macros. Izvi zvinokonzerwa nekushandisa kwavo nyore. Nekudaro, macros haana kuchengetedzeka kushandisa. Kana yaitwa, gwaro rinova panjodzi yekurwiswa kwehacker, nekuda kweizvi, zvinokurudzirwa kudzidza mashandisiro eiyo UPPER basa.