AutoCorrect mu Excel. Momwe mungayambitsire, kuzimitsa ndikusintha

Pogwiritsa ntchito spreadsheet, ogwiritsa ntchito ambiri, akugwira ntchito ndi zambiri zambiri, amapanga zolakwika zosiyanasiyana powerengera kapena kupanga typos. Kuphatikiza apo, anthu ena sadziwa momwe angawonjezerere zilembo zapadera ndikugwiritsa ntchito zilembo zina zomwe sizikugwirizana ndi ntchito m'malo mwake. Pulogalamuyi ili ndi gawo lapadera lotchedwa "AutoCorrect", lomwe limakupatsani mwayi wokonza zolowera zolakwika.

Kodi "AutoCorrect" ndi chiyani

Purosesa ya Excel spreadsheet imasunga m'makumbukidwe ake zolakwika zosiyanasiyana zopangidwa ndi ogwiritsa ntchito akamagwira ntchito ndi chidziwitso cha tabular. Ngati wogwiritsa ntchitoyo alakwitsa, pulogalamuyo imangosintha kuti ikhale yoyenera. Zonsezi zimatheka chifukwa cha chida cha AutoCorrect. Zosintha zokha zimakonza zolakwika izi:

• zolakwika zomwe zidapangidwa chifukwa chophatikizidwa ndi Caps Lock;
• yambani kulowetsa chiganizo chatsopano ndi chilembo chaching'ono;
• zilembo zazikulu ziwiri pamzere mu liwu limodzi;
• zolakwa zina wamba ndi typos opangidwa ndi ogwiritsa.

Malo Oyikira

Zindikirani kuti m'malo mwaokha ndi chida cha Pezani ndi Kusintha ndi zosankha ziwiri zosiyana. Pachida choyamba, spreadsheet imasanthula paokha mawu otayidwa ndikuyikanso m'malo mwake, ndipo chachiwiri, zosintha zonse zimachitidwa ndi wogwiritsa ntchito mu spreadsheet.

Mndandanda wonse wamawu osinthidwa umapezeka muzokonda za Excel. Kuti muwone zomwe zili patsamba ili, tsatirani njira zosavuta izi:

1. Timadina batani lalikulu lomwe lili kumtunda kumanzere kwa mawonekedwe, kenako dinani "Zikhazikiko".

2. Pazenera lomwe likuwoneka, dinani pamzere wa "Spelling" ndikusunthira kumenyu yosinthira kuti musinthe.

3. Muwindo latsopano lomwe likuwonekera pazenera, mutha kuwona magawo a ntchito. Palinso tebulo la zitsanzo zosintha zilembo kapena mawu.

Dziwani kuti malo a ntchitoyi ndi ofanana m'mitundu yonse, nthawi zina kupeza magawo kumayamba ndikudina "Fayilo".

Kusaka kwazinthu

Tiyeni tiwone mwatsatanetsatane momwe tingafufuzire zomwe zili muzolemba. Kuyenda:

1. Pitani ku gawo la "Sinthani", ndiyeno dinani batani la "Pezani". Mutha kufika pazenerali mwa kukanikiza kuphatikiza kiyi "Ctrl + F".

2. Pa mzere wa "Pezani" muyenera kuyika mtengo womwe mukufuna kupeza muzolemba. Pambuyo kulowa deta, dinani "Pezani Kenako". Pazenera, pali zosefera zosiyanasiyana zowonjezera zomwe zili mugawo la "Zosankha".

Ziyenera kumveka kuti mukadina batani la "Pezani Kenako", pulogalamuyo iwonetsa mawu oyandikira kwambiri ndikuwonetsa mu chikalatacho. Kugwiritsa ntchito "Pezani Zonse" kumakupatsani mwayi wowonetsa zonse zomwe zili m'chikalatacho.

Kusintha kwachitsanzo

Nthawi zambiri zimachitika kuti wosuta sayenera kupeza mawu mu chikalata, komanso m'malo ndi zina deta. Ndondomeko ya sitepe ndi sitepe kuti mugwire ntchitoyi:

1. Pitani ku bokosi losakira monga tafotokozera pamwambapa.

