Yambitsani, zimitsani, ndikusintha AutoCorrect mu Excel

Pamene mukugwira ntchito mu Excel spreadsheets, makamaka pamene mukuyenera kuthana ndi kuchuluka kwa deta, pali kuthekera kopanga zolakwika, monga typo. Komanso, ogwiritsa ntchito ena, chifukwa chakuti sadziwa kupeza ndi kugwiritsa ntchito zilembo zapadera, amasankha kuwasintha ndi zomveka komanso zopezeka. Mwachitsanzo, m'malo mwa chizindikiro “- - kalata wamba "Ndi", kapena m'malo mwake "$" - mwachidule "S". Komabe, chifukwa cha chida chapadera "AutoCorrect" zinthu zoterezi zimangokonzedwa zokha.

Kodi AutoCorrect ndi chiyani

Excel imasunga m'chikumbukiro chake mndandanda wa zolakwika zomwe zimachitika nthawi zambiri. Wogwiritsa ntchito akalowetsa zolakwika kuchokera pamndandandawu, pulogalamuyo imangosintha ndi mtengo wolondola. Izi ndi zomwe zikufunika Zolondola, ndipo umo ndi momwe zimagwirira ntchito.

Chida ichi chimakonza zolakwika zazikuluzikulu izi:

• zilembo zazikulu ziwiri zotsatizana m'mawu amodzi
• yambani chiganizo chatsopano ndi zilembo zing'onozing'ono
• zolakwika chifukwa choyatsa Caps Lock
• typos ndi zolakwika zina

Yambitsani ndi kuletsa kukonza zokha

Mu pulogalamuyi, ntchitoyi imayambitsidwa, koma nthawi zina imafunika kuyimitsa (kwamuyaya kapena kwakanthawi). Tinene kuti tifunika kulakwitsa m'mawu ena kapena kugwiritsa ntchito zilembo zomwe pulogalamuyo imazindikira kuti ndi zolakwika ndikulowa m'malo mwake, ngakhale sitikufuna izi. Ngati musintha mawonekedwe omwe asinthidwa kukhala omwe tikufuna, ntchitoyi sidzasinthanso. Njirayi ndi yoyenera pamilandu yakutali. Apo ayi, kuti mupulumutse nthawi ndi khama, njira yabwino kwambiri ndiyo kulepheretsa ntchitoyi "AutoCorrect".

1. Pitani ku menyu "Fayilo".
2. M'mbali menyu kumanzere, pitani ku "Parameters".
3. Pazenera la zoikamo lomwe limatsegulidwa, dinani kachigawo "Kalembedwe". Kumanja kwa zenera, dinani batani "AutoCorrect Options".
4. A zenera ndi zoikamo ntchito adzaonetsedwa pa zenera. Chotsani cholembera m'bokosi pafupi ndi njirayo "Sinthani momwe mukulembera", kenako dinani OK.
5. Pulogalamuyi idzatibwezera ku zenera lalikulu ndi magawo, pomwe timakanikizanso batani OK.

Zindikirani: kuti muyambitsenso ntchitoyi, bweretsani cholembera pamalo ake, pambuyo pake, sunganinso zosinthazo ndikudina batani. OK.

Deti autocorrect ndi mavuto zotheka

Nthawi zina zimachitika kuti mukulowetsa nambala yokhala ndi madontho, pulogalamuyo imawongolera tsikulo. Tinene kuti talemba nambala 3.19 ku cell yopanda kanthu.

Tikamaliza kukanikiza kiyi Lowani, Pezani zambiri za mwezi ndi chaka.

Tiyenera kusunga deta yoyambirira yomwe tidayika mu selo. Zikatero, palibe chifukwa choletsa autocorrect. Nazi zomwe timachita:

1. Choyamba, sankhani kuchuluka kwa maselo omwe tikufuna kuwonjezera zofunikira mu mawonekedwe a manambala okhala ndi madontho. Ndiye kukhala mu tabu "Pofikira" pitani ku gawo la zida "Nambala", pomwe timadina pazosankha zamaselo apano.
2. Pa mndandanda wotsitsa, sankhani chinthucho "Mawu".
3. Tsopano titha kuloŵa mosamala deta m'maselo ngati manambala okhala ndi madontho.Zindikirani: muyenera kukumbukira kuti manambala m'maselo omwe ali ndi mawonekedwe amtundu sangathe kutenga nawo mbali powerengera, chifukwa amazindikiridwa ndi pulogalamuyo mwanjira ina ndipo zotsatira zake zomaliza zidzasokonezedwa.

Kukonza mtanthauzira mawu wolondola

Monga tanenera kale, cholinga cha autocorrect ndi kuthandiza kukonza zolakwika kapena typos. Pulogalamuyi poyamba imapereka mndandanda wa mawu ofananira ndi zizindikiro kuti alowe m'malo, komabe, wogwiritsa ntchito ali ndi mwayi wowonjezera zosankha zawo.

