Gonesa, dzima, uye gadzirisa AutoCorrect muExcel

Paunenge uchishanda muExcel spreadsheets, kunyanya kana uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge rwakakura data, pane mukana wekuita chikanganiso, senge typo. Zvakare, vamwe vashandisi, nekuda kwekuti havazive kutsvaga nekushandisa mavara akakosha, vanosarudza kuvatsiva nevanonzwisisika uye vanosvikika. Somuenzaniso, panzvimbo pechiratidzo “- - tsamba yakajairika “Uye”, kana kuti panzvimbo “$” - zvakapusa "S". Nekudaro, nekuda kwechishandiso chakakosha "AutoCorrect" zvinhu zvakadaro zvinongogadziriswa.

Chii chinonzi AutoCorrect

Excel inochengeta mundangariro rondedzero yezvikanganiso zvakajairika zvinogona kuitwa. Kana mushandisi apinda chikanganiso kubva pane iyi runyorwa, iyo purogiramu inozoitsiva neiyo chaiyo kukosha. Izvi ndizvo chaizvo zvinodiwa AutoCorrect, uye ndiwo mashandiro azvinoita.

Ichi chishandiso chinogadzirisa anotevera makuru marudzi ezvikanganiso:

• mabhii makuru maviri akatevedzana mushoko
• tanga mutsara mutsva nemavara madiki
• kukanganisa nekuda kwekugonesa Caps Lock
• zvimwe zvakajairika typos uye zvikanganiso

Bvumira uye dzima autocorrect

Muchirongwa, basa iri rinotanga rakagoneswa, asi mune dzimwe nguva rinodikanwa kuidzima (zvechigarire kana kwenguva pfupi). Ngatitii tinofanirwa kunyatso kanganisa mune mamwe mazwi kana kushandisa mavara anoonekwa nechirongwa seanokanganisa uye oatsiva, kunyangwe isu tisingade izvi. Kana iwe ukashandura hunhu hunogadzirisa zvakagadziriswa kune hwatinoda, basa racho harizoite kutsiva zvakare. Iyi nzira yakanyatsokodzera kumatare ega. Zvikasadaro, kuchengetedza nguva nekuedza, mhinduro yakanakisa ingave yekudzima basa "AutoCorrect".

1. Enda kumenyu "Faira".
2. Muparutivi menyu kuruboshwe, enda ku "Parameters".
3. Muwindo rezvirongwa rinovhurwa, tinya pane chikamu "Chiperengo". Kurutivi rworudyi rwehwindo, tinya bhatani "AutoCorrect Options".
4. Hwindo rine zvigadziriso zvebasa richaratidzwa pachiratidziri. Bvisa bhokisi riri pedyo nesarudzo “Siva sezvaunonyora”, ipapo chengeta OK.
5. Iyo purogiramu ichatidzosera kumashure kuhwindo guru rine parameters, apo isu tinodzvanya bhatani zvakare OK.

Cherechedza: kuti udzorere basa racho, dzorera cheki kunzvimbo yayo, mushure mezvo, zvakare, chengetedza shanduko nekudzvanya bhatani. OK.

Date autocorrect uye matambudziko anogona kuitika

Dzimwe nguva zvinoitika kuti paunenge uchipinda nhamba ine madotsi, chirongwa chinochigadzirisa kune zuva. Toti taisa nhamba 3.19 kuchitokisi chisina chinhu.

Tapedza tinodzvanya kiyi Pinda, Wana data muchimiro chemwedzi negore.

Isu tinofanirwa kuchengetedza iyo yekutanga data yatakaisa muchitokisi. Mumamiriro ezvinhu akadaro, hapana chikonzero chekudzima autocorrect. Hezvino zvatinoita:

1. Kutanga, sarudza huwandu hwemasero atinoda kuwedzera ruzivo rwakakosha nenzira yenhamba dzine dots. Zvadaro kuva mune tab "Kumba" enda kuchikamu chezvishandiso “Nhamba”, kwatinodzvanya pane yazvino sero fomati sarudzo.
2. Mukudonhedza pasi, sarudza chinhu “Mashoko”.
3. Iye zvino tinogona kupinda data zvakachengeteka mumaseru muchimiro chenhamba dzine madots.Cherechedza: iwe unofanirwa kuyeuka kuti nhamba mumasero ane mavara ezvinyorwa hazvigone kutora chikamu mukuverenga, sezvo ivo vanonzwisiswa nechirongwa neimwe nzira uye mhedzisiro inozokanganiswa.

Kugadzirisa duramazwi remanyorero

Sezvatakambotaura, chinangwa che autocorrect ndechekubatsira kugadzirisa zvikanganiso kana typos. Chirongwa ichi chinotanga chinopa runyoro rwemashoko anoenderana uye zviratidzo zvekutsiviwa, zvisinei, mushandisi ane mukana wekuwedzera yavo sarudzo.