2. Tsopano timapita ku gawo lotchedwa "Bwezerani".
3. Pali mzere watsopano "Bwezerani ndi". Mu mzere wa "Pezani" timayendetsa mawu oti tifufuze, ndipo mumzere "Bwezerani ndi", timayendetsa mtengo womwe tikufuna kusinthira chidutswa chomwe tapeza. Mwa kupita ku gawo la "Zosankha", mutha kugwiritsa ntchito zosefera zosiyanasiyana kuti mufulumizitse ntchitoyo ndi chidziwitso.

Yambitsani ndi kuletsa kukonza zokha

Mwachisawawa, zosintha zokha mu spreadsheet zimayatsidwa. Pali nthawi yomwe imayenera kuzimitsidwa kuti polowetsa chidziwitso, pulogalamuyo isawone kuti anthu ena ndi olakwika. Chitsogozo cha pang'onopang'ono kuti muyimitse zosintha zokha:

1. Pitani ku gawo la "Fayilo".

2. Pamndandanda wakumanzere wa zinthu, sankhani "Zikhazikiko".

3. Pazenera la zosankha zomwe zikuwoneka, sankhani gawo la "Spelling". Kenako, dinani Zosankha za AutoCorrect.

4. Zenera latsopano likuwonekera ndi zoikamo za parameter. Apa muyenera kuchotsa bokosi pafupi ndi mawu akuti "Bwezerani momwe mukulembera", kenako dinani "Chabwino".

5. Tsambali lidzatengera wosuta kuwindo lapitalo, momwe muyenera kudina "Chabwino" kachiwiri.

Chenjerani! Kuti muyambitsenso ntchitoyi, muyenera kubwezera cholembera pafupi ndi mawu akuti "Bwezerani momwe mukulembera" ndikudina "Chabwino".

Deti autocorrect ndi mavuto zotheka

Pali nthawi zina pomwe wogwiritsa ntchito amayendetsa zidziwitso za manambala ndi madontho, ndipo purosesa ya spreadsheet imasintha payokha kukhala deti. Kuti musunge zidziwitso zoyambirira mu cell popanda kusintha, muyenera kuchita izi:

1. Timasankha ma cell angapo momwe timakonzekera kuyikamo manambala okhala ndi madontho. Pitani ku gawo la "Home", ndiyeno pitani ku tabu "Nambala". Dinani pakusintha kwamtundu wa cell.

2. Mndandanda wawung'ono wokhala ndi mawonekedwe osiyanasiyana wawululidwa. Dinani "Text".

3. Pambuyo pakusintha, mutha kulowetsa deta m'maselo pogwiritsa ntchito madontho.

Ndikofunika kumvetsetsa kuti zidziwitso za manambala m'maselo okhala ndi zolemba sizingasinthidwe ndi pulogalamu ngati manambala.

Kuwongolera mokhazikika ndi zizindikiro za masamu

Tsopano tiyeni tiwone momwe njira yosinthira ndi zizindikiro za masamu zimachitikira. Choyamba muyenera kupita ku zenera la "AutoCorrect", ndiyeno gawo la "AutoCorrect with Mathematical Symbols". Izi ndizothandiza komanso zothandiza popeza zizindikiro zambiri za masamu sizili pa kiyibodi. Mwachitsanzo, kuti muwonetse chithunzi cha ngodya mu selo, muyenera kungolowetsa lamulo la ngodya.

Mndandanda wa masamu omwe ulipo ukhoza kuwonjezeredwa ndi mfundo zake. Kuti muchite izi, lowetsani lamulo lanu m'munda woyamba, ndi chikhalidwe chomwe chidzawonetsedwa polemba lamulo ili m'munda wachiwiri. Pomaliza, dinani "Add" batani, ndiyeno "Chabwino".

Kukonza mtanthauzira mawu wolondola

Ntchito yayikulu yosinthira zokha ndikuwongolera ma typos ndi zolakwika pazomwe wogwiritsa ntchito adalemba. Dikishonale yapadera imaphatikizidwa mu purosesa ya spreadsheet, yomwe ili ndi mndandanda wa mawu ndi zizindikiro zosinthidwa zokha. Mutha kuwonjezera zomwe mumakonda mudikishonale iyi, zomwe zipangitsa kuti ntchitoyi ikhale yosavuta ndi purosesa ya spreadsheet. Kuyenda:

