Chinthu cha Microsoft Excel AutoCorrect

Polemba zolemba zosiyanasiyana, mukhoza kupanga typo kapena kulakwitsa chifukwa cha kusadziwa. Kuwonjezera pamenepo, ena olemba pa kibokosiwo salipo, koma sikuti aliyense amadziwa kugwiritsa ntchito maonekedwe apadera, ndi momwe angagwiritsire ntchito. Choncho, ogwiritsa ntchito amaika zizindikiro zotere ndizowoneka bwino, malingaliro awo, mofananamo. Mwachitsanzo, mmalo mwa "©" iwo amalemba "(c)", m'malo mwa "€" - (e). Mwamwayi, Microsoft Excel ili ndi ntchito yosasinthika yomwe imalowetsa zitsanzo zomwe zili pamwambapa ndi zofanana, komanso zimakonza zolakwika zambiri ndi typos.

Mfundo Zomwe Zidasinthidwe

Chikumbukiro cha pulogalamu ya Excel chimasunga zolakwika zofala kwambiri m'mawu ake. Mawu aliwonsewa akufanana ndi masewero oyenera. Ngati wogwiritsa ntchitoyo asankha cholakwika, chifukwa cha typo kapena zolakwika, ndiye kuti pulojekitiyi imasinthidwa ndi njira yoyenera. Izi ndizofunikira kwambiri zogulitsa.

Zolakwitsa zazikulu zomwe ntchitoyi zikukonzekera ndizo zotsatirazi: chiyambi cha chiganizo ndi kalata yapansi, zilembo zikuluzikulu ziwiri m'mawu otsogolera, zolakwika Makapu otsegula, zizindikiro zina zosiyana ndi zolakwika.

Thandizani ndikuthandizani AutoCorrect

Tiyenera kuzindikira kuti mwachinsinsi, AutoCorrect nthawizonse amatha. Choncho, ngati nthawi zonse simukusowa ntchitoyi, ndiye kuti iyenera kukhala yolemala. Mwachitsanzo, izi zingayambitse chifukwa chakuti nthawi zambiri mumalembera mawu mwadala, kapena muwonetseni malemba omwe amadziwika kuti Excel ndi olakwika, ndipo kubwezeretsa galimoto nthawi zonse kumakonza. Ngati mutasintha chizindikiro chomwe chimakonzedweratu ndi zomwe mumagwiritsa ntchito, ndiye kuti chotsitsa chake sichidzakonzedwanso. Koma, ngati pali zowonjezera zoterezi, ndikuzilemba kawiri, mumataya nthawi. Pankhaniyi, ndibwino kuti mulephere Kudzala Mtengo Wathunthu.

  1. Pitani ku tabu "Foni";
  2. Sankhani gawo "Zosankha".
  3. Kenako, pitani ku gawolo "Kulemba".
  4. Dinani pa batani "Zosankha Zosintha".
  5. Muwindo la magawo lomwe limatsegula, yang'anani chinthucho "Bwezerani pamene mukuyimira". Sakanizeni ndipo dinani pa batani. "Chabwino".

Kuti mulowetsere AutoCorrect, motsatira, fufuzani bokosilo ndi kukanikiza batani kachiwiri. "Chabwino".

Vuto ndi tsiku la autostart

Pali milandu pamene wosuta alowetsa nambala ndi madontho, ndipo amasinthidwa patsikulo, ngakhale kuti sakulifuna. Pachifukwa ichi, sikoyenera kuti mutsekeze kusinthika kwathunthu. Pokonzekera izi, sankhani malo a maselo omwe tikuti tilembere manambala ndi madontho. Mu tab "Kunyumba" Tikuyang'ana malo osungira "Nambala". Mundandanda wotsika m'munsiyi, yikani parameter "Malembo".

Tsopano manambala ali ndi madontho sadzasinthidwa ndi masiku.

Kusintha Zojambula Zosintha