1. Zvekare isu tinopinda muhwindo neiyo autocorrect paramita, inotungamirwa nematanho anotsanangurwa pamusoro (menu "Faira" - chikamu "Parameters" – chikamu "Chiperengo" - bhatani "AutoCorrect Options").
2. Mu “Tsiva” tinonyora chiratidzo (izwi), icho chichazoonekwa zvakare nechirongwa sechikanganiso. Mumunda "Pamusoro" tsanangura kukosha kunoshandiswa sechinotsiva. Kana wagadzirira, tinya bhatani "Wedzera".
3. Nekuda kweizvozvo, tinokwanisa kuwedzera kuduramazwi rino zvese zvinonyanya kutaurwa uye kukanganisa kwatinoita (kana zvisiri mugwaro rekutanga), kuti tisatambise nguva pakugadzirisa zvakare.

Autoreplacement ine masvomhu zviratidzo

Enda kune iyo tebhu yezita rimwe chete mune autocorrect sarudzo. Pano tinowana runyorwa rwezvakakosha zvinotsiviwa nechirongwa chine masvomhu zviratidzo. Iyi sarudzo inobatsira zvakanyanya kana iwe uchida kuisa chimiro chisiri pane keyboard. Somuenzaniso, kupinda hunhu "α" (alpha), zvichakwana kutaipa "alpha", mushure mezvo purogiramu inotsiva kukosha kwakapiwa neunhu hunodiwa. Mamwe mavara anopinzwa nenzira imwecheteyo.

Zvakare, iwe unogona kuwedzera sarudzo dzako kune iyi runyorwa.

Kubvisa musanganiswa kubva autocorrect

Kuti ubvise kusanganisa kusingakoshi kwemazwi kana zviratidzo kubva kune autocorrect rondedzero, ingosarudza iyo nekudzvanya mbeva, wobva wadzvanya bhatani. "Bvisa".

Zvakare, nekusimbisa imwe match, pane kuidzima, unogona kungogadzirisa imwe yeminda yayo.

Kuisa iyo huru paramita ye autoreplacement

Iwo makuru ma paramita anosanganisira ese magadzirirwo anogona kuitwa mubhu "AutoCorrect". Izvi zvinotevera zvinosarudzwa zvinotanga kushandiswa muchirongwa:

• kururamiswa kwemavara makuru maviri (capital) pakutanga kwezwi;
• nyora bhii rekutanga remutsara;
• tichishandisa mazuva evhiki;
• kubviswa kwezvikanganiso zvinokonzerwa nemakiyi akadzvanywa netsaona Caps Tarisa.

Kudzima sarudzo idzi, ingobvisa bhokisi riri padyo navo, wobva wadzvanya bhatani OK kuchengetedza kuchinja.

Kushanda pamwe chete

Iyo purogiramu ine duramazwi rakakosha rinochengeta mazwi nezviratidzo izvo autocorrect isingashande, kunyangwe basa iri rikagoneswa uye paine chinodiwa match mumikuru paramita.

Kuti uwane duramazwi iri, tinya bhatani “Kunze”.

Iwindo rinoonekwa rine ma tabo maviri:

Tsamba yekutanga

• Heino rondedzero yemashoko anoteverwa nechiratidzo “point” (".") harifaniri kududzirwa nepurogiramu semagumo emutsara, zvinoreva kuti izwi rinotevera richatanga nebhii duku. Chaizvoizvo, izvi zvinoshanda kune marudzi ese ezvipfupiso, semuenzaniso, kg., g., rub., Cop. etc.
• Mumunda wepamusoro, tinogona kuisa kukosha kwedu, iyo inozowedzerwa kune yekusarudzika runyorwa mushure mekudzvanya bhatani rinoenderana.
• Zvakare, nekusarudza imwe kukosha kubva pane iyo rondedzero, unogona kuigadzirisa kana kuidzima.

Mavara maviri makuru

Values ​​kubva pane rondedzero mune iyi tebhu, yakafanana nerondedzero iri mutebhu “tsamba yekutanga”, haizokanganiswa neAutoCorrect. Pano tinogonawo kuwedzera, kugadzirisa kana kubvisa zvinhu zvitsva.

mhedziso

Kutenda kune basa "AutoCorrect" basa muExcel rinokwidziridzwa zvakanyanya, sezvo chirongwa ichi chinogadzirisa otomatiki typos uye kukanganisa kunoitwa nemushandisi. Ichi chishandiso chinonyanya kukosha pakushanda nehuwandu hwe data. Naizvozvo, zvakakosha muzviitiko zvakadaro kukwanisa kushandisa nemazvo uye kugadzirisa iyo autocorrect paramita.