Nika amandla, khubaza, futhi ulungiselele i-AutoCorrect ku-Excel

Ngenkathi usebenza kumaspredishithi e-Excel, ikakhulukazi uma kufanele ubhekane nenani elikhulu ledatha, kukhona ithuba lokwenza iphutha, njenge-typo. Futhi, abanye abasebenzisi, ngenxa yokuthi abazi ukuthi bangathola kanjani futhi basebenzise izinhlamvu ezikhethekile, banquma ukuzifaka esikhundleni sazo eziqondakalayo nezifinyelelekayo. Ngokwesibonelo, esikhundleni sophawu “- – incwadi evamile "No", noma esikhundleni salokho “$” - umane "S". Nokho, sibonga ithuluzi elikhethekile "AutoCorrect" izinto ezinjalo zilungiswa ngokuzenzakalelayo.

Yini i-AutoCorrect

I-Excel igcina enkumbulweni yayo uhlu lwamaphutha ajwayelekile angenziwa. Uma umsebenzisi efaka iphutha kulolu hlu, uhlelo luzofaka inani elilungile esikhundleni salo ngokuzenzakalelayo. Yilokhu kanye okudingekayo Ukulungisa okuzenzakalelayo, futhi isebenza kanjalo.

Leli thuluzi lilungisa izinhlobo zamaphutha ezilandelayo:

• osonhlamvukazi ababili abalandelanayo egameni
• qala umusho omusha ngohlamvu oluncane
• amaphutha ngenxa ye-Caps Lock enikwe amandla
• amanye ama-typos ajwayelekile namaphutha

Nika amandla futhi ukhubaze ukulungisa okuzenzakalelayo

Kuhlelo, lo msebenzi unikwe amandla ekuqaleni, kodwa kwezinye izimo kuyadingeka ukuwukhubaza (unomphela noma okwesikhashana). Ake sithi sidinga ukwenza amaphutha ngokuqondile kwamanye amagama noma sisebenzise izinhlamvu uhlelo oluzibona njengezinephutha bese zithatha indawo yazo, nakuba singakufuni lokhu. Uma ushintsha uhlamvu olulungisa ngokuzenzakalelayo lugxiliswe kule esiludingayo, umsebenzi ngeke wenziwe esikhundleni futhi. Le ndlela ngokuqinisekile ifaneleka kumacala angawodwa. Uma kungenjalo, ukonga isikhathi nomzamo, isixazululo esingcono kakhulu kungaba ukukhubaza umsebenzi "AutoCorrect".

1. Iya kumenyu "Fayela".
2. Kumenyu eseceleni kwesokunxele, yiya ku "Amapharamitha".
3. Ewindini lezilungiselelo elivulekayo, chofoza isigatshana "Isipelingi". Ngakwesokudla sewindi, chofoza inkinobho "Izinketho Zokulungisa Okuzenzakalelayo".
4. Iwindi elinezilungiselelo zokusebenza lizovezwa esikrinini. Susa ukumaka ibhokisi eduze kwenketho "Faka esikhundleni njengoba uthayipha", bese uchofoza OK.
5. Uhlelo luzosibuyisela efasiteleni elikhulu elinamapharamitha, lapho sicindezela khona inkinobho futhi OK.

Qaphela: ukuze uphinde wenze kusebenze umsebenzi, buyisela uphawu lokuhlola endaweni yalo, ngemva kwalokho, futhi, gcina izinguquko ngokucindezela inkinobho. OK.

Idethi yokulungisa ngokuzenzakalelayo kanye nezinkinga ezingaba khona

Kwesinye isikhathi kwenzeka ukuthi ngenkathi ufaka inombolo enamachashazi, uhlelo luyilungisela usuku. Ake sithi siyifakile inombolo 3.19 kuseli elingenalutho.

Ngemuva kokuthi sicindezele ukhiye Faka, Thola idatha ngesimo senyanga nonyaka.

Sidinga ukulondoloza idatha yoqobo esiyifake kuseli. Ezimweni ezinjalo, asikho isidingo sokuvala ukulungisa okuzenzakalelayo. Nakhu esikwenzayo:

1. Okokuqala, khetha uhla lwamaseli lapho sifuna ukwengeza khona ulwazi oludingekayo ngendlela yezinombolo ezinamachashazi. Bese kuba kuthebhu "Ikhaya" iya esigabeni samathuluzi "Inombolo", lapho sichofoza inketho yefomethi yeseli yamanje.
2. Ohlwini lokudonsela phansi, khetha into "Umbhalo".
3. Manje sesingakwazi ukufaka idatha ngokuphephile kumaseli ngendlela yezinombolo ezinamachashazi.Qaphela: udinga ukukhumbula ukuthi izinombolo kumaseli anefomethi yombhalo azikwazi ukubamba iqhaza ekubaleni, ngoba zibonwa uhlelo ngendlela ehlukile futhi umphumela wokugcina uzohlanekezelwa.

Ukuhlela isichazamazwi esilungisa ngokuzenzakalelayo

Njengoba sishilo ekuqaleni, inhloso yokulungisa ngokuzenzakalelayo ukusiza ukulungisa amaphutha noma ukuthayipha. Uhlelo ekuqaleni luhlinzeka ngohlu olujwayelekile lwamagama afanayo nezimpawu zokushintshwa, noma kunjalo, umsebenzisi unethuba lokwengeza izinketho zakhe.