1. Apanso timalowa pawindo ndi magawo olondola, motsogozedwa ndi njira zomwe tafotokozazi (menyu "Fayilo" - gawo "Parameters" - gawo "Kalembedwe" - batani "AutoCorrect Options").
2. Mu "Bwezerani" timalemba chizindikiro (mawu), chomwe chidzadziwikanso ndi pulogalamuyo ngati cholakwika. M'munda "Pa" tchulani mtengo womwe ungagwiritsidwe ntchito ngati cholowa m'malo. Mukakonzeka, dinani batani "Onjezani".
3. Zotsatira zake, titha kuwonjezera ku dikishonale iyi zolemba zonse zodziwika bwino ndi zolakwika zomwe timapanga (ngati sizili pamndandanda woyambirira), kuti tisataye nthawi pakuwongolera kwawo.

Kusinthana ndi zizindikiro za masamu

Pitani ku tabu ya dzina lomwelo muzosankha za autocorrect. Apa tipeza mndandanda wazinthu zomwe zidzasinthidwe ndi pulogalamu yokhala ndi zizindikiro zamasamu. Izi ndizothandiza kwambiri mukafuna kuyika munthu yemwe sali pa kiyibodi. Mwachitsanzo, kulowa khalidwe "alpha" (alpha), zidzakwanira kulemba "Alpha", pambuyo pake pulogalamuyo imalowetsa mtengo womwe wapatsidwa ndi mawonekedwe ofunikira. Makhalidwe ena amalowetsedwa mofananamo.

Komanso, mutha kuwonjezera zomwe mungasankhe pamndandandawu.

Kuchotsa kuphatikiza pa autocorrect

Kuti muchotse kuphatikiza kosafunikira kwa mawu kapena zizindikilo pamndandanda wolondola, ingosankhani ndikudina mbewa, kenako dinani batani. "Chotsani".

Komanso, powunikira machesi ena, m'malo mochotsa, mutha kusintha gawo limodzi mwamagawo ake.

Kukhazikitsa magawo akuluakulu a autoreplacement

Magawo akuluakulu akuphatikizapo zoikamo zonse zomwe zingapangidwe mu tabu "AutoCorrect". Zosankha zotsatirazi zimayambitsidwa mu pulogalamuyi:

• kuwongolera zilembo zazikulu ziwiri (zikulu) kumayambiriro kwa mawu;
• lemberani zilembo zazikulu chilembo choyamba cha chiganizocho;
• kuwerengera masiku a sabata;
• kuchotsa zolakwika zomwe zachitika chifukwa cha makiyi otinikizidwa mwangozi Mawonekedwe a Caps.

Kuti mutsegule zosankhazi, ingochotsani bokosi lomwe lili pafupi ndi izo, ndiyeno dinani batani OK kusunga kusintha.

Kugwira ntchito ndi zosiyana

Pulogalamuyi ili ndi dikishonale yapadera yomwe imasunga mawu ndi zizindikiro zomwe autocorrect sizingagwire ntchito, ngakhale ntchitoyi itathandizidwa ndipo pali machesi ofunikira pazigawo zazikulu.

Kuti mupeze mtanthauzira mawu awa, dinani batani "Kupatulapo".

Iwindo lomwe likuwoneka lili ndi ma tabu awiri:

Kalata yoyamba

• Nawu mndandanda wa mawu otsatiridwa ndi chizindikiro "mfundo" (".") sayenera kutanthauziridwa ndi pulogalamu monga mapeto a chiganizo, kutanthauza kuti liwu lotsatira lidzayamba ndi zilembo zazing'ono. Kwenikweni, izi zikugwira ntchito ku mitundu yonse yachidule, mwachitsanzo, kg., g., rub., wapolisi. ndi zina.
• Pamwambamwamba, tikhoza kuyika mtengo wathu, womwe udzawonjezedwa pamndandanda wotsalira pambuyo podina batani lolingana.
• Komanso, posankha mtengo wina pamndandanda, mutha kusintha kapena kuchotsa.

Zilembo zazikulu ziwiri

Makhalidwe ochokera pamndandanda womwe uli patsamba lino, wofanana ndi mndandanda womwe uli patsamba “Chilembo choyamba”, sichidzakhudzidwa ndi AutoCorrect. Pano tikhoza kuwonjezera, kusintha kapena kuchotsa zinthu zatsopano.

Kutsiliza

Chifukwa cha ntchito "AutoCorrect" ntchito mu Excel imathandizira kwambiri, popeza pulogalamuyo imangokonza zolakwika ndi zolakwika zopangidwa ndi wogwiritsa ntchito. Chida ichi ndi chamtengo wapatali makamaka pogwira ntchito ndi deta yambiri. Chifukwa chake, ndikofunikira kwambiri muzochitika zotere kuti muzitha kugwiritsa ntchito moyenera ndikukonza magawo a autocorrect.