Komabe, ntchito yaikulu ya chida ichi sichimasokoneza wogwiritsa ntchito, koma m'malo momuthandiza. Kuphatikiza pa mndandanda wa mafotokozedwe omwe apangidwa kuti asinthidwe mwachisawawa, aliyense wogwiritsa ntchito akhoza kuwonjezera zomwe angasankhe.

  1. Tsegulani zenera la magawo Odziwika kale omwe amadziwika kale kwa ife.
  2. Kumunda "Bwezerani" tchulani khalidwe lomwe lidzatsimikiziridwa ndi pulogalamuyi molakwika. Kumunda "Pa" Timalemba mawu kapena chizindikiro kuti m'malo mwake. Timakanikiza batani "Onjezerani".

Choncho, mukhoza kuwonjezera zomwe mungasankhe ku dikishonale.

Kuwonjezera apo, muwindo lomwelo pali tabu "Zosintha Zachilengedwe Zamasamu". Pano pali mndandanda wamakhalidwe abwino mukalowa mmalo osinthika ndi zizindikiro za masamu, kuphatikizapo zomwe zikugwiritsidwa ntchito mu Excel ma formula. Inde, sikuti aliyense wogwiritsa ntchito adzatha kulowa chikhalidwe cha α (alpha) pa kibodiboli, koma aliyense adzatha kuika mtengo " alpha", womwe umatembenuzidwira ku khalidwe lofunidwa. Mwa kufanana, beta ( beta), ndi zizindikiro zina zalembedwa. M'ndandanda womwewo, aliyense wogwiritsa ntchito akhoza kuwonjezera masewera ake, monga momwe adasonyezera mu dikishonale yaikulu.

Ndichophweka kwambiri kuchotsa makalata aliwonse mu dikishonaleyi. Sankhani chinthu chomwe sitikusowa chokhachokha, ndipo dinani batani "Chotsani".

Kuthetsa kudzachitika nthawi yomweyo.

Zomwe zimayambira

M'ndandanda yayikulu yazigawo zosinthira ndizoyikidwa bwino kwa ntchitoyi. Mwachinsinsi, ntchito zotsatirazi zikuphatikizidwa: kukonza makalata awiri apamwamba pamzere, kuika kalata yoyamba mu chiganizo chapamwamba, mayina a masiku a sabata ndi kalata yopambana, kukonza makina osokonekera Makapu otsegula. Koma, ntchito zonsezi, kuphatikizapo zina mwa izo, zikhoza kutsekedwa mwa kungosinthanitsa zosankha zomwe mukugwirizana nazo ndi kupanikiza batani. "Chabwino".

Kupatulapo

Kuphatikizanso, chidziwitso cha AutoCorrect chili ndichinsinsi chake. Lili ndi mawu ndi zizindikiro zomwe siziyenera kusinthidwa, ngakhale ngati lamulo likuphatikizidwa muzokhazikitsidwa, zomwe zikutanthauza kuti mawu operekedwa kapena mawuwo ayenera kusinthidwa.

Kuti mupite ku dikishonaleyi dinani pa batani. "Kupatula" ....

Mawindo otsala amatsegulidwa. Monga mukuonera, ili ndi ma tabu awiri. M'kuyamba kwa iwo ndi mawu, kenako dontho silikutanthauza mapeto a chiganizo, ndi kuti mawu otsatirawa ayambe ndi kalata yaikulu. Izi ndizo zilembo zosiyana (mwachitsanzo, "pukuta."), Kapena mbali za mawu osankhidwa.

Tabu yachiwiri ili ndi zosiyana, zomwe simukusowa kuti muike mndandanda wa makalata awiri ofunika mzere. Mwachindunji, mawu amodzi omwe akupezeka m'gawo lino la dikishonale ndi "CCleaner". Koma, mungathe kuwonjezera chiwerengero cha mau ena ndi mawu ena, monga kupatulapo kuti mutenge nawo, mofanana ndi momwe tafotokozera pamwambapa.

Monga momwe mukuonera, AutoCorrect ndi chida chothandiza kwambiri chothandizira kukonza zolakwika kapena zolemba zolakwika polemba mawu, zizindikiro kapena mafotokozedwe a Excel. Mukakonzekera bwino, ntchitoyi idzakhala mthandizi wabwino, ndipo idzapulumutsa nthawi yowunika ndikukonza zolakwika.