1. Futhi singena efasiteleni ngamapharamitha aqondile, aqondiswa izinyathelo ezichazwe ngenhla (imenyu "Fayela" - ingxenye "Amapharamitha" – isigatshana "Isipelingi" - Inkinobho "Izinketho Zokulungisa Okuzenzakalelayo").
2. In the "Faka esikhundleni" sibhala uphawu (igama), elizophinde likhonjwe uhlelo njengephutha. Ensimini "Kuvuliwe" cacisa inani elizosetshenziswa njengokumiselela. Uma usulungile, cindezela inkinobho "Faka".
3. Ngenxa yalokho, singakwazi ukwengeza kulesi sichazamazwi wonke ama-typos avamile namaphutha esiwenza (uma engekho ohlwini lwangempela), ukuze singachithi isikhathi ekulungiseni kwawo okwengeziwe.

Ukushintshwa okuzenzakalelayo ngezimpawu zezibalo

Iya kuthebhu yegama elifanayo ezinkethweni zokulungisa ngokuzenzakalelayo. Lapha sizothola uhlu lwamanani oluzothathelwa indawo uhlelo ngezimpawu zezibalo. Lolu khetho luwusizo kakhulu uma udinga ukufaka uhlamvu olungekho kukhibhodi. Isibonelo, ukufaka umlingiswa "alpha" (alpha), kuzokwanela ukuthayipha "alpha", ngemva kwalokho uhlelo lungena esikhundleni senani elinikeziwe ngohlamvu oludingekayo. Ezinye izinhlamvu zifakwa ngendlela efanayo.

Futhi, ungakwazi ukwengeza izinketho zakho kulolu hlu.

Isusa inhlanganisela ekulungiseni okuzenzakalelayo

Ukuze ususe inhlanganisela engadingekile yamagama noma izimpawu ohlwini olulungisa ngokuzenzakalelayo, vele uyikhethe ngokuchofoza igundane, bese ucindezela inkinobho. "Susa".

Futhi, ngokugqamisa umdlalo othile, esikhundleni sokuwususa, ungamane ulungise enye yezinkambu zayo.

Ukusetha amapharamitha ayinhloko wokushintshwa okuzenzakalelayo

Imingcele eyinhloko ihlanganisa zonke izilungiselelo ezingenziwa kuthebhu "AutoCorrect". Izinketho ezilandelayo ziqale zenziwe zisebenze ohlelweni:

• ukulungiswa kwezinhlamvu ezimbili ezinkulu (osonhlamvukazi) ekuqaleni kwegama;
• bhala ngosonhlamvukazi uhlamvu lokuqala lomusho;
• ukubhala ngosonhlamvukazi izinsuku zesonto;
• ukuqedwa kwamaphutha abangwe okhiye abacindezelwe ngephutha Bheka Ofeleba.

Ukuze uvale lezi zinketho, vele ususe ukumaka ibhokisi eliseduze kwazo, bese uchofoza inkinobho OK ukusindisa izinguquko.

Ukusebenza ngokuhlukile

Lolu hlelo lunesichazamazwi esikhethekile esigcina amagama nezimpawu lapho ukulungiswa kwe-autocorrect kungeke kusebenze, noma ngabe lo msebenzi unikwe amandla futhi kukhona ukufana okudingekile kumapharamitha ayinhloko.

Ukuze ufinyelele lesi sichazamazwi, chofoza inkinobho "Okuhlukile".

Iwindi elivelayo linamathebhu amabili:

Incwadi yokuqala

• Nalu uhla lwamagama alandelwa uphawu "khomba" (".") akufanele kuhunyushwe uhlelo ngokuthi isiphetho somusho, okusho ukuthi igama elilandelayo lizoqala ngohlamvu oluncane. Ngokuyisisekelo, lokhu kusebenza kuzo zonke izinhlobo zezifinyezo, isibonelo, kg., g., rub., iphoyisa. njll.
• Emkhakheni ongaphezulu, singafaka inani lethu, elizongezwa ohlwini lokukhishwa ngemuva kokuchofoza inkinobho ehambisanayo.
• Futhi, ngokukhetha inani elithile ohlwini, ungalihlela noma ulisuse.

Osonhlamvukazi ABABILI

Amanani asuka kuhlu kule thebhu, afana nohlu olukuthebhu “Incwadi yokuqala”, ngeke ithintwe i-AutoCorrect. Lapha singakwazi futhi ukwengeza, ukulungisa noma ukususa izakhi ezintsha.

Isiphetho

Sibonga umsebenzi "AutoCorrect" umsebenzi ku-Excel uyasheshiswa kakhulu, njengoba uhlelo lulungisa ngokuzenzakalelayo ama-typos namaphutha enziwe umsebenzisi. Leli thuluzi libaluleke kakhulu uma usebenza ngenani elikhulu ledatha. Ngakho-ke, kubaluleke kakhulu ezimweni ezinjalo ukuthi ukwazi ukusebenzisa kahle futhi ulungiselele imingcele ye-autocorrect.