1. Timasunthira pawindo ndi magawo osinthika okha, pogwiritsa ntchito njira yomwe tafotokozayi.
2. Mu mzere wa "Bwezerani", muyenera kulowetsa khalidwe kapena mawu, omwe m'tsogolomu pulogalamu ya spreadsheet idzatenga ngati cholakwika. Mu mzere "Pa" muyenera kulowa mtengo womwe udzagwiritsidwe ntchito m'malo mwa cholakwacho. Pambuyo kulowa zonse zofunika, dinani "Add".

3. Momwemonso, mutha kuwonjezera zomwe mumakonda kuchokera mumtanthauzira mawu, kuti pambuyo pake musataye nthawi kuzikonza.

Kuchotsa zosafunika pa mndandanda wa zosintha basi, muyenera kusankha osakaniza osafunika, ndiyeno dinani "Chotsani". Posankha mtengo, simungangochotsa, komanso kusintha.

Kukhazikitsa zosankha zazikulu zowongolera zokha

Makhalidwe akuluakulu amaphatikizapo magawo onse omwe ali mu gawo la "AutoCorrect". Mwachisawawa, spreadsheet ili ndi mitundu ya zowongolera zomwe zikuwonetsedwa pachithunzichi:

Kuti muzimitsa chizindikiro chilichonse, muyenera kungochotsa bokosi lomwe lili pafupi ndi izo, ndiyeno, kuti musunge zosintha zomwe zalowa, dinani "Chabwino".

Kugwira ntchito ndi zosiyana

Spreadsheet ili ndi dikishonale yapadera yapadera yomwe imakulolani kuti muwonetsetse kuti zosintha zokha sizikugwiritsidwa ntchito pamikhalidwe yomwe ili mudikishonale iyi. Chitsogozo cha pang'onopang'ono pogwira ntchito ndi mtanthauzira mawu:

1. Mu bokosi la "AutoCorrect", dinani "Zopatula".

2. Pali magawo awiri apa. Gawo loyamba ndi "Letter First". Gawoli likufotokoza zofunikira zonse pambuyo pake "nthawi" siidziwika ndi pulogalamu ngati mapeto a chiganizo. Mwa kuyankhula kwina, pambuyo polowa m’nyengo, liwu lotsatira lidzayamba ndi chilembo chaching’ono. Kuti muwonjezere zikhalidwe zanu, muyenera kuyika mawu atsopano pamzere wapamwamba, kenako dinani "Onjezani". Ngati mungasankhe chizindikiro chilichonse pamndandanda, mutha kuchisintha kapena kuchichotsa.

3. Gawo lachiwiri ndi "Ma Capital Awiri". Apa, monga tabu yapitayi, mutha kuwonjezera zomwe mumakonda, komanso kusintha ndikuzichotsa.

Kusiyana kwa Mtundu wa Excel

Maupangiri onse pamwambapa ndi ogwiritsidwa ntchito ndi ma processor a 2007, 2010, 2013, ndi 2019. Mu mkonzi wa 2003, njira yokhazikitsira m'malo mwake imachitika mwanjira ina, ndipo zinthu zazikulu zili m'malo osiyanasiyana. Kuyenda:

1. Dinani pa "Service" gawo.
2. Dinani pa "Zikhazikiko" chinthu.

3. Imapita ku tabu ya Zolemba.

4. Pali njira zitatu zopangira zosintha zokha.

5. Kuti musinthe zosintha zokha, dinani chinthu cha "AutoCorrect Options".

6. Zenera lodziwika bwino likuwonekera. Palibe kuyika kwa zizindikiro za masamu, chifukwa magawo onse ali pamalo amodzi. Timapanga zosintha zonse zofunika ndikudina batani "Chabwino".

Malangizo apakanema

Ngati malangizo onse omwe ali pamwambawa sakukwanira, ndiye kuti mutha kuwona vidiyoyi:

Imafotokoza za ma nuances onse owonjezera a bukuli. Pambuyo powonera kanemayo, muphunzira zambiri zowonjezera zomwe zingakuthandizeni kuthetsa mavuto onse pamene mukugwira ntchito ndi zosintha zokha mu spreadsheet.

Kutsiliza

Ntchito yosinthira yokha imakupatsani mwayi wofulumizitsa kwambiri ntchito ndi chidziwitso cha tabular. Chidacho chimakhala chothandiza kwambiri pogwira ntchito ndi chidziwitso chachikulu. Ndikofunikira kwambiri kuti mugwiritse ntchito moyenera ndikukonza izi zothandiza.